Change Package Application from #28 to 31 Is Errors Out. Sql Error. Error Position: 0 Return: 1400 - Ora-01400: Cannot Insert Null into ("Sysadm"."Ps_Eoatt_Cfgtbl_Ln"."Eoatt_Product")
(Doc ID 2598666.1)
Last updated on JULY 21, 2020
Applies to:PeopleSoft Enterprise SCM Purchasing - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
When attempting to apply patches from FSCM PUM Image 31,
the following error occurs.
Message Reason: File: Data MoverSQL error. Stmt #: 0 Error Position: 0 Return: 1400 - ORA-01400: cannot insert NULL into ("SYSADM"."PS_EOATT_CFGTBL_LN"."EOATT_PRODUCT")
Failed SQL stmt: INSERT INTO PS_EOATT_CFGTBL_LN (EOATT_CONFIG_ID, LANGUAGE_CD, DESCR) VALUES (:1, :2, :3) (200,0)
SQL Error. Error Position: 0 Return: 1400 - ORA-01400: cannot insert NULL into ("SYSADM"."PS_EOATT_CFGTBL_LN"."EOATT_PRODUCT")
The issue can be reproduced at will with the following steps:
1. Create a change package consisting of the patches from FSCM PUM Image 31.
2. Apply the change package to a target environment.
3. Experience issue.
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