OBIA 11g- How to use EMPL_CLASS instead of POI_TYPE for EMPLOYEE_CAT_CODE in W_EMPLYMENT_D? (Doc ID 2217925.1)

Last updated on FEBRUARY 06, 2017

Applies to:

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

Goal

In 11.1.1.8.1, EMPLOYEE_CAT_CODE column in W_EMPLYMENT_D is sourced from PeopleSoft_9.1 HCM PS_JOB.POI_TYPE, but in 11.1.1.7.1, it is sourced from PS_JOB.EMPL_CLASS

How to change so that EMPL_CLASS can be used instead of POI_TYPE for EMPLOYEE_CAT_CODE in W_EMPLYMENT_D?

Solution

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