OBIA 11g - Data Load Missing Load Plan Steps
Last updated on JUNE 04, 2018
Applies to:Business Intelligence Applications Consumer - Version 184.108.40.206.1 and later
Information in this document applies to any platform.
OBIA Version: 220.127.116.11.1 and 18.104.22.168.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).
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