OBIA 11g - Data Load Missing Load Plan Steps (Doc ID 2206598.1)

Last updated on MARCH 26, 2017

Applies to:

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

Symptoms

OBIA Version: 11.1.1.10.1 and 11.1.1.10.2
PeopleSoft: FMS 9.1, HCM 9.1 and CS 9.0

Offerings: Procurement and Spend and Financial


Configured OBIA according to the configuration guide. Then generated the load plan for Finance focused on General Ledger for example. Noticed that there are 0 rows in W_GL_BALANCE_F table.

When checking the generated load plan, particularly under 3 SDE Fact GLBAL_FG, there is only one scenario, which is SDE_PSFT_STAGE_GLBALANCEFACT_EXTRACT.

Further investigation shows that this scenario only loaded one of the temp tables but not the W_GL_BALANCE_FS, which is the source table expected later to eventually load W_GL_BALANCE_F table.

In this case, going to ODI -> Designer -> Load Plans and Scenarios -> BIAPPS Load Plan -> Load Plan Dev Components -> SDE -> PSFT_9_1 -> 3 SDE Fact GLBAL_FG PSFT_9_1, open it, it shows several other steps.


The missing steps are not in the generated load plan, but do exist in the "template" (System Load Plan).


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