My Oracle Support Banner

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.

Symptoms

ISSUE

When attempting to apply patches from FSCM PUM Image 31,
the following error occurs.

ERROR

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")


STEPS

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.




Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.