Hi All
I have the following error for a custom GL Report. This report working fine for all organization and all period_name(parameter) but unfortunately failing for 1 org with parameter(MAR-2014) only..
The error and log file log is as below.
Please Kindly suggest.
+---------------------------------------------------------------------------+
XX General Ledger: Version : UNKNOWN
Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.
XXGLDTLJOBCOST module: BATEMAN Detail Job Costing
+---------------------------------------------------------------------------+
Current system time is 10-APR-2014 16:05:13
+---------------------------------------------------------------------------+
+-----------------------------
| Starting concurrent program execution...
+-----------------------------
Arguments
------------
P_COA='101'
P_PERIOD_FROM='MAR-2014'
P_PERIOD_TO='MAR-2014'
p_rev_acc='24053140'
P_COST_ACC='24053010'
P_PROJ_ACC='24053020'
------------
-- Start of Reports Command --
/u02/oracle/UAT12/inst/apps/UAT12_lelo/ora/10.1.2/bin/appsrwrun.sh
P_CONC_REQUEST_ID=2744010
P_COA='101'
P_PERIOD_FROM='MAR-2014'
P_PERIOD_TO='MAR-2014'
p_rev_acc='24053140'
P_COST_ACC='24053010'
P_PROJ_ACC='24053020'
report=/u02/oracle/UAT12/apps/apps_st/appl/xxgl/12.0.0/reports/US/XXGLDTLJOBCOST.rdf
batch=yes
destype=file
desname=/u02/oracle/UAT12/inst/apps/UAT12_lelo/logs/appl/conc/out/o2744010.out
desformat=XML
-- End of Reports Command --
Request language is :
AMERICAN
Request territory is :
SOUTH AFRICA
Forcing NLS_NUMERIC_CHARACTERS to: '.,' for XDO processing
APPLLCSP Environment Variable set to :
Previous NLS_LANG Environment Variable was :
AMERICAN_SOUTH AFRICA.AL32UTF8
Current NLS_LANG and NLS_NUMERIC_CHARACTERS Environment Variables are :
AMERICAN_SOUTH AFRICA.AL32UTF8
'.,'
Enter Password:
MSG-00050: :P_DATE_LO01-MAR-14
MSG-00051: :P_DATE_HI28-MAR-14
MSG-00052: :P_REV_ACC24053140
MSG-00052: :P_COST_ACC24053010
MSG-00053: :P_PROJ_ACC24053020
MSG-00054: After Form
MSG-00090: before report
MSG-00090: :CP_ORG_ID84
MSG-00091: :cp_open_ordersAll orders
MSG-00092: :cp_org_name1029 - BPL - Engineered Technologies Division
MSG-00093: :cp_company1029
MSG-00094: v_fetch_job_type
MSG-00095: :cp_job_no_type
MSG-00095: :cp_job_code5
MSG-00100: end report
REP-0300: ORACLE error occurred.
REP-0069: Internal error
REP-57054: In-process job terminated:Terminated with error:
REP-300: MSG-00090: before report
MSG-00090: :CP_ORG_ID84
MSG-00091: :cp_open_ordersAll orders
MSG-00092: :cp_org_name1029 - BPL - Engineered Technologies Division
MSG-00093: :cp_company1029
MSG-00094: v_fetch_job_type
MSG-00095: :cp_job_no_type
MSG-00095: :cp_job_code5
MSG-00100: end report
REP-0300: ORACLE error occurred.
Report Builder: Release 10.1.2.3.0 - Production on Thu Apr 10 16:05:14 2014
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_SOUTH AFRICA.AL32UTF8
Program exited with status 1
Concurrent Manager encountered an error while running Oracle*Report for your concurrent request 2744010.
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 10-APR-2014 16:05:19
+---------------------------------------------------------------------------+