<-----Google Analytics Code Start----> <-----Google Analytics Code Close---->
Skip to content



Default screen resolution  Wide screen resolution  Increase font size  Decrease font size  Default font size  Skip to content Default color Pink color Green color Green color
Home arrow Technical Articles arrow Miscellaneous Technology arrow Factors effecting SQL Results in Oracle Apps
This website has now moved to http://apps2fusion.com

Factors effecting SQL Results in Oracle Apps | Print |  E-mail
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
    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.

written by Anil Passi , November 25, 2007
Hi Deb

Please right click on that link and save the file.

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 ?

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


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

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.

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

Save this ppt and open the same using Google Docs.

Anil Passi
Anyone send the uncorrupted ppt/pps
written by Ram P , November 28, 2007
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.


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

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

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

Thanking You
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 ?

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