My Oracle Support Banner

OBIA 10.3 PB3 FTS Mappings Running Longer With Merge Statements After Upgrading From OBIA 10.2 (Doc ID 2946102.1)

Last updated on MAY 11, 2023

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.10.3 - PB3 - Patch Bundle 3 and later
Information in this document applies to any platform.

Symptoms

After upgrading OBIA 10.3 PB3 from OBIA 10.2,  facing performance issues with FTS mappings at the "Update Existing Rows" step.

The difference between 10.2 and 10.3 code is that, In 10.2, this step is using "Update" statement and in 10.3, it's been changed to "Merge" statement.

The IKM being used for all these mappings is KM BIAPPS CLOUD Oracle Incremental Update.

Changes

 Upgraded OBIA 10.3 PB3 from OBIA 10.2

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.