Login
Register

Home

Trainings

Fusion Blog

EBS Blog

Authors

Contact Us

Miscellaneous
  • Register

Oracle Gold Partners, our very popular training packages, training schedule is listed here
Designed by Five Star Rated Oracle Press Authors & Oracle ACE's.

webinar new Click here to raise Support Ticket. Get reply within 48 hours.

Search Courses

Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive
 
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


Anil Passi

Comments   

0 #1 Debojyoty Sadhukhan 2007-11-25 11:32
Hi, I was not able to download or view the pps file. Can you please upload again.

Thanks,
-Debojyoty
Quote
0 #2 Anil Passi 2007-11-25 11:46
Hi Deb

Please right click on that link and save the file.

Thanks,
Anil Passi
Quote
0 #3 Robert Azzopardi 2007-11-25 19:45
Hi Anil

PPS file will not open in PPT ? Maybe it is corrupt ?
thanks

Rober t
Quote
0 #4 Anil Passi 2007-11-25 20:43
Alternately, you could try

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"
Quote
0 #5 Vikash77 2007-11-26 02:01
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.

Th anks & Regards.
Vikash Kumar
Quote
0 #6 balkrishna1 2007-11-26 09:19
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

Than ks
balkrishna
Quote
0 #7 Ram P 2007-11-27 10:38
Can the ppt/pps be opened using Office 2000.
I m facing the problem with both files.

Thanks
Ram
Quote
0 #8 Anil Passi. 2007-11-27 22:40
Hi Ram

Save this ppt and open the same using Google Docs.

Thanks,
Anil Passi
Quote
0 #9 Ram P 2007-11-28 05:36
Hi,
Google Docs says the same, 'It can't open'. Can anyone please send the uncorrupted pps/ppt to .

Thanks in Advance
Ram P
Quote
0 #10 Anil Passi 2007-11-28 07:12
Hi Ram

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
Quote
0 #11 abhiram 2007-12-18 10:49
Hi Anil

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

Thanking You
Abhiram
Quote
0 #12 ametta 2008-01-16 15:27
Hi Anil,

Please describe what is the difference between FND_CLIENT_INFO .SET_ORG_CONTEX T and FND_GLOBAL.APPS _INITIALIZE ?

Thanks
Quote

Add comment


Security code
Refresh

Search Trainings

Fully verifiable testimonials

Apps2Fusion - Event List

<<  Aug 2021  >>
 Mon  Tue  Wed  Thu  Fri  Sat  Sun 
        1
  2  3  4  5  6  7  8
  9101112131415
16171819202122
23242526272829
3031     

Enquire For Training

Fusion Training Packages

Get Email Updates


Powered by Google FeedBurner