My Oracle Support Banner

Account Condition Table - Timestamp is getting updated even though the key columns not updated (Doc ID 2835889.1)

Last updated on JANUARY 27, 2022

Applies to:

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

Symptoms

ACTUAL BEHAVIOR
---------------
Last update date is getting stamped/updated every hour as and when SET-QCS runs.

QCS is configured for hourly, ACO_ACC_ASIGN_DATE is getting stamped with the "LAST_UPDATE_DATE" , there is no change to the record for ACO_ASG_CODE or ACO_USR_CODE

EXPECTED BEHAVIOR
-----------------------
When there is no change in the record for ACO_ASG_CODE or ACO_USR_CODE, last updated date and time should not be updated in the table(account_conditions) for ACO_ACC_ASIGN_DATE  

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Execute the batch job under SET-QCS
2. Check the account condition table column ACO_ACC_ASIGN_DATE.
3. Check whether the account condition record is updated for ACO_ASG_CODE or ACO_USR_CODE

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.