AR_00046 Transactions Workbench API Issue: AR_INVOICE_API_PUB and AR_CREDIT_MEMO_API_PUB does not Create All the Required Events in XLA_EVENTS (Doc ID 798360.1)

Last updated on SEPTEMBER 07, 2023

Applies to:

Symptoms

There are missing rows in XLA_EVENTS on a Transactions that was created using APIs.

This occurs only if an invoice is created (using ar_invoice_api_pub.create_single_invoice or create_invoice) and a credit memo is applied to it (using ar_credit_memo_api_pub.create_request) within the same session.

This is true whether the Credit Memo application is done via a custom form or in concurrent request.

EXPECTED BEHAVIOR
Expect the ar_invoice_api_pub and ar_credit_memo_api_pub.create_request API to create a Transactions with the accounting events stamped in the table RA_CUST_TRX_LINE_GL_DIST_ALL .

Steps to Reproduce:
Create an invoice using ar_invoice_api_pub.create_single_invoice or create_invoice
In the same session, create a Credit Memo using ar_credit_memo_api_pub.create_request
Check for the event_id on RA_CUST_TRX_LINE_GL_DIST_ALL for the Credit Memo it is null

Cause

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