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

Question

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

Thomas Dodds · Answer

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.

3231950 · Answer

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 · Answer

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.