PAICGEN Cursor=24 code=0: ORA-01403: no data found
(Doc ID 2307656.1)
Last updated on FEBRUARY 07, 2024
Applies to:
Oracle Project Billing - Version 12.2.4 and laterInformation in this document applies to any platform.
Symptoms
When running PRC: : Generate Intercompany Invoices for a Range of Projects the following error is encountered:
Leaving paicam() with error
ORACLE error during DRAFT INVOICE GENERATION (cursor=24 code=0: ORA-01403: no data found )
...allocating 30500 bytes of memory to hold set of 500 expenditure item IDs
ORA-01403: no data found
Leaving paicexp()Error during Draft Invoice Generation. Module paicexp returned failure
Error during Draft Invoice Generation. Module paicgop returned failure
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+
APP-FND-01564: ORACLE error 1008 in afpprq
Cause: afpprq failed due to .
The SQL statement being executed at the time of the error was: SELECT ACTION_TYPE, DECODE(STATUS_S_FLAG, 'Y', 1, 0), DECODE(STATUS_W_FLAG, 'Y', 1, 0), DECODE(STATUS_F_FLAG, 'Y', 1, 0), PROGRAM_APPLICATION_ID, PROGRAM_ID, ARGUMENTS, NUMBER_OF_COPIES, SEQUENCE FROM FND_CONC_PP_ACTIONS WHERE CONCURRENT_REQUEST_ID= :reqid AND NVL(COMPLETED,'N') = 'N' ORDER BY DECODE(ACTION_TYPE, 6, 100, ACTION_TYPE) DESC, SEQUENCE and was executed from the file &ERRFILE.
<path to $PA_TOP>/bin/PAICGEN
Program was terminated by signal 11
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |