0FI_GL_14 Extractor Delta Issue

system · February 10, 2014, 10:39am

Hi All,

We’ve been getting duplicate rows errors whenever we get the delta of 0FI_GL_14 Extractor.

What’s the correct way of designing a Data Flow for this type of Delta Extractor?

Your ideas and thoughts will be appreciated!

Thanks!
Rey Piad

reypiad (BOB member since 2012-03-23)

system · February 10, 2014, 9:50pm

Are the duplicates within the delta itself, of is it clashing with the contents destination table ?

If its the latter, you can fix it with a table comparison. If its the former, then it either:

You have the wrong keys defined, and its not really a duplicate or
The extractor is returning data out of sequence. I have this issue, but only with 2LIS extractors. If this is your issue, I have no solution for you.

Leigh Kennedy (BOB member since 2012-01-17)

system · February 6, 2017, 1:32pm

Hi,

I am facing the same issue of duplicate entries when using extractor 0FI_GL_14 for delta load. Please let me know if you were able to fix the issue?

Regards
Gaurav

gaurav4jain (BOB member since 2017-02-06)