MM: Interest Rate Rounding Off issue In MMDTRONL (Doc ID 2885372.1)

Last updated on JULY 29, 2022

Applies to:

Symptoms

On : 14.5.0.0.0 version,

ACTUAL BEHAVIOR
---------------
Interest Rate rounding off in MMDTRONL

For MM contracts requiring confirmation matching (as per Product setup), during Contract input system stores the details in MMTB_CONTRACT_MM tables. However, the Interest rate (tag 37G) is rounded off to nearest decimals and stored in the INTEREST_RATE column e.g. 0.8% mentioned at MM contract level is stored as 1% in above tables.

This leads to PARTIAL MATCH of the contract.

EXPECTED BEHAVIOR
-----------------------
Rate should not be rounded off. It should be same as what user has entered.
MM confirmation match should have FULL match instead of PARTIAL match

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Input a new MM contract using Product MMPL. Mention the interest rate as 7.35%
2. Save and authorize this contract.
3. Go to MMTB_CONTRACT_MM and check INTEREST_RATE column, the rate will be shown as 7% instead of 7.35%

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, contracts are getting partially matched instead of full match.

Changes

Cause

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