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

Green

color

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

Who's Online

We have 6 guests online

Related Items

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