GL Performance Issue In BRM Production Database (Doc ID 1986594.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.5.0.0.0 to 7.5.0.0.0 [Release 7.5.0]
Information in this document applies to any platform.

Goal

Problem Summary
---------------------------------------------------
Performance issue in BRM Production database

Running product EBS GL- Oracle Communications Billing and Revenue Management .

GL job query (sqlid 8bnz2kxy6ybza) took long time (~3 hrs) to complete on Feb4.

Most of the days it gets completed within 1 hr. We would like to know the root cause and how can we avoid the same in future?
 
 

Solution

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