This discussion is archived
1 Reply Latest reply: Aug 2, 2013 11:08 AM by user1047506 RSS

Error Running Discounts Taken  Report

user1047506 Newbie
Currently Being Moderated

This is the log file I get from running the Discounts Taken and Lost report

 

+---------------------------------------------------------------------------+

Payables: Version : 12.0.0

 

 

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

 

 

APXINDTL module: Discounts Taken and Lost Report

+---------------------------------------------------------------------------+

 

 

Current system time is 31-JUL-2013 14:39:42

 

 

+---------------------------------------------------------------------------+

 

 

 

 

+-----------------------------

| Starting concurrent program execution...

+-----------------------------

 

 

Arguments

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

P_START_DATE='2012/07/01 00:00:00'

P_END_DATE='2012/11/01 00:00:00'

P_SUMMARY_OPTION='Y'

P_SET_OF_BOOKS_ID='1001'

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

 

 

Current NLS_LANG and NLS_NUMERIC_CHARACTERS Environment Variables are :

American_America.US7ASCII

 

 

'.,'

 

 

Enter Password:

ORA-24324: service handle not initialized

==> SELECT i . vendor_id C_VENDOR_ID , v1 . vendor_name C_VENDOR_NAME , upper ( v1 . vendor_name ) C_UPPER_VENDOR_NAME , v2 . vendor_site_code C_VENDOR_SITE_CODE , segment1 C_VENDOR_NUM , invoice_num C_INVOICE_NUM , invoice_date C_INVOICE_DATE , max ( ch

REP-0069: Internal error

REP-57054: In-process job terminated:Terminated with error:

REP-300: service handle not initialized

==> SELECT i . vendor_id C_VENDOR_ID , v1 . vendor_name C_VENDOR_NAME , upper ( v1 . vendor_name ) C_UPPER_VENDOR_NAME , v2 . vendor_site_code C_VENDOR_SITE_CODE , segment1 C_VENDOR_NUM , invoice_num C_INVOICE_NUM , invoice_date C_INVOICE_DATE , max ( ch

 

 

 

 

Report Builder: Release 10.1.2.3.0 - Production on Wed Jul 31 14:39:43 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 6884351.

 

 

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 31-JUL-2013 14:39:47

 

 

+---------------------------------------------------------------------------+

Legend

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