PCM_OP_SUBSCRIPTION_GET_PURCHASED_OFFERINGS Taking Very Long Time For Accounts Having More Products (Doc ID 1351748.1)

Last updated on SEPTEMBER 19, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.3.1.0.0 to 7.3.1.0.0 [Release 7.3.1]
Information in this document applies to any platform.

Symptoms

The opcode PCM_OP_SUBSCRIPTION_GET_PURCHASED_OFFERINGS is taking a very long time (say 15 minutes) for an account having 48857 products and its linearly increasing with the increase in number of products.

As a consequence, new orders (MODIFY_CUSTOMER),  cancel product, and cancel service (CUST_SET_STATUS,SUBSCRIPTION_CANCEL_PRODUCT) are taking long time and resulting in timed out errors in integration with Oracle AIA.

Since there are repeated calls to SUBSCRIPTION_GET_PURCHASED_OFFERINGS in above mentioned opcodes, these orders are taking more than 1 hour which is very poor performance.

Below is the "opstack" for one such call:

Seconds Type Opcode (flags, notes)
0.000000000 Enter PCM_OP_SUBSCRIPTION_GET_PURCHASED_OFFERINGS (0x0)
0.002055015 .Enter PCM_OP_SEARCH (0x40400)
51.317655119 .Exit PCM_OP_SEARCH (0x40400) - from DM 0.0.0.1
128.563187377 .Enter PCM_OP_SEARCH (0x40400)
137.102192500 .Exit PCM_OP_SEARCH (0x40400) - from DM 0.0.0.1
624.150722089 Exit PCM_OP_SUBSCRIPTION_GET_PURCHASED_OFFERINGS (0x0)

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