Migration Field ACC_SUBUNIT_CD Value Not Updated Into Servicing ACCOUNTS Table During Migration (Doc ID 3066318.1)

Last updated on JANUARY 06, 2025

Applies to:

Symptoms

ACTUAL BEHAVIOR
---------------
Field ACC_SUBUNIT_CD Value Not Updated to ACCOUNTS Table as part of account Migration 

ACC_SUBUNIT_CD is exposed as a field in migration accounts file, api_acc_111.dat. These same value flows perfectly till iaccounts table in migration. However, there is another field APP_SUBUNIT_CD defined in iapplications, which is not exposed in migration contracts file, and is instead taken from PORTFOLIO_COMPANY_BRANCHES setup. Same flows into the accounts table also. Finally, the ACC_SUBUNIT_CD field is not updated into the accounts table in the ACCAAI_EN_111_02.UPDATE_ACCOUNT procedure that updates accounts table with iaccounts data.

This leads to a scenario where customer is passing subunit in api_acc_111.dat but the value in accounts table is always coming from portfolio company/branch setup. Ideally this field is exposed in migration file, it should flow to accounts if provided.

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.