HCM Shared Components - Receive Error in Step Run Post Data Conversion AE - PODC36398163 When Full PUM Image or Other Maintenance from HCM PUM Image 49
(Doc ID 3052483.1)
Last updated on FEBRUARY 18, 2025
Applies to:
PeopleSoft Enterprise HCM Human Resources - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
Symptoms
When applying HCM PUM Image 49, or certain fixes obtained from the Image, Run Post Data Conversion AE - PODC36398163 fails with the following error (obtained from the maintenance log)
Copyright (c) 1988-2024 Oracle and/or its affiliates.
All Rights Reserved
File: C:\PT860P09C_2310082002-retail\peopletools\src\psmgr\mgrgensql.cppSQL error. Stmt #: 1844 Error Position: 0 Return: 805 - ORA-00001: unique constraint (SYSADM.PS_PSPTCS_MAPFLDS) violated
Failed SQL stmt: INSERT INTO PSPTCS_MAPFLDS ( PORTAL_NAME, PORTAL_OBJNAME, PTCS_SERVICEID, PTCS_INSTANCEID, PTCS_PARAMETERNAME, PTCS_PNLFLDNAME, PTCS_PNLNAME, PTCS_MAPFIELDTYPE, PTCSREFRESHSERVICE, PTCS_MAPNULLVALUE, PTCS_FIELDMENUOPT, PTCS_SEQNUM_FMNU) VALUES ( :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12)
Message Set Number: 200
Message Number: 0
Message Reason: File: C:\PT860P09C_2310082002-retail\peopletools\src\psmgr\mgrgensql.cppSQL error. Stmt #: 1844 Error Position: 0 Return: 805 - ORA-00001: unique constraint (SYSADM.PS_PSPTCS_MAPFLDS) violated
Failed SQL stmt: INSERT INTO PSPTCS_MAPFLDS ( PORTAL_NAME, PORTAL_OBJNAME, PTCS_SERVICEID, PTCS_INSTANCEID, PTCS_PARAMETERNAME, PTCS_PNLFLDNAME, PTCS_PNLNAME, PTCS_MAPFIELDTYPE, PTCSREFRESHSERVICE, PTCS_MAPNULLVALUE, PTCS_FIELDMENUOPT, PTCS_SEQNUM_FMNU) VALUES ( :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, (200,0)
File: C:\PT860P09C_2310082002-retail\peopletools\src\psmgr\mgrgensql.cppSQL error. Stmt #: 1844 Error Position: 0 Return: 805 - ORA-00001: unique constraint (SYSADM.PS_PSPTCS_MAPFLDS) violated
Failed SQL stmt: INSERT INTO PSPTCS_MAPFLDS ( PORTAL_NAME, PORTAL_OBJNAME, PTCS_SERVICEID, PTCS_INSTANCEID, PTCS_PARAMETERNAME, PTCS_PNLFLDNAME, PTCS_PNLNAME, PTCS_MAPFIELDTYPE, PTCSREFRESHSERVICE, PTCS_MAPNULLVALUE, PTCS_FIELDMENUOPT, PTCS_SEQNUM_FMNU) VALUES ( :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12)
Message Set Number: 200
Message Number: 0
Message Reason: File: C:\PT860P09C_2310082002-retail\peopletools\src\psmgr\mgrgensql.cppSQ
Steps to Reproduce:
- Create a package to apply all maintenance or selective maintenance from PUM 49
- Note a failure at the step for PODC36398163
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |