BRM Order Processing Performance Issue (Doc ID 3071003.1)

Last updated on FEBRUARY 12, 2025

Applies to:

Symptoms

We are currently facing following issues related to Order Processing in Billing and Revenue Management(BRM).
1. Order Processing in BRM is failing due to reaching memory threshold of 4 GB. As CM is 32 bit, it is not able to use memory beyond 4 GB. Order Management custom opcode is taking long time to process and finally failing due to reaching 4+ GB of memory.

2. BRM Web Service is taking long time to process large payloads. web service is failing with time out, increased timeout to around 18 mins which solved some problem but as payload size grown it started failing again. Looking for a solution to this problem.

Analysis:
Based on some analysis and seems like PCM_OP_PRICE_GET_PRODUCT_INFO is causing memory issue, when we are running our custom code without this opcode, memory is being released properly and memory is not going beyond 1 gb. Average time taken by PCM_OP_PRICE_GET_PRODUCT_INFO is around between 15-20 seconds and this is one specific SQL is taking most of the time.


ACTUAL BEHAVIOR
---------------
PCM_OP_PRICE_GET_PRODUCT_INFO taking long time to return the results

Observing performance issue during Order processing while getting the pricing information using OOB opcode PCM_OP_PRICE_GET_PRODUCT_INFO. In a Production like environment where nothing was running in parallel it took almost 14 seconds to return the results.

EXPECTED BEHAVIOR:
---------------
The execution of PCM_OP_PRICE_GET_PRODUCT_INFO should not take long time to return the results when there are no parallel operations.

Cause

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