My Oracle Support Banner

Oracle Storing Currency Amounts Without Decimal Places When Amount Is a Whole Number (Doc ID 2927533.1)

Last updated on FEBRUARY 13, 2023

Applies to:

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

Goal

When making a payment, the input flist has an amount of 100.00 for example, but the return flist and logs are showing the value as 100.

If the payment is 100.01 then the return flist shows the correct decimal places 100.01.

For example:

From testnap:

r << XXX 1
0 PIN_FLD_EVENT_NO STR [0] "IdXXX"
0 PIN_FLD_POID POID [0] 0.0.0.1 /account -1 0
0 PIN_FLD_TRANS_ID STR [0] "TransID1"
0 PIN_FLD_USER_NAME STR [0] "USERNAME"
0 PIN_FLD_PROGRAM_NAME STR [0] "Billing Service"
0 PIN_FLD_CHARGES ARRAY [0] allocated 7, used 7
1     PIN_FLD_ACCOUNT_NO STR [0] "01421647304"
1     PIN_FLD_ACCOUNT_OBJ POID [0] 0.0.0.1 /account 126297745 1
1     PIN_FLD_AMOUNT DECIMAL [0] 100.00
1     PIN_FLD_CHANNEL_ID INT [0] 12
1     PIN_FLD_PAY_TYPE ENUM [0] 10011
XXX
xop 17100 0 1

In the cm.pinlog

     op_pymt_collect input flist
# number of field entries allocated 20, used 3
0 PIN_FLD_PROGRAM_NAME STR [0] "Billing Service"
0 PIN_FLD_CHARGES ARRAY [0] allocated 20, used 7
1     PIN_FLD_ACCOUNT_OBJ POID [0] 0.0.0.1 /account 126297745 1
1     PIN_FLD_AMOUNT DECIMAL [0] 100 
1     PIN_FLD_PAY_TYPE ENUM [0] 10011
1     PIN_FLD_CHANNEL_ID INT [0] 12
1     PIN_FLD_COMMAND ENUM [0] 0
1     PIN_FLD_PAYMENT SUBSTRUCT [0] allocated 20, used 1
2         PIN_FLD_INHERITED_INFO SUBSTRUCT [0] allocated 20, used 1
3             PIN_FLD_CASH_INFO ARRAY [0] allocated 20, used 2
4                 PIN_FLD_RECEIPT_NO STR [0] ""
4                 PIN_FLD_LOCATION STR [0] "Location"
1     PIN_FLD_CURRENCY INT [0] 124
0 PIN_FLD_POID POID [0] 0.0.0.1 /account 126297745 1

 

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


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