OHI DM: New Preferred Bank Account Number is not Loaded (Doc ID 2104343.1)

Last updated on MARCH 09, 2017

Applies to:

Oracle Health Insurance Policy Administration Data Marts - Version 10.15.1.3 and later
Information in this document applies to any platform.

Symptoms

Description:
In DWH the new preferred bank account number is not recorded. Only the old preferred bank account number is visible.

ENVIRONMENT (part 3)
-----------------------
Production

ERROR
-----------------------
A relation got a new preferred bank account number on 23-07-2015. However, in DWH the new preferred bank account number is not recorded. Only the old preferred bank account number is visible.

EXPECTED BEHAVIOR (part 8)
-----------------------
The new preferred bank account number is visible in DWH.

STEPS (part 9)
-----------------------
The issue can be reproduced at will with the following steps:
Add a bank account number for a rleation and make this the preferred bank account numer.
Run BI load

BUSINESS IMPACT (part 6)
-----------------------
The issue has the following business impact:
In DWH the wrong situation is reflected.

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