Transactions Are Duplicated Even Though Transaction Source Is Defined to Not Allow Duplicates
Last updated on DECEMBER 18, 2017
Applies to:Oracle Fusion Receivables Cloud Service - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
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
where trx_number = '&trx_num';
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
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