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 AUGUST 04, 2016

Applies to:

PeopleSoft Enterprise SCM Supply Planning - Version 8.9 and later
Information in this document applies to any platform.

Goal

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?

Solution

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