My Oracle Support Banner

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 later
Information 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:

  1. Log into Oracle Applications using an e-Commerce Gateway responsibility
  2. Open the "Run e-Commerce Outbound Process" screen 
    (N) Process > Extract Program
  3. In the "Name" field LOV, select "OUT: Application Advice (824/APERAK)"
  4. Enter the "Output File Name" and any other parameters needed.
  5. 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


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