My Oracle Support Banner

OBIA 11g: Duplicate Issue In SIL_FIXEDASSETBALANCEFACT (Doc ID 2538718.1)

Last updated on NOVEMBER 28, 2019

Applies to:

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

Symptoms

On Oracle Business Intelligence Applications Consumer (OBIA) 11.1.1.10.2 version, 

 
As per the design, the primary key for this VO (FscmTopModelAM.FinFaDeprDepreciationAM.DepreciationDetailPVO) defined in BICC is on the following 5 columns:

  1. AssetId
  2. BookTypeCode
  3. DistributionId
  4. FaAstHistTransactionHeaderIdIn
  5. PeriodCounter


But the ODI logic in SIL_FIXEDASSETBALANCEFACT uses only the following three columns and Asset ID is not used in ODI.

  1. PERIOD_NAME
  2. DISTRIBUTION_ID
  3. BOOK_TYPE_CODE

Environment Details

  1. BIAPPS version  - OBIA 11.1.1.10.2 
  2. ODI version       - ODI_11.1.1.9.0_GENERIC_150427.0937 
  3. Source Sytem and its version - Oracle cloud FUSION 11  
  4. Modules being used - Financials
  5. Issue during Full Load / Incremental Load - Full load

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!


In this Document
Symptoms
Changes
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.