Hyperion DRM to EBS GL integration: Errors encountered running Load Segment Values and Hierarchies program; ORA-20104, ORA-20100 (Doc ID 1511596.1)

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.

Symptoms

When you attempt to run the "Load Segment Values and Hierarchies" concurrent request in EBS, you encounter numerous errors.

ERRORS ENCOUNTERED

(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.

BACKGROUND INFORMATION

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.




Changes

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.

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms