The following table provides information about specific changes in metadata properties that require the system to check existing data in regard to the metadata file that you are loading. Only metadata properties that have an effect on referential integrity are listed in the table.
Table 39. Metadata Referential Integrity Checks
| Dimension | Metadata Property Change | Condition That Prevents Metadata From Loading |
|---|---|---|
|
Account |
Is Calculated (from N to Y) |
Checks to see if a journal or template exists for the account, and, if found, prevents the metadata from loading. |
|
Is ICP (from Y to R) |
Checks to see if a journal or template exists for the account and ICP=<Entity>, and, if found, prevents the metadata from loading. |
|
|
Is ICP (from Y to N or from R to N) |
Checks to see if a journal or template exists for the account and ICP <> [ICP None] (because the account is not an intercompany account and ICP members other than [ICP None] is invalid), and, if found, prevents the metadata from loading. |
|
|
Uses Line Items (from Y to N or from N to Y) |
Checks to see if regular data exists for the scenario and account, and, if found, prevents the metadata from loading. Note: From Y to N, the system does not allow access to line-item detail. |
|
|
Custom |
Is Calculated (from N to Y) |
Checks to see if a journal or template exists for this Custom dimension, and, if found, prevents the metadata from loading. |
|
Entity |
Currency |
Checks to see if a journal exists for <Entity Currency Adjs> or <Parent Currency Adjs>, and, if found, prevents the metadata from loading. |
|
Allow Adjustments (from Y to N) Allow Adjustments From Children (from Y to N) |
For Allow Adjustments, checks to see if a journal with <Entity Curr Adjs> or <Parent Currency Adjs> exists for the entity, and, if found, prevents the metadata from loading. For Allow Adjustments From Children, checks to see if a journal with [Parent Adjs] or [Contribution Adjs] exists for the entity, and, if found, prevents the metadata from loading. |
|
|
Is ICP (from Y to N) |
Checks to see if a journal in which the entity is used in the ICP dimension exists, and, if found, prevents the metadata from loading. |
|
|
Scenario |
Zero View For Adjustments |
Checks to see if a journal exists for the scenario, and, if found, prevents the metadata from loading. |
|
Uses Line Items |
Checks to see if regular data exists for an account with this property enabled for the specified scenario, and, if found, prevents the metadata from loading. |
|
|
Application |
Default Value For Active |
Checks to see if a journal or recurring template exists for [Parent Adjs] or [Contribution Adjs], and, if found, prevents the metadata from loading. |
The system also checks for invalid points of view between the load file and the metadata in the application. If a dimension member is not in the load file but exists in a journal in the application, the metadata load is prevented.