Transactions Are Duplicated Even Though Transaction Source Is Defined to Not Allow Duplicates

(Doc ID 2281743.1)

Last updated on DECEMBER 18, 2017

Applies to:

Oracle Fusion Receivables Cloud Service - Version 11.1.11.1.0 and later
Information in this document applies to any platform.

Symptoms

Transactions are Duplicated When Source is Defined to Not Allow Duplicates.
Using Autoinvoice to importing transactions from Order Management.
Also using Document Sequencing.

Manage transaction source page:
Transaction Source = Distributed Order Orchestration
ALLOW_DUPLICATE_TRX_NUM_FLAG = N
COPY_DOC_NUMBER_FLAG = Y

Transactions are created in AR as incomplete.
Once the transactions are imported, then go to Manage Transactions page to search for the transactions and complete them manually.

Even though the transactions are for two different customers, they were created having
the same transaction number values.

Select customer_trx_id, trx_number, org_id,doc_sequence_id, doc_sequence_value
from ra_customer_trx_all
where trx_number = '&trx_num';

Query Results

CUSTOMER_TRX_ID TRX_NUMBER ORG_ID DOC_SEQUENCE_ID DOC_SEQUENCE_VALUE
878001 13001100005657 300000009222472 Null 13001100005657
880001 13001100005657 300000009222472 Null 13001100005657

STEPS TO REPRODUCE
==================
1. Oracle Fusion Receivables

2. Scheduled Process

3. AutoInvoice Import

4. Transactions are created in the application, as Incomplete, even though
the AutoInvoice Process has completed with exceptions.

5. Manage Transactions

6. Search Transaction

7. Transactions are completed through Manage Transaction page.

8. Observe that the transactions are created as duplicate transaction numbers for
the same transaction source and org

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