CHANGED_ON_DT not updating W_GL_OTHER_F records correctly as it sourcing from GL_CODE_COMBINATIONS (Doc ID 1927009.1)

Last updated on MARCH 08, 2017

Applies to:

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

Goal

In BI Apps 11.1.1.7.1, the POSTED/UNPOSTED status for a GL Transaction is not correct compared to the source EBS System

Investigations :


SDE - SDE_ORA_GLJournalsFact : W_GL_OTHER_FS

Currently BI is considering Incremental records only based on LAST_UPDATE_DATE in GL_CODE_COMBINATIONS. Hence any changes(specifically POSTED/UNPOSTED status - doc_status_id in BI) in GL_JE_LINES are not getting reflected.

SIL : W_GL_OTHER_F

CASE
 WHEN T.ROWID IS NOT NULL
  AND (T.CHANGED_ON_DT = C.CHANGED_ON_DT OR (T.CHANGED_ON_DT IS NULL AND C.CHANGED_ON_DT IS NULL))
  AND (T.AUX1_CHANGED_ON_DT = C.AUX1_CHANGED_ON_DT OR (T.AUX1_CHANGED_ON_DT IS NULL AND C.AUX1_CHANGED_ON_DT IS NULL))
  AND (T.AUX2_CHANGED_ON_DT = C.AUX2_CHANGED_ON_DT OR (T.AUX2_CHANGED_ON_DT IS NULL AND C.AUX2_CHANGED_ON_DT IS NULL))
  AND (T.AUX3_CHANGED_ON_DT = C.AUX3_CHANGED_ON_DT OR (T.AUX3_CHANGED_ON_DT IS NULL AND C.AUX3_CHANGED_ON_DT IS NULL))
  AND (T.AUX4_CHANGED_ON_DT = C.AUX4_CHANGED_ON_DT OR (T.AUX4_CHANGED_ON_DT IS NULL AND C.AUX4_CHANGED_ON_DT IS NULL))
 THEN 'N'
 WHEN T.ROWID IS NOT NULL
 THEN 'U'
 ELSE 'I'
END

We also observed that the Auxiliary columns - AUX1_CHANGED_ON_DT, AUX2_CHANGED_ON_DT, AUX3_CHANGED_ON_DT, AUX4_CHANGED_ON_DT are unmapped to any source columns.

Is there a known solution?
 

Solution

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