My Oracle Support Banner

AR GDF: AR_DFS_TRX_ORPHAN_SITE_USE_ID.sql AR_S_00020 Create Accounting Error: AutoInvoice Transactions Fail with: EventClass_164. ORA-01403: no data found. EVENT CLASS CODE = INVOICE (Doc ID 1448222.1)

Last updated on JUNE 21, 2023

Applies to:

Oracle Receivables - Version 12.0.0 and later
Information in this document applies to any platform.
XLAACCUP module: Accounting Program



  1. Run the Receivables Period Close Analyzer before closing the period to proactively identify this issue, as well as many other issues that will prevent you from closing the period.

  2. If you post to multiple EBS subledgers, use the EBS Period Close Process Analyzer for a smoother period close.


Create Accounting Program fails with error in the Accounting Program log for some invoices created via Autoinvoice.


1. create invoice from Autoinvoice
2. run Create Accounting

XLAACCUP log will show error:




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
 Script to Identify the Corruption
 GDF Script
 ODM Tags
 Still Have Questions?

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