When Updating To PUM Image 48, Data Mover Export "UPD34764754_01_EXP_DMS" Fails with "ORA-01843: Not a Valid Month" Error.
(Doc ID 3007992.1)
Last updated on JUNE 13, 2024
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 updates from PUM Image 48, during Change Assistant job "Running Data Mover Export" UPD34764754_01_EXP_DMS step fails with the following error:
Exporting HR_MO_FLDNM_TBL
Export HR_MO_FLDNM_TBL 2
Exporting HR_MO_FLDNM_LNG
Export HR_MO_FLDNM_LNG 2
Exporting HR_MO_TBL
Message Set Number: 200
Message Number: 0
Message Reason: File: Data MoverSQL error. Stmt #: 0 Error Position: 227 Return: 1843 - ORA-01843: Not a Valid Month.
Failed SQL stmt: SELECT HR_MO_MSE_OVR_ID,TO_CHAR(EFFDT,'YYYY-MM-DD'),DESCR100,SYSTEM_DATA_FLG FROM PS_HR_MO_TBL WHERE HR_MO_MSE_OVR_ID IN ('EMPLOYEE_INFO_1', 'EMPLOYEE_INFO_2', 'EMPLOYEE_INFO_3', 'JOB_INFO_1', 'JOB_INFO_2') AND EFFDT = TO_DATE('10-OCT-2022','dd-mon-yyyy') (200,0)
SQL Error. Error Position: 227 Return: 1843 - ORA-01843: Not a Valid Month.
SELECT HR_MO_MSE_OVR_ID,TO_CHAR(EFFDT,'YYYY-MM-DD'),DESCR100,SYSTEM_DATA_FLG FROM PS_HR_MO_TBL WHERE HR_MO_MSE_OVR_ID IN ('EMPLOYEE_INFO_1', 'EMPLOYEE_INFO_2', 'EMPLOYEE_INFO_3', 'JOB_INFO_1', 'JOB_INFO_2') AND EFFDT = TO_DATE('10-OCT-2022','dd-mon-yyyy')
Error: SQL execute error for HR_MO_TBL
Ended: Tue Feb 6 11:46:33 2024
Unsuccessful completion
Export HR_MO_FLDNM_TBL 2
Exporting HR_MO_FLDNM_LNG
Export HR_MO_FLDNM_LNG 2
Exporting HR_MO_TBL
Message Set Number: 200
Message Number: 0
Message Reason: File: Data MoverSQL error. Stmt #: 0 Error Position: 227 Return: 1843 - ORA-01843: Not a Valid Month.
Failed SQL stmt: SELECT HR_MO_MSE_OVR_ID,TO_CHAR(EFFDT,'YYYY-MM-DD'),DESCR100,SYSTEM_DATA_FLG FROM PS_HR_MO_TBL WHERE HR_MO_MSE_OVR_ID IN ('EMPLOYEE_INFO_1', 'EMPLOYEE_INFO_2', 'EMPLOYEE_INFO_3', 'JOB_INFO_1', 'JOB_INFO_2') AND EFFDT = TO_DATE('10-OCT-2022','dd-mon-yyyy') (200,0)
SQL Error. Error Position: 227 Return: 1843 - ORA-01843: Not a Valid Month.
SELECT HR_MO_MSE_OVR_ID,TO_CHAR(EFFDT,'YYYY-MM-DD'),DESCR100,SYSTEM_DATA_FLG FROM PS_HR_MO_TBL WHERE HR_MO_MSE_OVR_ID IN ('EMPLOYEE_INFO_1', 'EMPLOYEE_INFO_2', 'EMPLOYEE_INFO_3', 'JOB_INFO_1', 'JOB_INFO_2') AND EFFDT = TO_DATE('10-OCT-2022','dd-mon-yyyy')
Error: SQL execute error for HR_MO_TBL
Ended: Tue Feb 6 11:46:33 2024
Unsuccessful completion
The issue can be reproduced at will with the following steps:
1. Create change package from PUM Image 48
2. Apply change package using Change Assistant
3. Run "Running DataMover Export UPD34764754_01_EXP_DMS" step.
Changes
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 |
Changes |
Cause |
Solution |
References |