My Oracle Support Banner

Mandatory Patch On Top Of BRM 7.5 MPS1 Only (Doc ID 2293944.1)

Last updated on MARCH 10, 2021

Applies to:

Oracle Communications Billing and Revenue Management - Version to [Release 7.5.0]
Information in this document applies to any platform.


Introducing a mandatory patch with an improved version of update_bill_closed_t.source which was known to cause performance issue.

On BRM 7.5, while upgrading from previous patch Sets ( e.g: PS1, ... PS9, PS10, PS11, PS12) to Maintenance Patch Set 1 (7.5MPS1), upgrade script "" might have performance issue - like taking a large amount of time when bill_t table has bulk data.update_bill_closed_t.source : This script will create the closed_t column in the bill_t table and also update the data.


<Patch 26266362> is release to fix this issue. This patch is meant to be installed on Oracle Communications Billing and Revenue Management  Release 7.5.0 RTW + MPS1 (21513185)


1. If customer is coming to 7.5MPS1 from previous patchsets, we recommend them to install this mandatory patch_32_opt.bin and before running the upgrade DB script "".

2. After 75MPS1 upgrade , if customer has plans to upgrade to further patchsets (75PS14, PS15, PS16, PS17 and PS18) then customer need not run the file "update_bill_closed_t.source" while upgrading, as this has been taken care during MPS1+mandatory patch upgrade. It is recommended for customers to skip running the file "update_bill_closed_t.source" by commenting below line in the script .


3. In 75PS19, will make OOB changes to remove the script from upgrade framework.


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

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