C Creating an Alternate Schema in an Enterprise Resource Planning (ERP) Source System
Prebuilt integrations to an Enterprise Resource Planning (ERP) source system in Oracle Hyperion Financial Data Quality Management, Enterprise Edition use a basic filter for data extraction, and assume that appropriate security has been defined to enable access by FDMEE. In some environments, direct access to the source systems tables is prohibited because of system policies, or you want to define a source system filter that is more detailed than what is provided in the FDMEE user interface.
For example, in the Account Reconciliation Manager (ARM) you want to extract balance sheet accounts or active accounts only from the source system. To do this, create an alternate schema in the source system. This method provides a desired level of security, a different source system filter, or both.
To create an alternate hierarchy for Oracle E-Business Suite and Peoplesoft (PSFT) systems:
Any views created in the new schema or synonyms must use the exact same name as specified in Source System Tables Used by FDMEE. Because the table and view names are the same as the core schema, FDMEE can access the updated contents with a change to the schema specification in ODI.
For SAP, change the filter definition in the adapter rather than creating an alternate schema.
Before making any changes, it is recommended that you contact Oracle support to review the process to ensure a smooth update to the system.