PAICGEN Cursor=24 code=0: ORA-01403: no data found (Doc ID 2307656.1)

Last updated on FEBRUARY 07, 2024

Applies to:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.