BIApps 11.1.1.7.1 Domains ETL not loading DATA FROM FLEXFIELDS JOB_FAMILY JOB_FUNCTION (Doc ID 1585873.1)

Last updated on MARCH 08, 2017

Applies to:

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

Goal

BIApps 11.1.1.7.1 Domains ETL not loading DATA FROM FLEXFIELDS JOB_FAMILY JOB_FUNCTION

OBIA version: 11.1.1.7.1
Source EBS version: R12.1.3

Customer completed the section B.2.34 How to Retrieve Information Stored in Flexfield Columns in Config Guide and has run Domains ETL load.

However, the domain members are not populated.

Config Guide states "2. Run the Domain only Load plan once to automatically populate the values (52119:SEGMENT1) in source domain (KEY:800:JOB or
DESCRIPTIVE:800:PER_JOBS). Then map these values ("52119:SEGMENT1-> JOB_FAMILY"). Run the Domain only Load plan second time to get the
configuration completed."

As per this section, customer ran Domain Only ETL twice. In the domain mapping for JOB_FAMILY, JOB_FUNCTION, they see that no rows have been
populated after running the second domain load. Do these get populated in actual load plan?
 

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