My Oracle Support Banner

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

Last updated on FEBRUARY 03, 2019

Applies to:

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


OBIA Version: and
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).


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.