Performance Issue On Pcm_op_subscription_transfer_subscription (Doc ID 1323794.1)

Last updated on DECEMBER 22, 2014

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.3.0.0.0 to 7.3.0.0.0 [Release 7.3.0]
Information in this document applies to any platform.
Checked for relevance on 25-Jun-2013.

Symptoms


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 subsciption and products
2) Create one Account B as children account of account A without any subscribtion
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

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