My Oracle Support Banner

MDM Standard Screen "use Transaction Inquiry" Behavior Is Abnormal. (Doc ID 2721060.1)

Last updated on OCTOBER 19, 2020

Applies to:

Oracle Utilities Meter Data Management - Version 2.3.0.2.0 and later
Information in this document applies to any platform.

Symptoms

MDM standard screen "use transaction inquiry" behavior is abnormal.

Phenomenon:
By selecting "Use transaction ID" as the search criterion in the "Use transaction inquiry" standard screen of MDM, entering the ID in the use transaction ID, and clicking the search button, it seems that the data that is existing in the D1_USAGE table originally can not be searched from screen .

When investigating, the behavior of the standard ZONE "D1-UTNQ3" appears to be abnormal .
In table D1_US_TYPE, a column named "US_CLASS_FLG" was added accompanying with VUP and the value does not seem to be registered, but US_CLASS_FLG = "D1US" appears in that ZONE SQL.

What should user do when using this standard screen? 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.