FCIS - Incorrect Time Updated In Maker_Dt_Stamp And MsgUploadDateTime In SWIFT Incoming Message Table when server time zone and application time zone are different.
(Doc ID 2589469.1)
Last updated on SEPTEMBER 24, 2019
Applies to:Oracle FLEXCUBE Investor Servicing - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
On FCIS : 18.104.22.168.0 version, Implementation Support
When Server Time zone is different from Module time zone then the audit field date value of Branch_Date and checker_dt_stamp are incorrectly populated with Data Base Server Time Zone in MSTB_DLY_MSG_IN table.
When Server Time zone is different then Module time zone then the audit field date value of Branch_Date and checker_dt_stamp should get populated with Module Timezone Time in MSTB_DLY_MSG_IN table.
The issue can be reproduced at will with the following steps:
1.Maintain Server Time Zone as Hong Kong Time zone
2.Maintain Time Zone say UKT in FCIS application.
3.Map the Time-Zone UKT for both FMG and AGY module.
4.Capture a SWIFT Transaction setr.010.001.04 SubscriptionOrderV04.
5.Post Capturing of Transaction it is found that Maker_Dt_Stamp and MsgUploadDateTime is updated as Module-Time in mstb_dly_msg_in (correct).
6. Whereas Branch_Date and checker_dt_stamp is update as server time, however it should be saved with correct Module-Time.
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