My Oracle Support Banner

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 JUNE 05, 2018

Applies to:

Oracle Receivables - Version 12.0.0 to 12.0.6 [Release 12.0]
Information in this document applies to any platform.


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.

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




To view full details, 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 a vibrant support community of peers and Oracle experts.