My Oracle Support Banner

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 MARCH 01, 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




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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.