My Oracle Support Banner

Repayment schedule indicator APC_SYSTEM_GENERATED_IND not reflecting the value passed during migration. Always displays N constant (Doc ID 2707259.1)

Last updated on SEPTEMBER 03, 2020

Applies to:

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

Symptoms

ACTUAL BEHAVIOR
---------------

While migrating account through API process, api_account_repmt_schedule table has APC_SYSTEM_GENERATED_IND = Y . But, Iapplication_repmt_schedule table has APC_SYSTEM_GENERATED_IND = N.

Account Repayment Schedule Indicator.

EXPECTED BEHAVIOR
-----------------------

APC_SYSTEM_GENERATED_IND should retain the value that is passed during migration.

STEPS:
-----------

1. Prepare migration file(.dat) with an account to be migrated with APC_SYSTEM_GENERATED_IND as Y. Place the file in folder e.g. /scratch/ofsll_home/<env>/tmp/conversion/loan/
2. Execute the batch Process(ACCDMP_BJ_100_01) for migration. Check APC_SYSTEM_GENERATED_IND column in API_ACCOUNT_REPMT_SCHEDULE table.
3. Check  the account in API_ACCOUNT_REPMT_SCHEDULE.  Check APC_SYSTEM_GENERATED_IND column and the value is as is API table. Complete the rest of the Mirgation process(ACCVAL_BJ_111_01,ACCAAI_BJ_100_01)
4. Check the Account repayment schedule generated indicator in the  Contract information -> Repayment -> Repayment schedule block -> Account details

BUSINESS IMPACT
-----------------------
The issue has the following business impact:

Due to this issue, users could not generate the account repayment schedule post migration.

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


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