Oracle Application

Xdoxslt XML Publisher RTF Important Syntax’s     1.        To convert CASE of a tag to UPPER case      xdoxslt:convert_case(.//MATERIALTYPE,'UPPER')     2.        To convert CASE of a tag to LOWER case      xdoxslt:convert_case(.//MATERIALTYPE,'UPPER')     3.        Syntax for CONTAIN      contains(xdoxslt:convert_case(.//MATERIALTYPE,'UPPER'),’IC CREDIT MEMO’)     4.        Syntax for NOT CONTAIN      not(contains(xdoxslt:convert_case(.//REFERENCE_ID,'UPPER'),'WSC'))     5.        CHOOSE-WHEN-OTHERWISE Syntax     <?choose:?><?when: contains(xdoxslt:convert_case(.//MATERIALTYPE,'UPPER'),’IC CREDIT       MEMO’)?><?’Interco Credit Memo’?><?end when?><?otherwis...

How to Trace a Concurrent Request And Generate TKPROF File 1. Enable Tracing For The Concurrent Manager Program · Responsibility: System Administrator · Navigate: Concurrent > Program > Define · Query Concurrent Program · Select the Enable Trace Checkbox Turn On Tracing · Responsibility: System Administrator · Navigate: Profiles > System · Query Profile Option Concurrent: Allow Debugging · Set profile to Yes Run Concurrent Program With Tracing Turned On · Logon to the Responsibility that runs the Concurrent Program · In the Submit Request Screen click on Debug Options (B) · Select the Checkbox for SQL Trace 2. Find Trace File Name Run the following SQL to find out the Raw trace name and location for the concurrent program. The SQL prompts the user for the request id SELECT 'Request id:'||request_id , 'Trace id: '||oracle_Process_id, 'Trace Flag: '||req.enable...

How do you enable/disable a trace to a Concurrent Program? 1. Connect to Oracle Applications 2. Navigate to System Administrator->Concurrent->Program->Define 3. Query the concurrent program on which you want to enable trace. 4. Check the enable trace check box bottom of the screen, Save it. 5. Ask the developer to submit the request, Once the request got submitted and completed normal. 6. Get the spid as select oracle_process_id from apps.fnd_concurrent_requests where request_id=456624. 7. You will get a spid like 12340. 8. Goto Udump and ls -ltr *12344*. 9 . You will get trace file

How do you enable/disable a trace to a Oracle Application Forms Session? (Other Way) 1. Get the serial #, sid of particular form session by navigating Help->about Oracle applicatins 2. Connect to database using sqlplus with relavant user 3. execute dbms_system.set_sql_trace_in_session(2122,332,TRUE); 4. Select spid from v$process where addr=(select paddr from v$session where sid=2122); 5. You will get spid like 4515 for above statement 6. Goto udump location and type ls -ltr *4515* you will get trace file To disable Trace Session 1. execute dbms_system.set_sql_trace_in_session(2122,332,FALSE);

How do you enable/disable a trace to a Oracle Application Forms Session? 1. Connection to Oracle Applications 2. Navigate to the particular form, which you want trace to be enabled 3. Goto Menu Help->Diagnostics->Trace->Regular Trace and select it 4. It will ask you for Apps Password. Provide it 5. Then it will show the file path where trace is going to be generated 6. Ask developer to perform their transactions, once they are done disable the trace 7. Goto to that location to get the trace file 8. Get the trace out put file using tkprof with different options To disable Trace Session Goto Menu Help-> Diagnostics->Trace->No Trace

Views: Step1: Create a Temporary Table based on ALL_VIEWS View. create table search_all_views as select  av.owner, av.view_name, to_lob(text) as text_clob from    ALL_VIEWS av; Step2: Search based on Part of text based on Temporary table created in Step1.  select * from search_all_views where text_clob like '%Enter Text Here%' Step3) Drop the Temporary Table created in Step1. drop table search_all_views; Materialized Views: Step1: Create a Temporary Table based on ALL_MVIEWS View. create table search_all_mviews as select  av.owner, av.mview_name, to_lob(query) as text_clob from    ALL_MVIEWS av; Step2: Search based on Part of text based on Temporary table created in Step1.  select * from search_all_mviews where text_clob like '%xwii_osp_util_pk.get_osp_name_locator%' Step3) Drop the Temporary Table created in Step1. drop table search_all_mviews