Issues with alternate schema for EBS GL import
edited Aug 4, 2014 9:41AM in Hyperion Financial Data Quality Management (FDM/FDMEE) (MOSC) 14 commentsAnswered ✓
Hello Hather,
I am tring to use alternate schema to import EBS GL balance data into FDMEE. I followed the instruction in FDMEE Admin guide (11.1.2.3.510) to create alternate schema.
Here is what We did:
1. create a new schema SWFCM
2. Grant select or write on source tables listed in Admin guide to SWFCM. Please see attached alternate_schema_objects.xls and create_swfcm.txt for details
3. Create a new view swfcm.gl_code_combinations with filter conditions. please see create_gl_code_combinations.txt for details
4. create synonyms for other source tables. Please see create_swfcm.txt for details
5. in ODI configuration switch user from APPS to SWFCM. The attached ODI.docx shows the change being made.
Tagged:
0