My Oracle Support Banner

Transactions Workbench Issue: R12: Copy Transaction Numbering Feature Not Working (Doc ID 2071013.1)

Last updated on APRIL 02, 2019

Applies to:

Oracle Receivables - Version 12.1 and later
Information in this document applies to any platform.


On :  12.1.3 version, Transactions Related

When generating a copy transaction within receivables the transaction number that is
displayed is pulled from the invoice source, and is not the expected document sequence

This makes it very difficult to query back the invoice in the transaction workbench, and the receipt entry forms
Steps to Reproduce
Manual Invoice Entry
1. Create a manual invoice in the transactions form:1000771 trx no created
and doc no: 10000282
- Invoice Number 100771 generated
- Click (B) Complete
- Document Sequence Number 10000282 replaces the Invoice Number
- Manual transaction entry working as expected

2. Invoice Source  - Manual
- Automatic Numbering defined
- Copy Document Number to Transaction Number enabled

3. Copy Transaction Entry
Query the manual transaction created above with Document Sequence Number
10000282 and use it as a template to create copy transactions
(N) Transactions > Copy Transactions
- Query Trans Number 10000282
- Transaction returned as expected
- Enter the copy transaction schedule as follows:
o Number of Times = 1
o Number of Days = 0
- A new transaction is generated, however it displays the incorrect
transaction number 1000772

4. Transaction Summary
(N) Transactions > Transaction Summary
- Click on the (I) Find and search for all invoices created today

- The returned data shows the original invoice 10000282 and the copy
transaction 10000283 with the correct document sequence numbering (Not the
invoice source numbering 1000772 as displayed in the Copy Transaction form)


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.