Auditing Functionality not Working for CI_PRICEASGN Table (Doc ID 2191649.1)

Last updated on OCTOBER 14, 2016

Applies to:

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

Symptoms

On RMB v2.5.0.1.0 version against FW 4.3.0.1.0:

Auditing functionality not working for CI_PRICEASGN Table just after configuring auditing details over table CI_PRICEASGN with Framework Audit Program CIPZADTA.

When User clicks to save pricing from effective pricing portal, Web portal is getting refreshed. After opening the same entry in effective pricing portal, it is found that updates are not getting saved.
Ideally the updated pricing should be getting saved to the system.

ERROR
-----------------------
Error in the backend :
Caused by: com.splwg.base.api.program.types.MathOverflowException: Numeric Overflow: 1073741824. Can't write to Numeric Field: NumberFieldMD (
      name=FldLength
      primaryName=FLD-LENGTH
      index=1
      byteRange=[30,34] size=5
      precision=5
      scale=0
      signed=false
      ).

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Pre-requisite:
- Auditing must be enabled on CI_PRICEASGN table
- Some fields switches could be checked for Audit delete/insert/update
2. In UI, go to effective pricing screen:
i. Manage Pricelist
ii. Manage Product Assignments to Price Lists
iii. Edit one of the highlighted products
3. Change Trade Cap (Sequence No. 30) Value
4. Click to Save. Screen got refreshed and main login screen prompted
5. Verify pricing changes made on step 3 and note that Rate remained as it is, change was not updated

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, business is not able to log the auditing over one of the important table (i.e. CI_PRICEASGN) of implementation.

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms