My Oracle Support Banner

FRM-40212 Error Matching Invoice To Single Receipt Created For Multiple POs With Multiple Currencies (Doc ID 1627980.1)

Last updated on FEBRUARY 19, 2019

Applies to:

Oracle Payables - Version 12.1.3 and later
Oracle Landed Cost Management - Version 12.1.3 and later
Information in this document applies to any platform.


On : 12.1.3 version,

Unable to match ITEM type Invoice line to LCM receipt due to below error. On Find Receipts matching window search 'Receipt number' returns following error:

 FRM-40212: Invalid value for field RECEIPT_NUM


-Two POs raised (PO1 & PO2) for ITEMs with different currencies, same vendor. PO1 with AED currency and PO2 with USD currency. No Freight lines.
-Single LCM Receipt raised with two shipment lines(Line1-AED & Line2-USD) with multiple currency's. Different currency on each line.
-This single LCM Receipt is matched to multiple POs i.e. PO1 and PO2.
-Now enter and match first Invoice1(AED) to Receipt line1-AED, no errors.
-Now while attempting to match second Invoice2(USD) to Receipt line2-USD, FRM-40212 Error occurs.
-There is no cross-currency matching here.

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

1.Create two POs. (PO1 & PO2) raised for ITEMs for different currencies. Example AED and USD currencies. No Freight.
2.Create a single LCM receipt with two lines with different currency in each line(AED & USD).
2.Now match the AP Invoice1 (AED currency) to Receipt line 1 (AED currency). No errors
4.When attempting to match the (USD currency) AP Invoice2 to other receipt line2 below error occurs.
 FRM-40212: Invalid value for field RECEIPT_NUM


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.