Factors effecting SQL Results in Oracle Apps

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

Set as favorite

Bookmark

Email This

Comments (12)

Subscribe to this comment's feed

...
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

report abuse

vote down

vote up

Votes: +0

...
written by Anil Passi , November 25, 2007

Hi Deb

Please right click on that link and save the file.

Thanks,
Anil Passi

report abuse

vote down

vote up

Votes: +0

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

report abuse

vote down

vote up

Votes: +0

...
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"

report abuse

vote down

vote up

Votes: +0

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

report abuse

vote down

vote up

Votes: +0

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

report abuse

vote down

vote up

Votes: +0

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

report abuse

vote down

vote up

Votes: +0

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

Hi Ram

Save this ppt and open the same using Google Docs.

Thanks,
Anil Passi

report abuse

vote down

vote up

Votes: +1

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 This e-mail address is being protected from spambots. You need JavaScript enabled to view it '> This e-mail address is being protected from spambots. You need JavaScript enabled to view it .

Thanks in Advance
Ram P

report abuse

vote down

vote up

Votes: +0

...
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

report abuse

vote down

vote up

Votes: +0

...
written by abhiram , December 18, 2007

Hi Anil

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

Thanking You
Abhiram

report abuse

vote down

vote up

Votes: +0

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