When Attempting to Run HRGlobal on an Instance Which Does Not have Mexican (MX) Legislation Installed, Error Occur: paymxearnexrules.ldt ORA-1400: cannot insert NULL into ("HR"."PAY_MX_EARN_EXEMPTION_RULES_F"."ELEMENT_CLASSIFICATION_ID") (Doc ID 1336293.1)

Last updated on JULY 19, 2016

Applies to:

Oracle Human Resources - Version 12.1.3 and later
Information in this document applies to any platform.


This note provides a brief overview of


Symptoms


On :  12.1.3 version, Install / Upgrade Issues


When attempting to run HRGlobal on an instance which DOES NOT have Mexican (MX) legislation installed, 

the following error occurs:

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 = Pantry Coupons, STATE_CODE = QRO, ORA-1400:
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 = Christmas Bonus, STATE_CODE = SIN, ORA-1400:
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 = Supplemental Earnings:Social Foresight
Earnings, STATE_CODE = SIN, ORA-1400: cannot insert NULL into
("HR"."PAY_MX_EARN_EXEMPTION_RULES_F"."ELEMENT_CLASSIFICATION_ID")

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms