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 MARCH 08, 2017

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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.