PIN_LEDGER_REPORT Takes A Long Time To Execute - Performance Issue (Doc ID 1140735.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.3.1.0.0 and later
Linux x86-64
Checked for relevance on 26-Mar-2012
***Checked for relevance on 29-August-2016***


Symptoms

The pin_ledger_report utility shows a performance issue, as it's running below queries and it's doing full scans of item_t and journal_t tables.

 

 

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