OBIA: 11.1.1.8.1 - EBS 12.1.2 - HR - W_EMPLOYEE_D Presentation Of Addresses Information (Doc ID 1966604.1)

Last updated on SEPTEMBER 27, 2016

Applies to:

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

Goal

Question 1

In order to get the address types through then the interface "SDE_ORA_EmployeeDimension.W_EMPLOYEE_DS" and it's lookup on W_ORA_EMPLOYEE_D_ADDRESSES_TMP would need to change from...

'H'' = LKP_ADDRESSES_DEFAULT.ADDRESS_TYPE
to...
'PHCS'' = LKP_ADDRESSES_DEFAULT.ADDRESS_TYPE
this would be an ODI code change, unless the Customer has changed/customized EBS I was wondering if this should be parameter in the functional config. So it seems it would be a code change?

Question 2

There are no presentation columns in the RPD that reference W_EMPLOYEE_D address attributes. Should the RPD contain address attributes in the presentation layer?
I understand it's possible to put the address information into the layers of the RPD but I was wondering if it was absent by mistake. Should there be enhancement request for this on 11.1.1.8.1 on this?

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