My Oracle Support Banner

EGL9.2: When Adding a New Chartfield After Upgrade To FSCM 9.2, Chartfield Configuration( FS_CFCONFIG) Process Fails With 'ORA-01400: cannot insert NULL into ("xxxxx"."PSPCMNAME"."PACKAGEROOT") ' Error (Doc ID 2068824.1)

Last updated on APRIL 23, 2019

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

Issue:
-------

When user is adding a new chartfield from Advanced Configuration the following error occurs.

Error:
------
Stmt #: 983 Error Position: 0 Return: 1400 - ORA-01400: cannot insert NULL into ("SYSADM"."PSPCMNAME"."PACKAGEROOT")
Failed SQL stmt: INSERT INTO PSPCMNAME (OBJECTID1, OBJECTVALUE1, OBJECTID2, OBJECTVALUE2, OBJECTID3, OBJECTVALUE3, OBJECTID4, OBJECTVALUE4, OBJECTID5, OBJECTVALUE5, OBJECTID6, OBJECTVALUE6, OBJECTID7, OBJECTVALUE7, NAMENUM, RECNAME, REFNAME) VALUES (:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14, :15,:16,:17)

Steps to Replicate:
---------------------
1. Add a new chartfield;
2. Run the chartfield configuration process;


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.