Search This Blog

Thursday, August 2, 2012

hr828473_01.dms Issue

If you have ever encountered this issue while upgrade,do not change the field property to make it work :)
The solution is available with Oracle Support.
Importing HCM_EO_TXN 
Message Set Number: 200
Message Number: 0
Message Reason: File: Data MoverSQL error. Stmt #: 0 Error Position: 0 Return: 1400 - ORA-01400: cannot insert NULL into ("SYSADM"."PS_HCM_EO_TXN"."HR_PTCS_SERVICEID") 
Failed SQL stmt:INSERT INTO PS_HCM_EO_TXN (TRANSACTION_NAME, EOAWPRCS_ID, DELEGATION_APPR, DELEGATION_INIT) VALUES (:1, :2, :3, :4) (200,0)
SQL Error. Error Position: 0 Return: 1400 - ORA-01400: cannot insert NULL into ("SYSADM"."PS_HCM_EO_TXN"."HR_PTCS_SERVICEID") 
INSERT INTO PS_HCM_EO_TXN (TRANSACTION_NAME, EOAWPRCS_ID, DELEGATION_APPR, DELEGATION_INIT) VALUES (:1, :2, :3, :4)
SQL Error. Error Position: 0 Return: 0 - Error: SQL unable to commit transaction for HCM_EO_TXN 
Ended: Wed Aug 01 06:49:00 2012
Unsuccessful completion
'ORA-01400: cannot insert NULL into' - issue is not one or two in Oracle Support. There are a lot out there reported. For majority of this issue has a patch to resolve the bug.



No comments:

Post a Comment