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
Apps2Fusion Articles 
Comments
Thanks,
-Debojyoty
Please right click on that link and save the file.
Thanks,
Anil Passi
PPS file will not open in PPT ? Maybe it is corrupt ?
thanks
Rober t
apps2fusion.com/docs_apps/demo/misc/Debugging_Running_the_SQL.ppt
Thanks,
Anil Passi
PS- If prompted for password, then click on button "Read Only"
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.
Th anks & Regards.
Vikash Kumar
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
Than ks
balkrishna
I m facing the problem with both files.
Thanks
Ram
Save this ppt and open the same using Google Docs.
Thanks,
Anil Passi
Google Docs says the same, 'It can't open'. Can anyone please send the uncorrupted pps/ppt to rp_official
Thanks in Advance
Ram P
I have now uploaded this on google docs.
docs.google.com/Present?docid=dkg3r3j_609hdttms
The formatting is not 100% as per the original presentation, but is manageable.
Th anks,
Anil Passi
The pps is expecting the password. Can you please update us.
Thanking You
Abhiram
Please describe what is the difference between FND_CLIENT_INFO .SET_ORG_CONTEX T and FND_GLOBAL.APPS _INITIALIZE ?
Thanks
RSS feed for comments to this post