My Oracle Support Banner

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

Last updated on NOVEMBER 25, 2019

Applies to:

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


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.


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.