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 (Doc ID 1448222.1)

Last updated on JANUARY 12, 2017

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


Symptoms

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:

  1. Responsibility: Receivables Manager
    Navigation
    : Transactions >Transactions

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

 

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