OBIA 7963 Incremental ETL Workflow SDE_ORA_GLRevenueFact_AdjustmentDistribution Not Loading All Data (Doc ID 2002595.1)

Last updated on JUNE 15, 2017

Applies to:

Business Intelligence Applications Consumer - Version 7.9.6.3 [AN 1900] and later
Information in this document applies to any platform.

Symptoms

OBIA 7.9.6.3
Running Oracle provided (out of the box)  ETL in a full load execution plan, then testing loading in an incremental execution plan. In comparing the two, you notice that the incremental load of W_GL_REVN_F is missing rows.

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