Upgrade Step on DLUPSYSE.DMS Fails
Last updated on DECEMBER 12, 2017
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms