My Oracle Support Banner

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:

Oracle Inventory Management - Version 12.2.10 and later
Information in this document applies to any platform.


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: Receipt number must be unique.".


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 - 



 Upgraded from 12.1.3 to 12.2.10


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.