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

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.

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 if 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

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