Collections Center Performance Issue: PCM_OP_COLLECTIONS_GET_SCENARIO_DETAIL
Last updated on APRIL 25, 2016
Applies to:Oracle Communications Billing and Revenue Management - Version 220.127.116.11.0 to 18.104.22.168.0 [Release 7.5.0]
Information in this document applies to any platform.
On : 22.214.171.124.0 version, Collections Manager
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.
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