My Oracle Support Banner

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

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
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.