PCM_OP_SUBSCRIPTION_GET_PURCHASED_OFFERINGS Taking Very Long Time For Accounts Having More Products
Last updated on SEPTEMBER 19, 2016
Applies to:Oracle Communications Billing and Revenue Management - Version 18.104.22.168.0 to 22.214.171.124.0 [Release 7.3.1]
Information in this document applies to any platform.
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:
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)
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms