My Oracle Support Banner

EAP: Undo Matching fails at Step AP_MTCHUN.IniPO.CntBu2 RC = 8150 (Doc ID 845257.1)

Last updated on NOVEMBER 23, 2019

Applies to:

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

Symptoms

Undo Matching (AP_MTCHUN) is erroring out after applying 8.9 Bundles 22 - 32.  Process is abending at Step AP_MTCHUN.IniPO.CntBu2 (Action Do Select) -- RC = 8150.

ERROR
------------
-- 15.09.16 .....(AP_MTCHUN.IniPO.CntBu2) (Do Select)
%SelectInit(BUSINESS_UNIT, PO_ID, LINE_NBR, SCHED_NBR, COUNT_1, COUNT_2)
SELECT A.BUSINESS_UNIT , A.PO_ID , A.LINE_NBR , A.SCHED_NBR , A.QTY_PO ,
SUM(A.QTY_VCHR) FROM PS_PO_LINE_MATCHED A , PS_AP_UMPO_TAO4 B WHERE
B.PROCESS_INSTANCE = 1594192 AND B.BUSINESS_UNIT_PO = A.BUSINESS_UNIT AND
B.PO_ID = A.PO_ID AND B.LINE_NBR = A.LINE_NBR AND B.SCHED_NBR = A.SCHED_NBR
AND B.BUSINESS_UNIT = A.BUSINESS_UNIT_AP AND B.VOUCHER_ID = A.VOUCHER_ID AND
B.VOUCHER_LINE_NUM = A.VOUCHER_LINE_NUM AND B.COUNT_2 > 1 GROUP BY
A.BUSINESS_UNIT, A.PO_ID, A.LINE_NBR, A.SCHED_NBR, A.QTY_PO
/
-- 15.09.17 Process 1594192 ABENDED at Step AP_MTCHUN.IniPO.CntBu2 (Action Do Select) -- RC = 8150
ROLLBACK
/
-- 15.09.17 SQL Error: Left-of-decimal digits truncated from FETCHed value (SQLSTATE PS150)

STEPS
-----------
1.  Create a PO
2.  Dispatch the PO
3.  Receive the PO
4.  Create a Voucher
5.  Run Matching
6.  Through Match Workbench, select Undo Matching on the above Voucher
7.  Run Matching

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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