8 Replies Latest reply: Oct 12, 2012 1:05 PM by Hussein Sawwan-Oracle RSS

    not generating trace file for rdf report through oracle apps

    800528
      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
          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
            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
              +
              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
                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
                  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
                    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
                      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
                        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