ORA-01422 error is thrown while using 2 Formulas ,one formula as Simple(user defined) And another as Amort in the Same Product. (Doc ID 2685615.1)

Last updated on JULY 26, 2021

Applies to:

Symptoms

ACTUAL BEHAVIOR
---------------
Using 2 formulas in user defined: Simple and Amort same product


Bank is trying to use both formulas Simple and Amort on same product by selecting Formula type as User Defined.

they have booked the loan with first 12 schedules as simple formula and next with Amortize formula. As they want to recover profit during this 12 month grace period and after that normal EMI.

System has generated the schedules fine but there is no calculation for first 12 months in comp_calc table.




EXPECTED BEHAVIOR
-----------------------
system should allow both simple and amort on same product.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Use both formulas Simple and Amort on same product by selecting Formula type as User Defined.
2. booked the loan with first 12 schedules as simple formula and next with Amortize formula. As we want to recover profit during this 12 month grace period


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot book the schedules.

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.