My Oracle Support Banner

Approval Of Price Assignments-Edit Is Getting Blocked For Users Post Patch 32797641 (Doc ID 2814324.1)

Last updated on OCTOBER 19, 2021

Applies to:

Oracle Financial Services Revenue Management and Billing - Version 2.8.0.0.0 and later
Information in this document applies to any platform.

Symptoms

On RMB v2.8.0.0.0, Approval of Price assignments-Edit is getting blocked

After applying patch # 32797641, reported issue gets resolved. Another User is now able to edit Price assignment even though another price assignment approval transaction from different user is in pending.
However this patch has introduced a new issue which is more critical as Approval of Price assignments-Edit is getting blocked.

On level 2 approval for both approval txns, system has now started throwing Error pop up with a message.
Before applying patch, Edit price assignment approval was working smooth and user was able to proceed with both level approvals without any error.

ERROR
-----------------------
Can't delete Price Assignment (Price Assignment ID ) it is referenced by Billable Charge (Billable Charge ID ).Referential Integrity error
If you need support please supply the following info to system support:
Message number: 11001, 701

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Approval workflow for Price Assignment - ON
2. Search an existing Pricelist having different price assignments
3. Login with User 1 -> Choose one price assignment and edit some details and click 'Submit'
  - System generates Approval transaction ID
4. Keep this Approval transaction as it is i.e. Pending for approval
5. Now Login with User 2 -> Choose any other Price assignment of the same pricelist and edit some details and click 'Submit'
  - System generates Approval transaction ID
6. Login with Apporver ID and try to Approve both these txns
  - Level 1 approval is successful for both trasnsactions and txns got assigned for Level 2 approval
7. Level 2 approval : Select both records one by one and click Approve
  - For both approval, system is throwing error

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
Cause
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.