My Oracle Support Banner

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 JUNE 30, 2020

Applies to:

Oracle FLEXCUBE Universal Banking - Version 11.3 and later
Information in this document applies to any platform.

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

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
Symptoms
Changes
Cause
Solution
References


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