My Oracle Support Banner

Not Able To Pull Up The Usage Transaction In UI. (Doc ID 1921070.1)

Last updated on MARCH 25, 2019

Applies to:

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


**Examples provided in this article do not represent real life personal/confidential information**

**Disclaimer:** This KM article may include the following abbreviations:

MDM - Oracle Utilities Meter Data Management
UT - Usage Transaction
UI - User Interface
BO - Business Object
SQ - Service Quantity
XSL - eXtensible Stylesheet Language

Customer having trouble opening the Usage Transaction in the User Interface in its entirety. This behavior is seen for some of the UTs that are assigned to a specific Usage Group <GROUP NAME>, that usually has ~60 service quantities. MDM is run clustered environment  which as 4 application servers. Sometimes the UT is opened in MDM on one application server but not in others.

Customer tested this in 3 environments (DEV1, QA, PROD). The behavior or pulling up the UT in the user interface across these three environments in very inconsistent. As mentioned in the description, MDM (prod) is run on clustered environment with 4 application servers.

It is not reliably reproducible with the same UT.

This problem is happening in PROD and QA environments, but does not happen in Dev. There are technical differences, that are most likely causing the problem, since they are working against the same data - but I don't know what could cause this issue.

What the customer tested: HPS UT and Non-HPS UT -- HPS is a UT that uses a HPS type of usage group, that normally results in 70+ service quantities.
NON-HPS generate fewer service quantities and simpler compared to the HPS ones. The main issue is with the HPS ones. They mostly need to be approved
to send the service quantities to billing engine, but as the UI is not opening up completely, that operation could not be performed.

The customer tried running the query that pulls the information populating that UI on the DB, it returns back fine, no issues.

Environment: Production
MDM Version:
DB Version:
PROD/QA are setup as clustered environment.
Testing HPS: None open up (Does not work)
Testing Non-HPS: All open up (Works)

Environment: DEV1
MDM Version:
DB Version:
DEV1 application is standalone
Testing HPS: All open up (Works)
Testing Non-HPS: All open up (Works)

Usage Transaction cannot be approved as they are not opened in the UI in the entirety.




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

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