|Receive Email for New Articles|
|Factors effecting SQL Results in Oracle Apps||| Print ||
|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 :-
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
written by Debojyoty Sadhukhan , November 25, 2007
Still problems with the pps file
written by Robert Azzopardi , November 25, 2007
Factors effecting SQL Results in Oracle Apps
written by Vikash77 , November 26, 2007
written by balkrishna1 , November 26, 2007
Problem with the file
written by Ram P , November 27, 2007
written by Anil Passi. , November 27, 2007
Anyone send the uncorrupted ppt/pps
written by Ram P , November 28, 2007
written by abhiram , December 18, 2007
written by ametta , January 16, 2008