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

Last updated on APRIL 03, 2025

Applies to:

Symptoms

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:

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.

STEPS
-----------------------
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

Cause

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