My Oracle Support Banner

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.

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

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.