My Oracle Support Banner

MSDCACAD Function ID Has Unauthorized Records (Doc ID 2589490.1)

Last updated on SEPTEMBER 26, 2019

Applies to:

Oracle FLEXCUBE Universal Banking - Version 12.0.2 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
---------------
MSDCACAD Function ID has unauthorized records under certain workflow adopted by user.

EXPECTED BEHAVIOR
-----------------------
System should not leave the records unauthorized in sttb_record_log

STEPS
-----------------------
Issue can be simulated with the following steps:-

1) Take any customer account.
2) Visit "MSDCACAD" to change customer account address and save
3) A different user then unlocks the Customer account record from STDCUSAC screen and modifies the record, saves and authorizes the same
4) The latest modification from STDCUSAC will be propagated to mstm_cust_acc_address
6) Therefore, mstm_cust_acc_address will show the record as authorised but unauthorised record from MSDCACAD will remain in sttb_record_log


This results in mismatch in Modification number and Authorization status between Audit and Address tables

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
Cause
Solution
References


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