PCM_OP_PRICE_COMMIT_DISCOUNT Opcode Performance Issue
(Doc ID 2772351.1)
Last updated on MARCH 22, 2023
Applies to:
Oracle Communications Billing and Revenue Management - Version 7.5.0.22.0 and laterInformation in this document applies to any platform.
Symptoms
Scenario:
- 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.
Changes
Cause
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
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |