Effective_from_dt changes in fnd_flex_values issue in w_gl_segment_d (Doc ID 1671587.1)

Last updated on JULY 17, 2017

Applies to:

Data Warehouse Business Adapter for Oracle - Version 7.9.6.2 [AA 1830] to 7.9.6.4 [Release V7]
Information in this document applies to any platform.

Symptoms

When a segment value code's effective from date changes in EBS, the subsequent incremental load inserts a new row into W_GL_SEGMENT_D keeping the old record, both records have CURRENT_FLG as Y
Related DW Tables:
 W_GL_SEGMENT_D

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms