Conversion Line Accounts For Which Open Ctd Balance Equal To The Paid Balance Do Not Move To Itables (Doc ID 2823948.1)

Last updated on NOVEMBER 26, 2021

Applies to:

Symptoms

ACTUAL BEHAVIOR
---------------
Conversion Line accounts for which open ctd balance equal to the paid balance do not move to itables

During conversion of line accounts, account balances are supplied in the file api_abl_112.dat. Here, the accounts that have open ctd balance (ABL_BAL_OPEN_CTD) equal to the paid balance (ABL_BAL_PD_CTD), end up in a situation where these balances do not move to the itables (iaccount_balances table). This is because of a condition in package ACCDRV_EL_112_02.DRV_ACC_DTLS (Line 383) where ACC_BAL_OPEN_CTD is checked against ABL_BAL_PD_CTD, and ONLY IF it is greater, do the balances get assigned to the appropriate itable columns.

This leads to edit XVL_ACC_DUE_AMT_PD_2_ABL_PD being wrongly raised for a lot of records where the balances are actually perfectly fine in the file, but not in the itables. Typically, only one of the balances types (ADV) will have correct ABL_VAL_PD in the itables while for the other, for which the open balance is equal to the paid balance, (INT), the balance will come as 0 even though it has been supplied in the file.

EXPECTED BEHAVIOR
-----------------------
Application should have code to move the balance in itables (iaccount_balances table) when the ctd balance (ABL_BAL_OPEN_CTD) equal to the paid balance (ABL_BAL_PD_CTD). So that the edit XVL_ACC_DUE_AMT_PD_2_ABL_PD will not throw wrongly.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Load the api_abl_112_file_data.dat file with the account opening balance ctd and account paid balance ctd.with amount equal fo both columns.
2. Execute the conversion process to move the line accounts to the itables.(API to Itables).
3. Verify the itables(iaccount_balances table) open ctd balance (ABL_BAL_OPEN_CTD) amd paid balance (ABL_BAL_PD_CTD) got moved successfully when the values are equal. Current code does not have condition check if both are equal so doesn't move the values.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot have open ctd balance (ABL_BAL_OPEN_CTD) and paid balance (ABL_BAL_PD_CTD) moved to iTables if values are equal in the source.

Cause

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