Create Accounting Error: AutoInvoice Transactions Fail with: EventClass_164. ORA-01403: no data found. EVENT CLASS CODE = INVOICE. The events are present in the line extract but MISSING in the header extract
Last updated on APRIL 12, 2018
Applies to:Oracle Receivables - Version 12.0.0 to 12.2 [Release 12.0 to 12.2]
Information in this document applies to any platform.
XLAACCUP module: Accounting Program
Invoices imported to Receivables via AutoInvoice are missing bill_to_site_use_id, this prevents invoices from being queried in Transactions Form.
Steps to Reproduce:
- Responsibility: Receivables Manager
Navigation: Transactions >Transactions
- Query a transaction created via AutoInvoice, and get the following error:
Error within Create Accounting Program.
EventClass_164. ORA-01403: no data found.
EVENT CLASS CODE = INVOICE
The events are present in the line extract but MISSING in the header extract
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