Hyperion DRM to EBS GL integration: Errors encountered running Load Segment Values and Hierarchies program; ORA-20104, ORA-20100
Last updated on SEPTEMBER 14, 2016
Applies to:Oracle General Ledger - Version 12.1.3 and later
Information in this document applies to any platform.
When you attempt to run the "Load Segment Values and Hierarchies" concurrent request in EBS, you encounter numerous errors.
(1) Exception when Invoking Web Service -> oracle.apps.fnd.wf.bes.InvokerException: javax.xml.rpc.soap.SOAPFaultException: FailedAuthentication :
The security token cannot be authenticated.
(2) The Summary Flag value is missing.
(3) ORA-20104: Unknown Range Attribute detected.
(4) ORA-20100: compile_hierarchy( ) raised exception.
You are loading the chart of account (COA) values from Hyperion DRM (Data Relationship Management) to EBS General Ledger.
You have data populated in the GL_DRM_SEGVALUES_INTERFACE and GL_DRM_HIERARCHY_INTERFACE tables, but when you run the concurrent request in EBS, you encounter errors.
You are running the DRM exports from a custom program, which was used to populate the interface tables even though the EBS Load Segment Values program automatically takes care of this step.
Refer to the <Document 1315694.1> EBS: Hyperion Data Management Integration with the Oracle Fusion and E-Business Suite General Ledgers for detailed implementation instructions.
You are loading the chart of account (COA) values from Hyperion DRM (Data Relationship Management) to EBS General Ledger using a custom template.
You have populated the GL_DRM_SEGVALUES_INTERFACE and GL_DRM_HIERARCHY_INTERFACE tables manually, even though the EBS Load Segment Values program automatically takes care of this step.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms