Factors effecting SQL Results in Oracle Apps
Written by Anil Passi   
Sunday, 25 November 2007
A starter to Oracle Apps might try to run the Oracle Apps SQL as is.
However, the results of the SQL when run from SQL*Plus can be different from the results seen when the same SQL is executed by Application.

There are various factors that can influence the results of a SQL Statement when run within Oracle eBusiness Suite environment.


The factors that potentially influence results of a SQL Statement are listed below :-
    Profile options
    NLS LANG Settings
    Org_id/MOAC
    HRMS Security Profiles [Org/Position/Custom restrictions]
    Date-Track dependent SQL
    Row Level Security


Please find a powerpoint presentation that explains how each of these can be simulated within your SQL*Plus session.
These steps will help you debug your SQL statements appropriately, by simulating the environment of Oracle Apps onto your SQL*Plus Session.
Click here to view this presentation

Comments (12)add
...
written by Debojyoty Sadhukhan , November 25, 2007
Hi, I was not able to download or view the pps file. Can you please upload again.

Thanks,
-Debojyoty
...
written by Anil Passi , November 25, 2007
Hi Deb

Please right click on that link and save the file.

Thanks,
Anil Passi
Still problems with the pps file
written by Robert Azzopardi , November 25, 2007
Hi Anil

PPS file will not open in PPT ? Maybe it is corrupt ?
thanks

Robert
...
written by Anil Passi , November 25, 2007
Alternately, you could try

http://anilpassi.com/apps/demo...he_SQL.ppt

Thanks,
Anil Passi
PS- If prompted for password, then click on button "Read Only"
Factors effecting SQL Results in Oracle Apps
written by Vikash77 , November 26, 2007
Hi Anil,

i gone through ur .pps it's fantastic. Do you having any doc on Role and Permission of OA_HTML User of Oracle Apps. i am doing one project where we are creating one custom Module in Oracle apps OA Framework, and for page security we require to use Role and Permission.

Thanks & Regards.
Vikash Kumar
Good Article
written by balkrishna1 , November 26, 2007
Hi Anil

the Article gives the total idea bout the other parameters ,regarding HR Security Profile I am unknown to this aarea after reading this article loys of the things from HR is Clarified

Thanks
balkrishna
Problem with the file
written by Ram P , November 27, 2007
Can the ppt/pps be opened using Office 2000.
I m facing the problem with both files.

Thanks
Ram
...
written by Anil Passi. , November 27, 2007
Hi Ram

Save this ppt and open the same using Google Docs.

Thanks,
Anil Passi
Anyone send the uncorrupted ppt/pps
written by Ram P , November 28, 2007
Hi,
Google Docs says the same, 'It can't open'. Can anyone please send the uncorrupted pps/ppt to rp_official@rediffmail.com.

Thanks in Advance
Ram P
...
written by Anil Passi , November 28, 2007
Hi Ram

I have now uploaded this on google docs.

http://docs.google.com/Present..._609hdttms

The formatting is not 100% as per the original presentation, but is manageable.

Thanks,
Anil Passi
...
written by abhiram , December 18, 2007
Hi Anil

The pps is expecting the password. Can you please update us.

Thanking You
Abhiram
query
written by ametta , January 16, 2008
Hi Anil,

Please describe what is the difference between FND_CLIENT_INFO.SET_ORG_CONTEXT and FND_GLOBAL.APPS_INITIALIZE ?

Thanks
You must be logged in to a comment. Please register if you do not have an account yet.

busy