3 Replies Latest reply: Jan 11, 2013 5:57 AM by 983780 RSS

    report error problem

    983780
      Hi,

      could anyone help me with Oracle Reports error please?

      When I run Oracle Report Request from EBS I got:
      REP-0300: ORACLE error occurred.
      REP-0069: Internal error
      REP-57054: In-process job terminated:Terminated with error:
      REP-300: ORACLE error occurred.


      It was working ok for now, but for 1 report (about I know now) it gets error.

      It is run with args like:
      P_QUOTE_HEADER_ID='50509'
      P_QUOTE_HEADER_COMP_ID='50498'
      P_QUOTE_HEADER_PROD_ID='49832'
      P_ADJ_LINE_ID='3380471'
      P_TASK_ID='28075'
      P_CONTEXT='Default'
      P_TOTAL_NRE='0.0'
      P_ORG_INV_ID='138'

      and it crashes :/
      But when I use Oracle Reports Builder to manually generate xml data it works fine

      Other reports work ok, and arguments are similar - like:
      P_QUOTE_HEADER_ID='49778'
      P_QUOTE_HEADER_COMP_ID='49777'
      P_QUOTE_HEADER_PROD_ID='49256'
      P_ADJ_LINE_ID='3364766'
      P_TASK_ID='27875'
      P_CONTEXT='Default'
      P_TOTAL_NRE='0.0'
      P_ORG_INV_ID='138'
      (and then report is generated correctly)


      I don't have a clue what could be a problem (as it works in Reports Builder and similar reports work fine) - if anyone could help or have an idea what could be a source of my problem?
        • 1. Re: report error problem
          yoonas
          Hi,

          Any recent changes on the report?

          Can you post the complete log ('View Log')

          Regards
          Yoonas
          • 2. Re: report error problem
            983780
            Last changes are from begining of December - and all reports were generated fine, but now I got information about this one which has error.


            log:

            ---------------------------------------------------------------------------
            Quoting: Version : 12.0.0

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

            XX_QOT_PRINTQUOTE module: FID: Print Quote
            ---------------------------------------------------------------------------

            Current system time is 09-JAN-2013 13:26:25

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


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

            Arguments
            ------------
            P_QUOTE_HEADER_ID='50509'
            P_QUOTE_HEADER_COMP_ID='50498'
            P_QUOTE_HEADER_PROD_ID='49832'
            P_ADJ_LINE_ID='3380471'
            P_TASK_ID='28075'
            P_CONTEXT='Default'
            P_ORG_INV_ID='138'
            ------------


            -- Start of Reports Command --
            /ORACLE/inst/apps/POLIGON_devappl/ora/10.1.2/bin/appsrwrun.sh
            P_CONC_REQUEST_ID=34404257
            P_QUOTE_HEADER_ID='50509'
            P_QUOTE_HEADER_COMP_ID='50498'
            P_QUOTE_HEADER_PROD_ID='49832'
            P_ADJ_LINE_ID='3380471'
            P_TASK_ID='28075'
            P_CONTEXT='Default'
            P_ORG_INV_ID='138'
            report=/ORACLE/apps/apps_st/appl/qot/12.0.0/reports/US/XX_QOT_PRINTQUOTE.rdf
            batch=yes
            destype=file
            desname=/ORACLE/inst/apps/POLIGON_devappl/logs/appl/conc/out/o34404257.out
            desformat=XML
            -- End of Reports Command --



            Request language is :
            AMERICAN


            Request territory is :
            AMERICA


            Forcing NLS_NUMERIC_CHARACTERS to: '.,' for XDO processing

            Previous NLS_LANG Environment Variable was :
            AMERICAN_AMERICA.EE8MSWIN1250


            Current NLS_LANG and NLS_NUMERIC_CHARACTERS Environment Variables are :
            AMERICAN_AMERICA.EE8MSWIN1250

            '.,'

            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 Wed Jan 9 13:26:27 2013

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


            ---------------------------------------------------------------------------
            Start of log messages from FND_FILE
            ---------------------------------------------------------------------------
            ---------------------------------------------------------------------------
            End of log messages from FND_FILE
            ---------------------------------------------------------------------------

            Reset original NLS_LANG in environment as :
            AMERICAN_AMERICA.EE8MSWIN1250

            Program exited with status 1
            Concurrent Manager encountered an error while running Oracle*Report for your concurrent request 34404257.

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


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

            Output file size:
            0


            Finished executing request completion options.

            ---------------------------------------------------------------------------
            Concurrent request completed
            Current system time is 09-JAN-2013 13:26:29

            ---------------------------------------------------------------------------
            • 3. Re: report error problem
              983780
              resolved.