Purchase Order Receipt Errors With "Receipt number must be unique" When Currency Conversion From Purchase Order To Functional Currency (OU) Has Decimals (Doc ID 2853986.1)

Last updated on MARCH 07, 2022

Applies to:

Symptoms

On : 12.2.10 version, Receipts

Receipt for inventory item runs into error when PO has a different currency from OU Functional currency after upgrade from 12.1.3 to 12.2.10.
Before the upgrade there were many successfully processed receiving transactions belonging to POs with a foreign currency.
This error happens only when RCV: Processing mode is set to "Immediate" , There is no error when the processing mode is "Online" / "Batch"

ERROR
-----------------------
 "Error: Receipt number must be unique.".

STEPS

-----------------------
The issue can be reproduced at will with the following steps:

1) Enter a PO with a Supplier where the default currency is different to the currency of the operating unit. (For Ex: The PO must be entered in a European Operating Unit whose currency is EUR, But the OU has currency USD)
2) Enter a PO line with an inventory item and approve the PO.
3) Enter a receipt for the PO.
4) See that the receiving transaction processor (RTP) errors out.

Debug log for RTP shows error -  "Error: Receipt number must be unique." (This is not a relevant error for this case). It shows below messages before raising the error - 

Changes

 Upgraded from 12.1.3 to 12.2.10

Cause

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