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
Last updated on APRIL 16, 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
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