R12: EC: Program "OUT: Application Advice (824/APERAK)" Hangs and Runs for 4 Days, and Completes with Error ORA-1403.
(Doc ID 2912414.1)
Last updated on DECEMBER 05, 2022
Applies to:
Oracle Payables - Version 12.2.8 and laterInformation in this document applies to any platform.
Symptoms
Concurrent program "OUT: Application Advice (824/APERAK)" is taking 3 to 4 days to complete. Then, ends in Error.
Unable to send Report to respective suppliers.
The temporary log file shows the following errors:
...
l_XXxxN_edi_id: ==>
Unexpected error while deriving XXvvN EDI ID SQLERRM:ORA-01403: no data found
l_transaction_idPosition: ==>68
l_transaction_id: ==>18904256
l_XXxxN_edi_id: ==>
Unexpected error while deriving XXxxN EDI ID SQLERRM:ORA-01403: no data found
l_transaction_idPosition: ==>68
l_transaction_id: ==>18904257
l_XXxxN_edi_id: ==>
Unexpected error while deriving XXxxN EDI ID SQLERRM:ORA-01403: no data found
l_transaction_idPosition: ==>68
l_transaction_id: ==>18904258
l_XXxxN_edi_id: ==>
Unexpected error while deriving XXxxN EDI ID SQLERRM:ORA-01403: no data found
l_transaction_idPosition: ==>68
l_transaction_id: ==>18904259
...
DBA team identified that the following SELECT is running multiple times. The query completes in seconds. But, there are many iterations of the same:
Concurrent program "Payables Open Interface Outbound Advice" executed prior, completes successfully.
Steps to reproduce:
- Log into Oracle Applications using an e-Commerce Gateway responsibility
- Open the "Run e-Commerce Outbound Process" screen
(N) Process > Extract Program - In the "Name" field LOV, select "OUT: Application Advice (824/APERAK)"
- Enter the "Output File Name" and any other parameters needed.
- Submit.
The report hangs/runs for almost 4 days.
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 |
Cause |
Solution |
References |