Collections Center Performance Issue with PCM_OP_COLLECTIONS_GET_SCENARIO_DETAIL
(Doc ID 2125469.1)
Last updated on MARCH 16, 2019
Applies to:Oracle Communications Billing and Revenue Management - Version 18.104.22.168.0 to 22.214.171.124.0 [Release 7.5.0]
Information in this document applies to any platform.
The Collections opcode PCM_OP_COLLECTIONS_GET_SCENAIRO_DETAIL 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 turns 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.
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