ACC_IN_PROMOTION_IND is updated with Y even if ACC_IN_PROMOTION_IND is passed as N in the migration when APP_PROM_PERIOD_TYPE_CD = UNDEFINED (Doc ID 2700031.1)

Last updated on AUGUST 12, 2020

Applies to:

Symptoms

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

ACC_IN_PROMOTION_IND is N in iaccounts but Y in accounts table. System always migrates the account with ACC_IN_PROMOTION_IND = Y
 

EXPECTED BEHAVIOR
-----------------------
System should migrate the loans with promotion indicator as 'N'

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Selected an account with ACC_IN_PROMOTION_IND = N
2. Migrate the account with ACC_IN_PROMOTION_IND = N 
3. Verify the IACCOUNTS table, ACC_IN_PROMOTION_IND is migrated as N.
4. Complete the migration process and verify the ACCOUNTS table,ACC_IN_PROMOTION_IND remains N.
5. system should not update ACC_IN_PROMOTION_IND with default value Y

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

Due to this issue, accounts are getting created with incorrect promotion code that impact the loan/line/Lease process

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.