My Oracle Support Banner

OBIA11g: Not Getting Expected Data Of Field NET_ACCRUAL_DURN_BAL For Few Employees In W_ACCRUAL_XACT_FS_TMP (Doc ID 2629616.1)

Last updated on JANUARY 30, 2020

Applies to:

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

Symptoms

On : 11.1.1.9.2 version, DataWarehouse

Not getting expected data of field NET_ACCRUAL_DURN_BAL for few employees in w_accrual_xact_fs_tmp

BI Apps Version:11.1.1.9.2
ODI Version(if customer is using OBIA 11g):11.1.1.7
Source System and Its version:EBS R12.2
Modules That Are Implemented: HR

It has been observed the unexpected results for two employees with  ACCRUAL_BALANCE_DURN_HRS and this is happening only if  perform Incremental load.

The same ACCRUAL_BALANCE_DURN_HRS are populating with expected results in DWH if  do full load but with the incremental load observed unexpected results.


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!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.