Upgrade Step on DLUPSYSE.DMS Fails

(Doc ID 2314707.1)

Last updated on JANUARY 25, 2018

Applies to:

PeopleSoft Enterprise CS Student Financials - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.


On Campus Solutions 9.2 upgrade, Task 6-13-11: Exporting Application System Data, the DLUPSYSE.DMS fails with syntax errors due to missing WHERE clauses on the following tables:

syntax errors as follows - script attached:
export SCCFP_CNTXT_DFN where;
export SCCFP_CNTXT_REC where;
export SCCFP_CNTXT_RF where;
export SCCFP_CNVR where;
export SCCFP_CNVR_FLD where;
export SCCFP_CNVR_VAL where;
export SCCFP_COUNTER where;
export SCCFP_FILE_FLD where;
export SCCFP_FILE_SGT where;
export SCCFP_MAP_DFN where;
export SCCFP_MAP_FLD where;
export SCCFP_MAP_REC where;

All Required for Upgrade (RFU) updates have been applied.

The delivered upgrade scripts should incorporate appropriate WHERE clauses on all table exports.

The issue can be reproduced at will with the following steps:
1. Perform the Campus Solutions 9.0 to 9.2 upgrade.

PeopleSoft Enterprise Campus Solutions Community  Support Blog  Information_Centers  Maintenance_Advisor 






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