Bug With HCM900_NC14_MLD.DMS In MP14ML - HCM900_NC14_MLD_correct.dms (Doc ID 1568093.1)

Last updated on NOVEMBER 02, 2015

Applies to:

PeopleSoft Enterprise CS Campus Community - Version 9 to 9 [Release 9]
Information in this document applies to any platform.

Goal

 When attempting to run the following DMS script via Maintenance Pack 14 ML,
the following error occurs.

ERROR
-----------------------
Started:  Wed May 15 15:53:04 2013
Data Mover Release: 8.53.02
Database: CRDMO90 (ENG)
SQL Successful -  DELETE FROM PSPROJECTDEFN WHERE PROJECTNAME = 'HCM900_NC14_MLD'
SQL Successful -  DELETE FROM PSPROJECTITEM WHERE PROJECTNAME = 'HCM900_NC14_MLD'
Indexing export file K:\pt853\staging\softwareupdateHCM900_MP14_MLD{d93fcaa8-7bd9-11e0-af91-ebe29acf856d}\scripts\maint\HCM900_NC14_MLD.DAT
Input file: K:\pt853\staging\softwareupdateHCM900_MP14_MLD{d93fcaa8-7bd9-11e0-af91-ebe29acf856d}\scripts\maint\HCM900_NC14_MLD.DAT (ENG)
Commit done at end of record
Importing  PSPROJECTDEFN
Import  PSPROJECTDEFN  1
Updating statistics for PSPROJECTDEFN
Input file: K:\pt853\staging\softwareupdateHCM900_MP14_MLD{d93fcaa8-7bd9-11e0-af91-ebe29acf856d}\scripts\maint\HCM900_NC14_MLD.DAT (ENG)
Importing  PSPROJECTITEM
Import  PSPROJECTITEM  12
Updating statistics for PSPROJECTITEM
SQL Successful -  DELETE FROM PS_ACCESS_GRP_TBL WHERE EXISTS (SELECT 'X' FROM PSPROJECTITEM B WHERE B.PROJECTNAME='HC9_NC6' AND B.OBJECTTYPE=13 AND PS_ACCESS_GRP_TBL.ACCESS_GROUP = B.OBJECTVALUE1)
Input file: K:\pt853\staging\softwareupdateHCM900_MP14_MLD{d93fcaa8-7bd9-11e0-af91-ebe29acf856d}\scripts\maint\HCM900_NC14_MLD.DAT (ENG)
Importing  ACCESS_GRP_TBL
Import  ACCESS_GRP_TBL  0
Updating statistics for ACCESS_GRP_TBL
SQL Error. Error Position: 12  Return: 942 - ORA-00942: Table ou vue inexistante
DELETE FROM PS_MLDIMENSION WHERE EXISTS (SELECT 'X' FROM PSPROJECTITEM B WHERE B.PROJECTNAME='HCM900_NC14_MLD' AND B.OBJECTTYPE=26 AND PS_MLDIMENSION.DIMENSION_ID = B.OBJECTVALUE1)
Error: SQL execute error for DELETE FROM PS_MLDIMENSION WHERE EXISTS (SELECT 'X' FROM PSPROJECTITEM B WHERE B.PROJECTNAME='HCM900_NC14_MLD' AND B.OBJECTTYPE=26 AND PS_MLDIMENSION.DIMENSION_ID = B.OBJECTVALUE1)
Ended: Wed May 15 15:53:10 2013
Unsuccessful completion


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Attempt to run DMS script - HCM900_NC14_MLD-original.dms

Solution

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