Oracle Fusion ERP Analytics

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Oracle on-Prem GL integration with EDMCS for importing GL Accounting Flex values

Question
1
Views
0
Comments
Gian Jamwal
Gian Jamwal Rank 1 - Community Starter
edited May 13, 2025 7:26PM in Oracle Fusion ERP Analytics

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.

Tagged: