PCM_OP_PRICE_COMMIT_DISCOUNT Opcode Performance Issue
(Doc ID 2772351.1)
Last updated on APRIL 28, 2021
Applies to:Oracle Communications Billing and Revenue Management - Version 126.96.36.199.0 and later
Information in this document applies to any platform.
- In a customer implementation, PCM_OP_PRICE_COMMIT_DISCOUNT opcode is used to create /discount objects during order processing (account creation).
- A performance issue is encountered while processing the order wherein, it took about 316 secs (8 calls of PCM_OP_PRICE_COMMIT_DISCOUNT internally) in one order processing.
- After enabling "enable_pcm_op_call_stack" and investigating, it was found that PCM_OP_PRICE_COMMIT_DISCOUNT opcode is taking about 38 seconds for one opcode execution.
How to address the performance issue of this opcode, given that in the above testing environment, there are about 100000 total discount objects in the database.
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