How To Resolve the Error "Assignment of a NULL value to a NOT NULL column" when Running the 'Post Purchase Order Updates' Process (PL_POST_PO) Following an Upgrade
(Doc ID 1598941.1)
Last updated on JANUARY 13, 2018
PeopleSoft Enterprise SCM Supply Planning - Version 8.9 and later Information in this document applies to any platform.
The 'Post Purchase Order Updates' process (PL_POST_PO) (navigation: Supply Planning, Commit Plan, Planning, Post Updates) fails with the below error following an upgrade:
SQL error. Stmt #: 1623 Error Position: 0 Return: 8601 - [IBM][CLI Driver][DB2/AIX64] SQL0407N Assignment of a NULL value to a NOT NULL column "TBSPACEID=240, TABLEID=9495, COLNO=59" is not allowed. SQLSTATE=23502 (SQLSTATE 23502) -407 Failed SQL stmt: UPDATE PS_PL_PO_TAO6 SET MIN_SEQ_NBR = ( SELECT B.SEQ_NBR FROM PS_PL_PO_PLAN_ORD B WHERE PROBINST = 'MATMRD' AND PS_PL_PO_TAO6.BUSINESS_UNIT = B.BUSINESS_UNIT AND PS_PL_PO_TAO6.PO_ID = B.PO_ID AND PS_PL_PO_TAO6.LINE_NBR = B.LINE_NBR AND PS_PL_PO_TAO6.SCHED_NBR = B.SCHED_NBR AND B.SE Q_NBR = ( SELECT MIN(A.SEQ_NBR) FROM PS_PL_PO_PLAN_ORD A WHERE PS_PL_PO_TAO6.BUSINESS_UNIT = A.BUSINESS_UNIT AND PS_PL_PO_TAO6.PO_ID = A.PO_ID AND PS_PL_PO_TAO6.LINE_NBR = A.LINE_NBR AND PS_PL_PO_TAO6
Process 7901524 ABENDED at Step PL_POST_PO.UpdPPPO.InsPPPSQ (SQL) Assignment of a NULL value to a NOT NULL column. Failed SQL stmt: UPDATE PS_PL_PO_TAO6 SET MIN_SEQ_NBR
How to resolve it?
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