Performance Issue On PCM_OP_SUBSCRIPTION_TRANSFER_SUBSCRIPTION
(Doc ID 1323794.1)
Last updated on FEBRUARY 26, 2019
Applies to:
Oracle Communications Billing and Revenue Management - Version 7.3.0.0.0 to 7.4.0.0.0 [Release 7.3.0 to 7.4.0]Information in this document applies to any platform.
Symptoms
On all versions of Oracle Communications Billing and Revenue Management before 7.4.0, the opcode PCM_OP_SUBSCRIPTION_TRANSFER_SUBSCRIPTION (used to transfer one service from an account to another account) is too slow (20 sec).
Steps to reproduce the problem:
1) Create one Account A with a subscription and products
2) Create one Account B as children account of account A without any subscription
3) Move Subscription from Account A to Account B by using PCM_OP_SUBSCRIPTION_TRANSFER_SUBSCRIPTION opcode.
2) Create one Account B as children account of account A without any subscription
3) Move Subscription from Account A to Account B by using PCM_OP_SUBSCRIPTION_TRANSFER_SUBSCRIPTION opcode.
The process require 20 seconds. How can one reduce the time spent?
Snippet of the log which shows the delay
The time consuming opcodes are PCM_OP_SUBSCRIPTION_GET_PURCHASED_OFFERINGS.
0.004764200 .Enter PCM_OP_SUBSCRIPTION_GET_PURCHASED_OFFERINGS (0x0)
0.004894550 ..Enter PCM_OP_SEARCH (0x40400)
13.199865950 ..Exit PCM_OP_SEARCH (0x40400) - from DM 0.0.0.1
15.826739800 ..Enter PCM_OP_SEARCH (0x40400)
15.832618800 ..Exit PCM_OP_SEARCH (0x40400) - from DM 0.0.0.1
37.694246050 .Exit PCM_OP_SUBSCRIPTION_GET_PURCHASED_OFFERINGS (0x0)
44.699602300 ...Enter PCM_OP_SUBSCRIPTION_GET_PURCHASED_OFFERINGS (0x0)
536.209234200 ...Exit PCM_OP_SUBSCRIPTION_GET_PURCHASED_OFFE
0.004764200 .Enter PCM_OP_SUBSCRIPTION_GET_PURCHASED_OFFERINGS (0x0)
0.004894550 ..Enter PCM_OP_SEARCH (0x40400)
13.199865950 ..Exit PCM_OP_SEARCH (0x40400) - from DM 0.0.0.1
15.826739800 ..Enter PCM_OP_SEARCH (0x40400)
15.832618800 ..Exit PCM_OP_SEARCH (0x40400) - from DM 0.0.0.1
37.694246050 .Exit PCM_OP_SUBSCRIPTION_GET_PURCHASED_OFFERINGS (0x0)
44.699602300 ...Enter PCM_OP_SUBSCRIPTION_GET_PURCHASED_OFFERINGS (0x0)
536.209234200 ...Exit PCM_OP_SUBSCRIPTION_GET_PURCHASED_OFFE
Cause
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
| Symptoms |
| Cause |
| Solution |
| References |