Activity : Performing R12.1 HR_PF.K RUP4
Current Apps version : 12.1.2
Database version: 11.1.0.7.0 - 64bit Production
During HRMS RUP4 Patching got below error while applying hrglobal driver.
While running hrglobal.drv "paymxearnexrules.ldt" worker failed.************* Start of AD Worker session *************
AD Worker version: 12.0.0
AD Worker started at: Sat Aug 27 2011 15:59:40
APPL_TOP is set to /KIRANG/applmgr/1200
************* Start of AD Worker session *************
AD Worker version: 12.0.0
AD Worker started at: Sat Aug 27 2011 15:59:40
APPL_TOP is set to /KIRANG/applmgr/1200
************* Start of AD Worker session *************
AD Worker version: 12.0.0
AD Worker started at: Sat Aug 27 2011 15:59:40
APPL_TOP is set to /KIRANG/applmgr/1200
Program completed successfully
FAILED: file paymxearnexrules.ldt on worker 1 for product pay username APPS.
ATTENTION: All workers either have failed or are waiting:
FAILED: file paymxearnexrules.ldt on worker 1.
ATTENTION: Please fix the above failed worker(s) so the manager can continue.
-------------------------------------------------------------------------
From worker Logs :
Time when worker restarted job: Sat Aug 27 2011 15:59:45
Loading data using FNDLOAD function.
FNDLOAD APPS/***** 0 Y UPLOAD @PAY:patch/115/import/paymxearnexrules.lct
@PAY:patch/115/import/US/loc_mx/paymxearnexrules.ldt - LEG_VIEW=hr_pay_mx_implementation
Connecting to APPS......Connected successfully.
Calling FNDLOAD function.
Returned from FNDLOAD function.
Log file: /KIRANG/applmgr/1200/admin/KIRANG/log/loc_mx_paymxearnexrules_ldt.log
Error calling FNDLOAD function.
Time when worker failed: Sat Aug 27 2011 15:59:46
$ view /KIRANG/applmgr/1200/admin/KIRANG/log/loc_mx_paymxearnexrules_ldt.log
Current system time is Sat Aug 27 15:59:45 2011
From error Logs :
MX_EARN_EXEMPTION_RULES_F"."ELEMENT_CLASSIFICATION_ID")
Error loading seed data for MX_EARN_EXEMPTION_RULES: EFFECTIVE_START_DATE = 01/01/1900,
EFFECTIVE_END_DATE = 31/12/4712, TAX_TYPE = STATE, ELEMENT_CLASSIFICATION_NAME = Supplemental
Earnings:Social Foresight Earnings, STATE_CODE = SIN, ORA-01400: cannot insert NULL into
("HR"."PAY_MX_EARN_EXEMPTION_RULES_F"."ELEMENT_CLASSIFICATION_ID")
Error loading seed data for MX_EARN_EXEMPTION_RULES: EFFECTIVE_START_DATE = 01/01/1900,
EFFECTIVE_END_DATE = 31/12/4712, TAX_TYPE = STATE, ELEMENT_CLASSIFICATION_NAME = Aid for Meals,
STATE_CODE = TAMPS, ORA-01400: cannot insert NULL into
("HR"."PAY_MX_EARN_EXEMPTION_RULES_F"."ELEMENT_CLASSIFICATION_ID")
Error loading seed data for MX_EARN_EXEMPTION_RULES: EFFECTIVE_START_DATE = 01/01/1900,
EFFECTIVE_END_DATE = 31/12/4712, TAX_TYPE = STATE, ELEMENT_CLASSIFICATION_NAME = Aid for Rent,
STATE_CODE = TAMPS, ORA-01400: cannot insert NULL into
("HR"."PAY_MX_EARN_EXEMPTION_RULES_F"."ELEMENT_CLASSIFICATION_ID")
Error loading seed data for MX_EARN_EXEMPTION_RULES: EFFECTIVE_START_DATE = 01/01/1900,
EFFECTIVE_END_DATE = 31/12/4712, TAX_TYPE = STATE, ELEMENT_CLASSIFICATION_NAME = Attendance and
Punctuality Incentives, STATE_CODE = ZAC, ORA-01400: cannot insert NULL into
("HR"."PAY_MX_EARN_EXEMPTION_RULES_F"."ELEMENT_CLASSIFICATION_ID")
Error loading seed data for MX_EARN_EXEMPTION_RULES: EFFECTIVE_START_DATE = 01/01/1900,
EFFECTIVE_END_DATE = 31/12/4712, TAX_TYPE = STATE, ELEMENT_CLASSIFICATION_NAME = Aid for Meals,
STATE_CODE = ZAC, ORA-01400: cannot insert NULL into
("HR"."PAY_MX_EARN_EXEMPTION_RULES_F"."ELEMENT_CLASSIFICATION_ID")
Error loading seed data for MX_EARN_EXEMPTION_RULES: EFFECTIVE_START_DATE = 01/01/1900,
EFFECTIVE_END_DATE = 31/12/4712, TAX_TYPE = STATE, ELEMENT_CLASSIFICATION_NAME = Aid for Rent,
STATE_CODE = ZAC, ORA-01400: cannot insert NULL into
("HR"."PAY_MX_EARN_EXEMPTION_RULES_F"."ELEMENT_CLASSIFICATION_ID")
Concurrent request completed
Current system time is Sat Aug 27 15:59:46 2011
As per Note : 1301759.1 "" If you are NOT using MX Legislation, then simply skip this
error and continue on. "".
WE are not using MX , so ignoring and proceeding further.
**************************
Summary:
**************************
Issue : paymxearnexrules.ldt worker failed during HRMS Patching
Details :-
ATTENTION: All workers either have failed or are waiting:
FAILED: file paymxearnexrules.ldt on worker 1.
Error :
Error loading seed data for MX_EARN_EXEMPTION_RULES: EFFECTIVE_START_DATE = 01/01/1900,
EFFECTIVE_END_DATE = 31/12/4712, TAX_TYPE = STATE, ELEMENT_CLASSIFICATION_NAME = Aid for Meals,
STATE_CODE = ZAC, ORA-01400: cannot insert NULL into
("HR"."PAY_MX_EARN_EXEMPTION_RULES_F"."ELEMENT_CLASSIFICATION_ID")
Error loading seed data for MX_EARN_EXEMPTION_RULES: EFFECTIVE_START_DATE = 01/01/1900,
EFFECTIVE_END_DATE = 31/12/4712, TAX_TYPE = STATE, ELEMENT_CLASSIFICATION_NAME = Aid for Rent,
STATE_CODE = ZAC, ORA-01400: cannot insert NULL into
("HR"."PAY_MX_EARN_EXEMPTION_RULES_F"."ELEMENT_CLASSIFICATION_ID")
Solution :
Ignoring the issue and proceeding further, as MX Legislations not installed in system..
Skip the worker using adctrl and proceed with further execution of the hrglobal driver...
Ref SR/Note : 1301759.1
******************************
No comments:
Post a Comment