This discussion is archived
8 Replies Latest reply: Oct 12, 2012 11:05 AM by Hussein Sawwan-Oracle RSS

not generating trace file for rdf report through oracle apps

800528 Newbie
Currently Being Moderated
Hi to all


actually we are aiming to generating trace file for reports & an convert to text file using tkprof through unix shell script concurrent program submit by using fnd_request.submit_request in another concurrent procedure program . but all reports such as which are created using pl/sql generates trace file but rdf report is not generating trace file.

oracle report builder 6i is used

oracle application is 11i

list of steps are taken to get trace file are
1.SRW.USER_EXIT('FND SRWINIT'); in before report trigger
2SRW.USER_EXIT('FND SRWEXIT'); in after report trigger

another steps that are followed
srw.do_sql('alter session set SQL_TRACE = TRUE');in before report trigger
srw.do_sql('alter session set SQL_TRACE = FALSE'); in after report trigger

above said steps are done but still it is not generating any trace file

even oracle_process is null

Select oracle_process_id from fnd_concurrent_requests where request_id

oracle processid for that oracle report rdf file is not generated


please help me in this issue

thanks

Edited by: 797525 on 12 Oct, 2012 12:43 AM
  • 1. Re: not generating trace file for rdf report through oracle apps
    597001 Journeyer
    Currently Being Moderated
    Add the following line in Before Report Trigger
    SRW.DO_SQL ('alter session set events=''10046 trace name context forever, level 4'' tracefile_identifier=''REPORT')

    Trace will automatically turn off when the report ends.

    Moreover, Which program submits the fnd_request.submit_request...shell script / pl/sql procedure ?

    Did u initialize apps FND_GLOBAL.APPS_INITIALIZE before firing submit_request?

    Do a FND: Debug Log Enabled = Yes and check the fnd_log_messages table

    Refer the following MOS docs:
    Tracing in Oracle Reports 6i [ID 111311.1]
    Cheers,
    ND
    Use the "helpful" or "correct" buttons to award points to replies.
  • 2. Re: not generating trace file for rdf report through oracle apps
    800528 Newbie
    Currently Being Moderated
    thanks sir,

    i have doubt

    Rdf Report which run separetely and trace enabled in program defintition as well as srw.do_sql(alter session sql_trace set =yes) in before report

    and concurrent program run separtely which take trc file generate from reports(in my case rdf report is not genaerating trc file) and convert to readable txt file using unix shell script which submitted as concurrent program using fnd_request.submit_request .

    that procedure which also concurrent program which inturn call fnd_request.submit_request which unix shell script

    so we used srw.do_sql(alter session sql_trace set =yes) in before report trigger in oracle report builder 6i.

    it is rdf report and it is generating xml publisher pdf format .


    i didn't give FND_GLOBAL.APPS_INITIALIZE for fnd_request.submit_request which unix shell script .


    as it is generates trace file for reports that are developed using pl/sql .

    my problem it is not generating trace file when it is execute in oracle apps .

    please help in this regard
  • 3. Re: not generating trace file for rdf report through oracle apps
    597001 Journeyer
    Currently Being Moderated
    +
    i didn't give FND_GLOBAL.APPS_INITIALIZE for fnd_request.submit_request which unix shell script.
    +
    Whenever you are calling a routine in EBS you should make a practice to initialize apps.

    Refer the following MOS docs:
    How To Set the Applications Context (FND_GLOBAL.APPS_INITIALIZE) [ID 209185.1]
    Oracle Applications Multiple Organizations Access Control for Custom Code [ID 420787.1]
    How To Retrieve Rows From Table Or Synonym For An ORG_ID In E-Business Suite 12 [ID 787677.1]

    Cheers,
    ND
    Use the "helpful" or "correct" buttons to award points to replies.
  • 4. Re: not generating trace file for rdf report through oracle apps
    800528 Newbie
    Currently Being Moderated
    thanks for reply

    but you are not getting my point .

    i am running rdf file with trace enabled separately. which is not generating trace file .

    then call procedure concurrent program it is again inturn call unix shell script which converts trace file to text file .

    but trace file itself is not created .




    oracle application is 11i
    Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
    PL/SQL Release 10.2.0.4.0 - Production
    CORE     10.2.0.4.0     Production
    TNS for Solaris: Version 10.2.0.4.0 - Production
    NLSRTL Version 10.2.0.4.0 - Production

    oracle report builder 6i

    please help me to generate trace file

    Edited by: 797525 on 12 Oct, 2012 3:21 AM
  • 5. Re: not generating trace file for rdf report through oracle apps
    597001 Journeyer
    Currently Being Moderated
    i am running rdf file with trace enabled separately. which is not generating trace file.
    Is it a D2k or Oracle Apps report? From where r u submitting the Report?

    As I have told you can trace precisely in two ways:
    1. Put this in before report trigger instead of what you were doing before.
    SRW.DO_SQL ('alter session set events=''10046 trace name context forever, level 4'' tracefile_identifier=''REPORT')
    2. i) Open your report (.rdf) in with Report Builder 6i.
    ii) Choose Tools > Trace.
    iii) Select All.

    Recompile the report and place in Unixbox

    Follow the below procedure if your report is 10.7

    a. Convert the report from rdf to rex:
    $ORACLE_HOME/bin/r25convm batch=yes userid=<apps username/pwd>> stype=rdffile source=REPORT_NAME.rdf dtype=rexfile overwrite=yes
    b. Edit the rexfile and search for the beforerep trigger in the report.
    Locate the following code:
    IF (:p_trace_switch = 'Y') THEN
    SRW.DO_SQL('alter session set sql_trace TRUE');
    END IF;
    Comment out the IF and END IF lines.
    c. Save the report.
    d. Convert the report from rex to rdf:

    It would definitely generate the trace file. Look for the trace file in the following with the timestamp you started executing the report.
    select value from V$PARAMETER where name = 'user_dump_dest'

    Cheers,
    ND
    Use the "helpful" or "correct" buttons to award points to replies.
  • 6. Re: not generating trace file for rdf report through oracle apps
    800528 Newbie
    Currently Being Moderated
    thanks for replying


    it is oracle apps report rdf submit through srs .
  • 7. Re: not generating trace file for rdf report through oracle apps
    Srini Chavali-Oracle Oracle ACE Director
    Currently Being Moderated
    Pl see the steps in this MOS Doc

    How To Trace a Concurrent Request And Generate TKPROF File [ID 453527.1]

    HTH
    Srini
  • 8. Re: not generating trace file for rdf report through oracle apps
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    please help me to generate trace file
    FAQ: Common Tracing Techniques within the Oracle Applications 11i/R12 [ID 296559.1] -- 4. How does one enable trace for a concurrent program?
    How To Create Trace File and Run Tkprof in E-Business Suite Applications - Condensed Version [ID 141278.1]

    Thanks,
    Hussein

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points