My Oracle Support Banner

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Goal
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.