Metadata Load issue for Shared members from Oracle table to Hyperion Planning 11.1.2.1 using ODI 11.

Hi Experts,

I am trying to Load Metadata from Oracle Table (Extracted out of Essbase dimension) to Planning Application using ODI 11.1.1.5 version.

Essbase Dept Hierarchy.(Structure of Dept Essbase dimension)

Dept

    Total Dept

         XYZ

    Alt_hierarchy.

I have extracted IDESCENDANTS of Total Dept into X table and IDESCENDANTS of Alt_Hierarchy to Y table.

X contents(Primary Hierarchy) are loaded into Planning using ODI and its loaded perfectly.

Y contents(Alt Hierarchy)   are loaded into Planning using ODI but it successfully loads in ODI but in Planning application the shared members are created for some members are for some parents it is not getting created.