OBIA 11g: Interface to Load W_PSFT_WEVT_PS is not Generated into SDE, SIL and PLP Load Plan (Doc ID 2070878.1)

Last updated on JULY 17, 2017

Applies to:

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

Symptoms

After completing the configurations for a new HR Analytics deployment into a DEV environment, creating the Domain Only Load Plan (SDE, SIL and PLP) and then after removing three modules from the HR out of box offerings (Learning, Talent and Recruitment) generating and executing it. The Workforce related dimension and fact tables are not getting populated.

The Peoplesoft Workforce persisted staging tables are populated as follows:

Persisted Table Name           Row Count
------------------------------ -------------
W_PSFT_WEVT_AGE_PS             69511
W_PSFT_WEVT_JOB_PS             279605
W_PSFT_WEVT_PERF_PS            20253
W_PSFT_WEVT_PS                 0


Investigating further reveals that the following scenario did not get into the Load Plan: scenario SDE_PSFT_91_ADAPTOR_SDE_PSFT_PERSISTEDSTAGE_WORKFORCEEVENT

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