E-PC:Full Configuration Process (FS_CFCONFIG) Failed When Run After Adding New Chartfield

(Doc ID 2323025.1)

Last updated on OCTOBER 31, 2017

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.55 and later
Information in this document applies to any platform.

Symptoms

When running the FS_CFCONFIG AE program, customer encountered the following issue.

File: /vob/peopletools/src/pssys/blkutil.cppSQL error. Stmt #: 983 Error
Position: 0 Return: 1400 - ORA-01400: cannot insert NULL into
("PSOFT"."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)

An example of navigation:

1. Navigate to Main Menu > Setup Financials/Supply Chain > Common Definitions> Design Chartfields > Configure > Advanced Configuration, and add a new standard ChartField.
2. Enter the new ChartField details by specifying the ChartField name, FieldLength, long name, Changed Prompt Table name etc and then click OK.
3. Click on 'Configure¿ button to run 'Preview Configuration Steps(FS_CFMANUAL).
4. After running the 'Preview Configuration Steps' process, then click on the Process Monitor to access the report.
5. To get the report, go to the Administration Tab in the report manager.
6. On Advanced Configuration page, click on Configure and choose 'FS_CFCONFIG' process to run the Full Configuration Process.

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