My Oracle Support Banner

ACCOUNT DELETE SCRIPT FAILURE - TXN AMORTIZE RECORDS DELETION NOT HAPPENING (Doc ID 3034984.1)

Last updated on JULY 16, 2024

Applies to:

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

Symptoms

ACTUAL BEHAVIOR
---------------
ACCOUNT DELETE - TXN AMORTIZE RECORDS DELETION NOT HAPPENING

User running a Delete script on voided account and request is failing.
 
EXPECTED BEHAVIOR
-----------------------
System should successfully execute the Delete Account Request.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Open a Lease Account, Run billing, ACR, TAM and GLI batch jobs on appropriate Run date next.
2. GL Transactions for the Account posted in GL Transactions screen.
3. Values populated in TXNS, TXNS_AMORTIZE, GL_TXN and GL_TXN_DETAILS tables.
4. Reverse the Active Transaction.
5. Delete the Account.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot execute the Delete Account Request successfully.

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
Cause
Solution


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