My Oracle Support Banner

Problem With Copying Invoices Using Manual Batch Source After Patch 5943983 (Doc ID 456825.1)

Last updated on AUGUST 25, 2017

Applies to:

Oracle Receivables - Version: 11.5.8 and later   [Release: 11.5.10 and later ]
Information in this document applies to any platform.


After application of patch 5943983 plus jg_zz_ar_auto_trx_num_upd (trigger codefix)
copying invoices with manual batch source is not working as required.

The transaction number generated is well-formatted, but the number is incorrect, because is
getting the database sequence from the manual batch source, instead of the imported batch source.

In Argentina localization the manual invoices has to get the number from the related imported
batch source

The issue can be reproduced at will with the following steps:
Create two batch sources.
The first one is Imported - 'Documento FC A '
This source is used to numbering the invoices originated in external systems.
The second one is Manual - 'Numerador FC A .
this source is used to enter manual invoices, through the Enter Transactions form.
Find a Manual invoice, for example the invoice A-0001-00028745 and copy it.
Open the Copy Transaction form, search for the invoice A-0001-00028745 in the model transaction
Copy Transaction window
Source Numerador FC A
Transaction Number A-0001-00028745
Select the “Single Copy” rule and press Save
Copy Transaction window
Source Numerador FC A
Transaction Number 136
Take a look into the “Recurring Invoice Program” outputT
The model invoice (a Manual invoice) has the number A-0001-00028745, and the new copied invoice
(with the same manual batch source) has the number A-0001-00000136.
This is wrong . The correct number should be A-0001-00028748,
the next number from the Imported batch source.

Screen shot of Recurring Invoice Program, request id 531446
Model Invoice number A-0001-00028745
New invoice number A-0001-00000136

The issue has the following business impact:
Due to this issue, the transaction has a wrong number.


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.