Discrepancy in COLLECTIONS_SCENARIO_T Table Columns Data Structure
(Doc ID 1592896.1)
Last updated on MARCH 26, 2019
Applies to:Oracle Communications Billing and Revenue Management - Version 18.104.22.168.0 to 22.214.171.124.0 [Release 7.5.0]
Information in this document applies to any platform.
Consider integration scenario between Siebel and BRM using AIA (AABC ODI PIP 11.2) :
We know that ODI is used by AIA to gather Collections data from collections_scenario_t. It has been observed that the value in amount ($100.20 in BRM for example) gets transformed as rounded value ($100 in ODI and Siebel) hence causing a financial impact for the client.
As per ODI working design, the behavior is expected (when it’s a DB-to-DB conversion) when the column data type is just NUMBER rather than NUMBER-with a precision.
It is seen that there are three columns in table collections_scenario_t, viz.,
..defined as NUMBER without precision and scale, while many other fields have a precision. If the said columns are defined as NUMBER-with a precision (NUMBER(38) for example), then the issue would not surface.
What is the solution to this issue ?
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