OBIA 11G: Performance Review Status Domain Extract Task Missing (Doc ID 2017320.1)

Last updated on JANUARY 30, 2017

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.7.0 to 11.1.1.9.2 [Release 11g]
Information in this document applies to any platform.

Symptoms

BIAPPS 11.1.1.7.1
Source Adapter : Peoplesoft 9.2

Implementing HR analytics with ODI 11g as the data integration tool.  You have to populate performance data in OBI reports. When you checked the domain values for performance to configure, you can see "performance doc type ~ performance template", "performance rating" and "Performance Review status" domain values.

The first two domain members have been mapped. But, you can't see any Performance Review Status values in the source. The domain code is "PERFORMANCE_REVIEW_STATUS". For this domain you are unable to view any scenario in the domain load plan.

As per OOTB interface logic for W_PSFT_WEVT_PERF_PS, the query is picking no data as there is a WHERE condition seeking values from the above domain code.

How is the PERFORMANCE_REVIEW_STATUS domain getting populated, currently the Domain members are not populated for the PERFORMANCE_REVIEW_STATUS domain.

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