This discussion is archived
3 Replies Latest reply: Jan 11, 2013 3:57 AM by 983780 RSS

report error problem

983780 Newbie
Currently Being Moderated
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 Expert
    Currently Being Moderated
    Hi,

    Any recent changes on the report?

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

    Regards
    Yoonas
  • 2. Re: report error problem
    983780 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    resolved.

Legend

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