My Oracle Support Banner

OBIA 7962 How are records processed to W_GL_LINKAGE_INFORMATION_G table (Doc ID 1338142.1)

Last updated on DECEMBER 13, 2019

Applies to:

Business Intelligence Applications Consumer - Version 7.9.6.2 [AA 1830] and later
Information in this document applies to any platform.

Goal

1) Customer needed clarification about the logic of how records are processed from W_GL_LINKAGE_INFORMATION_GS to W_GL_LINKAGE_INFORMATION_G table.
Based on the logic given in the mapping it seems that all the duplicate records from W_GL_LINKAGE_INFORMATION_GS table are not inserted to W_GL_LINKAGE_INFORMATION_G table. Would it cause any issues ?
For e.g
Take the scenario, when first time we are running jobs, mappings will put all rows from W_GL_LINKAGE_INFORMATION_GS to W_GL_LINKAGE_INFORMATION_G. But somehow if the first load fails and then you restart it doesn't puts all the rows from W_GL_LINKAGE_INFORMATION_GS to W_GL_LINKAGE_INFORMATION_G.
It is taking delta of records.

2)They also had follow-up question whether duplicate records are allowed in W_GL_LINKAGE_INFORMATION_G table.
3) What is the true purpose of W_GL_LINKAGE_INFORMATION_G table?

Solution

To view full details, sign in with your My Oracle Support account.

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


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.