You can create metadata rules once and rerun the rules, as necessary.
For general ledger source systems:
For Fusion and E-Business Suite source systems, the chart of accounts is the collection of general ledger segments with various value sets, which are mapped to the dimensions to pull the dimension members and hierarchies.
Similarly for PeopleSoft Enterprise Financial Management, the chartfields are mapped to the dimensions to pull the dimension members and hierarchies.
Note: | Metadata rules are not used in ERP Integrator integrations with human resource source systems. |
Before you define metadata rules:
Ensure that your source system data does not include special characters. Special characters are not supported in Financial Management target applications.
Register your source systems and target applications for use with ERP Integrator. See Registering ERP Source Systems and Registering Target Applications.
Select the source accounting entities in the registered source system. See Selecting Source Accounting Entities.
Define the import format. See Working with Import Formats.
Define the location. See Defining Locations.
Note: | Performance Management Architect supports Shared and Local dimensions. ERP Integrator also supports Shared and Local dimensions in applications. |
At a high level, follow this process to define metadata rules:
Create the metadata rule.
Select the dimension.
Define the mapping details and determine how you want to handle intercompany segments. See Defining the Metadata Rule Details.
Optional: Define the segment hierarchies or chartfield trees to be extracted.
Save and run the metadata rule.
Optional: Check the status of the rule. See Viewing Process Details.
To create metadata rules:
In the Tasks pane, select Metadata.
Note:
You cannot create more than one metadata rule for the same ledger or business unit for each target application.
Select the location, and then click OK.
Note:
A location can be created without an accounting entity. This feature allows users to load data from multiple accounting entities from a single location. In this case, accounting entities are associated with the data rules. If no accounting entity is specified for the location, the accounting entity from the import format is used.
The dimensions listed are based on the import format.
Define the mapping details for each dimension you select. See Defining the Metadata Rule Details.
to select the