Collections Center Performance Issue: PCM_OP_COLLECTIONS_GET_SCENARIO_DETAIL (Doc ID 2125469.1)

Last updated on APRIL 25, 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.

Symptoms

On : 7.5.0.10.0 version, Collections Manager

ACTUAL BEHAVIOR
------------------------

The Collections opcode PCM_OP_COLLECTIONS_GET_SCENAIRO_DETAIL opcode is taking ~70 seconds in production.

This is impacting the following scenarios:

Scenario 1: Opening the collections scenario of a bill unit

In this scenario, Collections Center is calling PCM_OP_COLLECTIONS_GET_SCENARIO_DETAIL opcode which in-turn calling PCM_OP_COLLECTIONS_GET_ACTION_HISTORY opcode for each action. So, it is taking long time around 73 seconds.

Scenario 2: Insert an action from the collections scenario dialogue box

In this scenario, Collections Center is calling PCM_OP_COLLECTIONS_ADD_ACTION opcode which is not taking much time (~0.5 seconds in staging env)
But, after adding the action, in order to refresh the scenario in the GUI, it is calling PCM_OP_COLLECTIONS_GET_SCENARIO_DETAIL opcode, which is taking long time.


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