OBIA 7.9.6.4 Issues with Patch: 17840620 W_EMPLOYEE_D ADDRESS IS NOT UPDATED INCREMENTALLY missing XML file (Doc ID 1947122.1)

Last updated on JANUARY 31, 2017

Applies to:

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

Symptoms

A user manually changed the value for PER_ADDRESSES.EMPLOYEE_ADDRESS_TYPE. When the next incremental DAC run completed, you noticed that the change to the employee address type column did not get loaded into the W_EMPLOYEE_D dimension table. Having inspected the source database, you determined that the PER_ADDRESSES table had a correct last updated value. There is a problem with the out of the box mapping that retrieves data for employee informations where it is not picking up changes to associated tables.

Applied <Patch: 17840620> FP DAC: BUG 14367742 - W_EMPLOYEE_D ADDRESS IS NOT UPDATED INCREMENTALLY WITH NE
The word document in the patch mentions for you to import an XML file but no XML file was in included in the patch.

Cause

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