HCM Extract Import Errors

Here are some common possible errors while importing the extracts from one environment to another environment.

Error:You must enter a value for Rule.

Your error log may show something like this.

JBO-27023: Failed to validate all rows in a transaction.JBO-${adfBundle['oracle.apps.fnd.applcore.messages.FndMessagesResourceBundle']['PER:::PER_EXTS_CMN_REQ_ATTR']}:
<MESSAGE>
<NUMBER>PER-1531176</NUMBER>
<TEXT>You must enter a value for Rule.</TEXT>
<CAUSE/>
<ACTION/>
<DETAILS>Value is required for this attribute.</DETAILS>
<INCIDENT/>
</MESSAGE>JBO-PER:::PER_EXTS_DELMT_RULE_FRML: <MESSAGE>
<NUMBER>PER-1530694</NUMBER>
<TEXT>The formula ID provided for the rule is invalid.</TEXT>
<CAUSE/>
<ACTION/>
<DETAILS/>
<INCIDENT/>
</MESSAGE>

Reason:
One of the record attributes is defined as RULE but the import is unable to find the fast formula.

Solution:
- Check if you have created the fast formula in your target environment
- If the fast formula is already created check if the effective start date of fast formula is on or before the extract definition/attribute effective date
Example: When you are creating an attribute the you might have given the effective date as 01/01/1950 but you created the fast formula as of 01/01/1951
-Check if you have created any legislative data group (LDG) specific fast formula.The LDG of extract and fast formula should match.

You may want to remove/edit the attribute with formulas in XML,export the extract first and then debug the issue.