EAP: Matching Exception "100" on Voucher Lines When the UOM is Different between the PO and the Voucher (Doc ID 2135154.1)

Last updated on JULY 15, 2016

Applies to:

PeopleSoft Enterprise FIN Payables - Version 9.1 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

Matching Exception "100" occurs on voucher lines when the Unit of measure is different than that of the PO line (which is the source document for the voucher) and the quantity on the PO line is spread across multiple vouchers lines. In this specific scenario, the UOM on the PO line is higher that that of the voucher i.e. for Example, the UOM on the PO = BOX and the UOM on the voucher = EA. the conversion rate between 2 UOMs is 1BX = 5EA.

The Application Engine SQL due to which this issue is occurring is as follows:

(AP_DAM_ALG.VPRMTVQ2.1SQL33) (SQL).

This is the SQL where the PS_AP_DAM_RCV7_T.QTY_RECV_REMAIN table is getting populated from PS_AP_DAMRCVLN_T.QTY_SH_ACCPT_VUOM.
Source field i.e. QTY_SH_ACCPT_VUOM is of type "Number" and length is 11.4 whereas the target field i.e. QTY_RECV_REMAIN is also of type Number but length is only 11 (without space for any decimals).

So, when the value in the source field is <0.5, the value in the target field is being rounded off to 0 causing 100 Exception eventually and when source field value is >-0.5, then the target field value is being rounded off to 1.

Below are more specifics of the scenario assuming the conversion rate is 1BOX = 5EA

PO has 1 line and the quantity s 2 BOX on this line item. After this has been received, Voucher is created with 3 different lines against the same PO line and the UOM is EA on all the voucher lines. First voucher line has a quantity of 8 EA and the Voucher lines 2, 3 has a quantity of 1 EA.
No Exception on Voucher line 1 but Lines 2,3 end up with 100 exception and the reason for the same is as follows:

After processing the voucher line which has a quantity of 8EA, the received quantity (total of 2 BOX) that is left unmatched is 0.4 BOX. when processing the voucher line # 2, the above SQL is rounding off 0.4. to 0 thereby no received quantities available to match against the voucher line #2.

STEPS

1. Create a Qty PO with 1 line for UOM = BOX - match rule control is STD_RL_TOL
2. Dispatch the PO
3. Create receiver
4. Create voucher - enter PO business unit and PO number
5. Change the UOM to EA and Qty to 8 and unit price to $20 for voucher line 1
6. Copy the same PO for voucher line 2 - Change the UOM to EA and Qty to 1 and unit price to $20 for voucher line 2
7. Copy the same PO for voucher line 3 - Change the UOM to EA and Qty to 1 and unit price to $20 for voucher line 3
8. Run Matching
9 Voucher has match exception of 100 - No receipt found

No available receipts (not matched, not on hold, and not canceled) were found for the purchase order specified on the voucher line.

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms