This discussion is archived
10 Replies Latest reply: Feb 6, 2013 3:05 PM by Hussein Sawwan-Oracle RSS

PRoduction Generation Report Error

User470870-OC Newbie
Currently Being Moderated
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 Oracle ACE Director
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Employee ACE
    Currently Being Moderated
    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 Oracle ACE Director
    Currently Being Moderated
    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 Employee ACE
    Currently Being Moderated
    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 Employee ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Employee ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Employee ACE
    Currently Being Moderated
    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

Legend

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