FCIS - DB Server Time Is Loogged In STTB_JOB_EVEN_LOG Instead Of Local Client Time.
(Doc ID 2597631.1)
Last updated on OCTOBER 21, 2021
Applies to:Oracle FLEXCUBE Investor Servicing - Version 184.108.40.206.0 and later
Information in this document applies to any platform.
On : 220.127.116.11.0 version, Implementation Support
When the Data Base server in different time zone (eg: Hong Kong) and Application is running for different time zone (eg: UK) then when executing any Scheduler JOB's, post completion of jobs the table STTB_JOB_EVENT_LOG field DATETIMESTAMP should be updated with Application (UK) Time zone and NOT Server (HK) Time zone.
Application time zone Date and Time should be updated in STTB_JOB_EVENT_LOG field DATETIMESTAMP and NOT Server time zone date and time.
STEPS TO REPRODUCE:
The issue can be reproduced at will with the following steps:
1. Data Base Server Time Zone and Application Time Zone should be different.
2. UTDJOB - Maintain the scheduler Job.
3. Execute the maintained Job.
4. Check the table STTB_JOB_EVEN_LOG field DATETIMESTAMP, the value is updated with Data Base Server date and timestamp.
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