ZRGOD01S:AUDIT_DATUM_CRE AND AUDIT_ID_CRE IN DWH PRICE ELEMENTS WRONGLY ADJUSTED (Doc ID 2073187.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

On production: 10.15.1.2 version, Dimension
M-4290

ACTUAL BEHAVIOR
---------------
audit_datum_cre and audit_id_cre in dwh price elements are wrongly adjusted.

Since release 10.15.1.2 the audit_datum_cre and audit_id_cre are overwritten if the record already existed.
However these should keep the original creation date and laadrun ID.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run ZRGOD01S and check dwh price elements

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Datawarehouse history is not traceable.

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