ABENDED At Step PO_CMPRICE.MAIN.ISRTCNTR (Action SQL) -- RC = 1476 (Doc ID 2292375.1)

Last updated on JULY 31, 2017

Applies to:

PeopleSoft Enterprise SCM Supplier Contract Management - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

Process PO_POCHNG is Failing

PO Change order is failing in Insert statement

ERROR
-----------------------
-- 03:36:16.776 .....(PO_CMPRICE.MAIN.ISRTCNTR) (SQL)
INSERT INTO PS_PO_PRC_CNTR_T7 (PROCESS_INSTANCE, BUSINESS_UNIT, PO_ID,
PO_STG_TYPE, PO_STG_ID, LINE_NBR, SCHED_NBR, PRICE_PO, CURRENCY_CD,
UNIT_OF_MEASURE, AMT_LINE_RELEASED, AMT_RELSD_OPEN_ITM, CNTRCT_ID,
VERSION_NBR, CAT_LINE_NBR, CNTRCT_LINE_NBR, CNTRCT_RATE_DIV,
CNTRCT_RATE_MULT, CNTRCT_SETID, CONVERSION_RATE, CONVERSION_RT_CNTR,
CURRENCY_CD_CNTR, QTY_LINE_RELEASED, QTY_PO, RECOM_VNDR, UNIT_MEASURE_CNTR)
SELECT DISTINCT P.PROCESS_INSTANCE, P.BUSINESS_UNIT, P.PO_ID, P.PO_STG_TYPE,
P.PO_STG_ID, P.LINE_NBR, P.SCHED_NBR, P.PRICE_PO, C.CURRENCY_CD,
C.UNIT_OF_MEASURE, 0, 0, P.CNTRCT_ID, P.VERSION_NBR, P.CAT_LINE_NBR,
P.CNTRCT_LINE_NBR, C.CNTRCT_RATE_DIV, C.CNTRCT_RATE_MULT, P.CNTRCT_SETID,
C.CONVERSION_RATE, C.CONVERSION_RT_CNTR, C.CURRENCY_CD_CNTR,
ROUND(((((((P.QTY_REQ) * ( C.CONVERSION_RATE)))) / ( C.CONVERSION_RT_CNTR))),
2), P.QTY_REQ, 'Y', C.UNIT_MEASURE_CNTR FROM PS_PO_PRC_WRK1_T7 P ,
PS_PO_CNTRCT_L2T7 C WHERE P.PROCESS_INSTANCE = 6058329 AND P.MESSAGE_NBR <>
23 AND C.PROCESS_INSTANCE = P.PROCESS_INSTANCE AND C.BUSINESS_UNIT =
P.BUSINESS_UNIT AND C.PO_ID = P.PO_ID AND ((C.LINE_NBR = 0) OR (C.LINE_NBR =
P.LINE_NBR AND C.SCHED_NBR = P.SCHED_NBR)) AND C.PO_STG_TYPE = P.PO_STG_TYPE
AND C.ITM_SETID = P.ITM_SETID AND C.INV_ITEM_ID = P.INV_ITEM_ID AND
C.CNTRCT_SETID = P.CNTRCT_SETID AND C.CNTRCT_ID = P.CNTRCT_ID AND
C.VERSION_NBR = P.VERSION_NBR AND C.CAT_LINE_NBR = P.CAT_LINE_NBR AND
C.CNTRCT_LINE_NBR = P.CNTRCT_LINE_NBR
/
-- Row(s) affected: 0
-- 03:36:16.893 Process 6058329 ABENDED at Step PO_CMPRICE.MAIN.ISRTCNTR (Action SQL) -- RC = 1476
ROLLBACK
/
-- 03:36:16.931 SQL Error: ORA-01476: divisor is equal to zero

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a PO with contract in it.
2. Approve the PO, Dispatch the PO.
3. Now change the PO to increase the quantity in PO Line
4. Approve the change order



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