Unable to View Invoice and Accounting Program Fails With XLA_00222_AAD_S_000002_PKG.EventClass_162. ORA-01403: No Data Found. (Doc ID 2036191.1)

Last updated on OCTOBER 24, 2016

Applies to:

Oracle Receivables - Version 12.0.0 to 12.2.4 [Release 12.0 to 12.2]
Information in this document applies to any platform.

Symptoms

When running Create Accounting the following error condition is found.

1. ERROR on log file
-----------------------
An internal error occurred. Please inform your system administrator or support representative that:
An internal error has occurred in the program XLA_00222_AAD_S_000002_PKG.EventClass_162. ORA-01403: no data found.
***************************************************************************
EVENT CLASS CODE = INVOICE
The following events are present in the line extract but MISSING in the header extract:
Event_id = 636042
***************************************************************************

2. Query Invoice and unable to view via the form.
    Transactions>Transactions
    Query Invoice Number

 

Steps to Reproduce:
Responsibility: Receivables Manager
Navigation: Control>Request>Run
LOV: Create Accounting

1. Submit a Single Request, and pick Create Accounting
2. Enter required parameters, then run process.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms