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, 2020
Applies to: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:
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?
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