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 DECEMBER 13, 2017

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.


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.
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.
    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.


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