Categories
- All Categories
- Oracle Analytics Learning Hub
- 19 Oracle Analytics Sharing Center
- 19 Oracle Analytics Lounge
- 232 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.9K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 86 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Oracle on-Prem GL integration with EDMCS for importing GL Accounting Flex values
Is any Oracle Cloud & Oracle On-Prem EBS customer is using this process in automated way and Oracle note or reference ?
As per Oracle note#2794420.1 Oracle has integration build for this process and recommended Patch 19898918 is applied on test instance to test the functionality. Below two interface tables are provided to import the data files from EDMCS to staging tables. Import of data to interface tables is not automated, need a loading process to import the data to below mentioned interface tables with updated data from EDMCS. Previously Same mechanism was used by DRM, which also utilizes automated process to connect GL with On-prem Hyperion to get the updated data without any manual interventions to updated below tables.
GL_DRM_SEGVALUES_INTERFACE =====> FND_FLEX_VALUES
GL_DRM_HIERARCHY_INTERFACE =====> FND_FLEX_VALUE_NORM_HIERARCHY
Concurrent request is created to call the Oracle seeded package GL_DRM_INTEGRATION_PKG.gl_drm_import_process to get the updated values on Oracle on-prem GL COA value sets.