My Oracle Support Banner

System Fails when posting Backdated INS_Cancel transaction due to existing Adv Adj Minus - Negative Balance (Doc ID 2669849.1)

Last updated on MAY 13, 2020

Applies to:

Oracle Financial Services Lending and Leasing - Version and later
Information in this document applies to any platform.


System fails with an error when posting rebate for an ancillary product (ins_cancel).

When the ins_cancel transaction is backdated, existing adjustment transaction will get reversed and re posted. Since the amount of principal is reduced, system is failing with error. Adjustment Amount > outstanding principal amount - Insurance rebate.

This issue was reported earlier for which solution was provided (flag Yes/No to select when posting an adjustment transaction). Selecting No will validate the rebate for the loan when posting an adjustment transaction. Also provided a transaction PayPrincipalAdj, to post a payment to generate a credit when adjustments are posted. This flag is for manual posting cannot be used by system while re posting an adjustment that already exist on the account prior to backdating ins cancel.

TXN amount should be less than or equal to(Outstanding principal amount - Rebate)

The issue can be reproduced at will with the following steps:
1. Select an account that has an adjustment transaction and the account is attached to an Ancillary product(Insurance)
2. Post an Insurance Cancel transaction on the account with a back dated date prior to adjustment transaction date.
3. verify whether the insurance cancel transaction posted successfully

The issue has the following business impact:

Due to this issue, users cannot post back dated insurance cancel transaction for an account that has adjustment transaction.




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

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