OBIA 11g Performance Issue With SILOS_SIL_GLCOGSFACT_DIFFMANLOAD

(Doc ID 1915716.1)

Last updated on JULY 09, 2017

Applies to:

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

Symptoms

Product Version: 11.1.1.8.1
ETL Tool: ODI
Source system: Peoplesoft 9.0
Database: 11G

ACTUAL BEHAVIOR

You are implementing Financial Analytics & Procurement and Spend Analytics 11.1.1.8.1. SILOS_SIL_GLCOGSFACT_DIFFMANLOAD mapping is taking a longer time to complete than expected. It took close to 250 minutes and processed 6.8 million records.
Other mappings have processed same amount of data and completed within 60 - 70 minutes


EXPECTED BEHAVIOR

ETL is expected to take less time


Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms