My Oracle Support Banner

OBIA 11g : W_GL_BALANCE_F.GL_SEGMENT3_WID Loaded With All Zero Values (Doc ID 2399147.1)

Last updated on MAY 22, 2018

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.10.2 and later
Information in this document applies to any platform.

Symptoms

W_GL_BALANCE_F.GL_SEGMENT3_WID is loaded with all 0.

 

The ETL task has Below Query:-

 

Select W_GL_ACCOUNT_D.ACCOUNT_SEG3_INTEGRATION_ID, W_GL_SEGMENT_D.INTEGRATION_ID, SCD1_WID
From W_GL_ACCOUNT_D, W_GL_SEGMENT_D
Where
W_GL_ACCOUNT_D.ACCOUNT_SEG3_INTEGRATION_ID=W_GL_SEGMENT_D.INTEGRATION_ID;

W_GL_ACCOUNT_D.ACCOUNT_SEG3_INTEGRATION_ID is populated with concatenation of three values where as W_GL_SEGMENT_D.INTEGRATION_ID is a concatenation of two values.

 



Changes

 

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.