EGL9.2: FS_CFCONFIG Is Giving Error Position: 0 Return: 1400 - ORA-01400: cannot insert NULL into ("SYSADM"."PSPCMNAME"."PACKAGEROOT") When Adding a New Chartfield After Upgrade To FSCM 9.2. (Doc ID 2068824.1)

Last updated on SEPTEMBER 27, 2017

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 and later
Information in this document applies to any platform.
*** Checked for currency 23-Mar-2017***

Symptoms

On : 9.2 version, ChartField Configuration

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

ERROR
-----------------------
File: /vob/peopletools/src/pssys/blkutil.cppSQL 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
-----------------------
The issue can be reproduced at will with the following steps:
1. Add a new chartfield;
2. Run the chartfield configuration process;

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot add new chartfield in the environment.

Cause

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