Oracle Business Intelligence Applications

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Business Intelligence Applications

Categories

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

If Node ID has the same value as one of the detail nodes, then the current extract causes duplicates

Received Response
1
Views
3
Comments
3231950
3231950 Rank 2 - Community Beginner
in Oracle Business Intelligence Applications

Hi Gurus,

We are having the following issue, The fixes i found are for people soft. But we are using Oracle EBS 12c

  • when Node ID has the same value as one of the detail nodes, then the current extract causes duplicates.

The parent node is being repeated for every child in the hierarchy


Is there any fix for this ?


Please share your expertise if you have encountered the same issue and you were able to fix it.


Much appreciated.


Thank You 

Answers

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    Looks like you need to fabricate/customize to ensure uniqueness across parent/child.  If I remember right, uniqueness is achieved through the INTEGRATION_ID - you might have to add a column component to that to ensure it.

  • 3231950
    3231950 Rank 2 - Community Beginner

    Hi Thomas,

    I found a solution for the same issue but in people soft:

    • If a PSFT tree is a summer tree and if the detail table and the corresponding node table are different but the Node ID has the same value as one of the detail nodes, then the current extract causes duplicates.


    Please advise if there is anything similar to EBS we can apply


    Thank You

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    Customize the content of the integration_id so you don't get duplicates ... if you don't want to follow that, then open an SR with Oracle and reference the one dealing with PSoft.