My Oracle Support Banner

PCM_OP_BILL_TRANSITION_PLAN Takes a Long Time to Execute (Doc ID 3034480.1)

Last updated on JULY 18, 2024

Applies to:

Oracle Communications Billing and Revenue Management - Version 12.0.0.5.0 and later
Information in this document applies to any platform.

Goal

PCM_OP_BILL_TRANSITION_PLAN take a lengthy time to perform, creating timeouts. In production contexts, the execution time of the opcode frequently surpasses 20 seconds.

A sample perflib data obtained for the test execution of 100 requests of PCM_OP_BILL_TRANSITION_PLAN on PREPROD environment run in isolation with no other requests or MTAs executed concurrently shows timeouts.

Here are a few issues that have been observed:

  1. Database updates take a lengthy time using PCM_OP_BILL_TRANSITION_PLAN.
  2. The synchronization with ECE for PCM_OP_BILL_TRANSITION_PLAN likewise takes a lengthy time.

On production, execution times consistently surpass 20 seconds and can reach 90 seconds.
 

Solution

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
Goal
Solution
References


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