My Oracle Support Banner

Incremental Load Of FTS_FUSION_FscmTopModelAM.FinGlInquiryBalancesAM.BalancePVO With Multiple Batch Files Is Failing (Doc ID 2760019.1)

Last updated on JANUARY 24, 2022

Applies to:

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

Symptoms

Incremental load of FTS_FUSION_FscmTopModelAM.FinGlInquiryBalancesAM.BalancePVO with multiple batch files is failing with data loss.

The issue happens in incremental load  when multiple batch files are there it will go for a truncate sds in each fts execution and as a result only the last fts execution data will be present in the sds table which will result in the loss of data.

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.