AR_00046 Transactions Workbench API Issue: ar_invoice_api_pub and ar_credit_memo_api_pub Does Not Create All Required Events in XLA_EVENTS
Last updated on MARCH 29, 2017
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 if 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
Million Knowledge Articles and hundreds of Community platforms