Upgrade Step on DLUPSYSE.DMS Fails

(Doc ID 2314707.1)

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.

Symptoms

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.


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

STEPS
-----------------------
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 

 

 

Changes

 

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