10 Replies Latest reply: Feb 6, 2013 5:05 PM by Hussein Sawwan-Oracle RSS

    PRoduction Generation Report Error

    User470870-OC
      Hi

      Can anyone please help me to resolve the below issue.

      Production generation report concurrent program ran on particular dates give error with no output

      Error Codes are REP-0069: Internal error REP-300: ORACLE error occurred,REP-57054: In-process job terminated:Terminated with

      Rgrds,
        • 1. Re: PRoduction Generation Report Error
          Srini Chavali-Oracle
          Pl post details of OS, database and EBS versions, along with the complete log of the concurrent request. Is this a seeded program or a custom one ? Did this execute successfully before using the same parameters ?

          HTH
          Srini
          • 2. Re: PRoduction Generation Report Error
            User470870-OC
            Hi

            OS : RHEL 5.5
            Database : 11.1.0.7
            Applications : R12

            It has run properly before and even now on particular dates is complete with no errors but on particular date like 20-jan-2013 and on some other dates if we try to run the report will not produce any output and log has the below details and its custom one.

            ---------------------------------------------------------------------------
            XXSHM Custom Application: Version : UNKNOWN

            Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

            XXSHMPRODGEN module: SHM Production Generation Report
            ---------------------------------------------------------------------------

            Current system time is 04-FEB-2013 22:04:59

            ---------------------------------------------------------------------------


            +-----------------------------
            | Starting concurrent program execution...
            +-----------------------------

            Arguments
            ------------
            project_id='104'
            Project_Date='2013/01/20 00:00:00'
            ------------

            Forcing NLS_NUMERIC_CHARACTERS to: '.,' for XDO processing

            APPLLCSP Environment Variable set to :

            Current NLS_LANG and NLS_NUMERIC_CHARACTERS Environment Variables are :
            AMERICAN_INDIA.UTF8

            '.,'

            Enter Password:
            REP-0300: ORACLE error occurred.
            REP-0069: Internal error
            REP-57054: In-process job terminated:Terminated with error:
            REP-300: ORACLE error occurred.


            Report Builder: Release 10.1.2.3.0 - Production on Mon Feb 4 22:05:02 2013

            Copyright (c) 1982, 2005, Oracle. All rights reserved.


            ---------------------------------------------------------------------------
            Start of log messages from FND_FILE
            ---------------------------------------------------------------------------
            ---------------------------------------------------------------------------
            End of log messages from FND_FILE
            ---------------------------------------------------------------------------
            Program exited with status 1
            Concurrent Manager encountered an error while running Oracle*Report for your concurrent request 1807985.

            Review your concurrent request log and/or report output file for more detailed information.


            ---------------------------------------------------------------------------
            Executing request completion options...

            Output file size:
            0

            ------------- 1) PUBLISH -------------
            Disabling requested Output Post Processing. Nothing to process. The output of the request is zero byte.
            --------------------------------------


            Finished executing request completion options.

            ---------------------------------------------------------------------------
            Concurrent request completed
            Current system time is 04-FEB-2013 22:05:04

            Rgrds,
            Shubha
            • 3. Re: PRoduction Generation Report Error
              Hussein Sawwan-Oracle
              Enter Password:
              REP-0300: ORACLE error occurred.
              REP-0069: Internal error
              REP-57054: In-process job terminated:Terminated with error:
              REP-300: ORACLE error occurred.
              Please see https://forums.oracle.com/forums/search.jspa?threadID=&q=REP-300&objID=c3&dateRange=all&userID=&numResults=15&rankBy=10001
              Disabling requested Output Post Processing. Nothing to process. The output of the request is zero byte.
              Can you find any errors in the CM/OPP log files?

              Please see https://forums.oracle.com/forums/search.jspa?threadID=&q=Disabling+requested+Output+Post+Processing.++Nothing+to+process.++The+output+of+the+request+is+zero+&objID=c3&dateRange=all&userID=&numResults=15&rankBy=10001

              Thanks,
              Hussein
              • 4. Re: PRoduction Generation Report Error
                Srini Chavali-Oracle
                Pl also open an SR with Support to see if the fix in this MOS Doc is applicable

                Intermittent Oracle Reports REP-0069: REP-57054: Error [ID 1237834.1]

                HTH
                Srini
                • 5. Re: PRoduction Generation Report Error
                  Hussein Sawwan-Oracle
                  Srini Chavali wrote:
                  Pl also open an SR with Support to see if the fix in this MOS Doc is applicable

                  Intermittent Oracle Reports REP-0069: REP-57054: Error [ID 1237834.1]

                  HTH
                  Srini
                  It is a custom concurrent program and I believe Oracle support will not be of much help here.

                  Thanks,
                  Hussein
                  • 6. Re: PRoduction Generation Report Error
                    Hussein Sawwan-Oracle
                    Shubha,

                    Please also see old threads for the similar issue -- https://forums.oracle.com/forums/search.jspa?threadID=&q=REP-0069+AND+REP-57054&objID=c3&dateRange=all&userID=&numResults=15&rankBy=10001

                    Thanks,
                    Hussein
                    • 7. Re: PRoduction Generation Report Error
                      User470870-OC
                      Hi Hussein,

                      I could also see the below error messages in reports.log file
                      REP-0300: ORACLE error occurred.

                      REP-0300: ORACLE error occurred.

                      REP-0300: ORACLE error occurred.

                      REP-0300: ORACLE error occurred.

                      REP-0300: ORACLE error occurred.

                      REP-0300: ORACLE error occurred.

                      REP-0300: ORACLE error occurred.

                      REP-0300: ORACLE error occurred.

                      REP-0300: ORACLE error occurred.

                      REP-1401: 'cf_high_gen_monthformula': Fatal PL/SQL error occurred.
                      ORA-06502: PL/SQL: numeric or value error


                      REP-1401: 'cf_high_gen_monthformula': Fatal PL/SQL error occurred.
                      ORA-06502: PL/SQL: numeric or value error


                      REP-1401: 'cf_high_gen_monthformula': Fatal PL/SQL error occurred.
                      ORA-06502: PL/SQL: numeric or value error


                      REP-1401: 'cf_high_gen_monthformula': Fatal PL/SQL error occurred.
                      ORA-06502: PL/SQL: numeric or value error


                      REP-1401: 'cf_high_gen_monthformula': Fatal PL/SQL error occurred.
                      ORA-06502: PL/SQL: numeric or value error



                      Rgrds,
                      Shubha

                      Edited by: 955685 on Feb 5, 2013 9:18 AM
                      • 8. Re: PRoduction Generation Report Error
                        Hussein Sawwan-Oracle
                        Do you have any invalid objects in the database?

                        Was the report compiled successfully on the client using Reports Builder?

                        Please enable trace/debug as per (How Can Trace and Debug Be Turned On For A Concurrent Request? [ID 759389.1]) and see if you get more details about the error.

                        Thanks,
                        Hussein
                        • 9. Re: PRoduction Generation Report Error
                          User470870-OC
                          Hi Hussein,

                          One invalid object PA_INV_ON_ACCOUNT_CM present in the db and raised an SR for this.

                          And we have 2 files under /u07/UAT/apps/apps_st/appl/XXSHM/12.0.0
                          XXSHMPRODGEN.ldt
                          XXSHMPRODGEN_xml.ldt

                          I trust these are the reports i need to compile.
                          Please suggest how can i compile them using report builder and where this should be done (sql developer or putty session)

                          Rgrds,
                          Shubha
                          • 10. Re: PRoduction Generation Report Error
                            Hussein Sawwan-Oracle
                            955685 wrote:
                            Hi Hussein,

                            One invalid object PA_INV_ON_ACCOUNT_CM present in the db and raised an SR for this.
                            What is the error you get when you compile it manually?

                            Apps.PA_INV_ON_ACCOUNT_CM Errors During Prc: Interface Invoices To Receivables After Patch 12925123 [ID 1373117.1]
                            PRC: Interface Invoices To Receiveables Errors with PLS-00201: identifier 'PA_INV_ON_ACCOUNT_ [ID 1507771.1]
                            ORA-4063 Error Modify Project Trans Duration Date [ID 1499836.1]
                            And we have 2 files under /u07/UAT/apps/apps_st/appl/XXSHM/12.0.0
                            XXSHMPRODGEN.ldt
                            XXSHMPRODGEN_xml.ldt

                            I trust these are the reports i need to compile.
                            Please suggest how can i compile them using report builder and where this should be done (sql developer or putty session)
                            Those are ldt files and not reports.

                            Do Not Compile EBS R12 Reports Using rwconverter.sh or Reports Builder from IDS 10gR2 [ID 786794.1]
                            Using the OracleAS 10.1.2 Forms and Reports Builders with Oracle Applications Release 12 [ID 444248.1]

                            Thanks,
                            Hussein