OHI Patchset 10.15.1.2: Script DWH_X2749_01.sql Removes too Many Debit Records (Doc ID 2081642.1)

Last updated on MARCH 09, 2017

Applies to:

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

Symptoms

On : 10.15.1.3 version, Installation

ACTUAL BEHAVIOR
---------------
When implementing 10.15.1.3 script DWH_X2749_01.sql is executed which removes incorrect debit records from dwh_declaraties.. However, this script delete too much debit records, including original claim lines.

EXPECTED BEHAVIOR
-----------------------
Script DWH_X2749_01.sql only deletes the incorrect debit records from dwh_declaraties.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Install 10.15.1.3


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Incorrect external and internal reports.

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