My Oracle Support Banner

Date Stamps and eScript (Doc ID 509653.1)

Last updated on APRIL 30, 2018

Applies to:

Siebel Tools - Version 7.5.3.5 SIA [16183] and later
z*OBSOLETE: Microsoft Windows 2000
Product Release: V7 (Professional)
Version: 7.5.3.5 [16183]
Database: Oracle 9.2.0.4
""Checked for Relevance on 22-JUL-2016""
Application Server OS: Microsoft Windows 2000 Server SP 4
Database Server OS: IBM AIX 5L 5.1

This document was previously published as Siebel SR 38-1959018141.

"Checked for relevance on 02-Feb-2015"

Symptoms

We have some functionality that is heavily dependent on timestamps. The process involves creating activity records, which we call CMDT requests. The process uses a customized bus comp based on the Action bus comp. When the user is ready for their request to be processed, they click on a 'Submit' button. There is eScript behind this button that does some validation and, if everything is OK, set the submitted data to the current date and time. When I look at the list applet in the gui that contains the Created field (vanilla) and the Submitted field (custom extension column), they are off by an hour. For example:
     my PC time:     7:56:00 a.m
     created:        12:47:56 p.m.
     submitted:      11:49:09 a.m.

I also have a field on the applet that gets set to the current date and time when the user checks a corresponding checkbox. This field is set by a bus comp user property:
"AV Hier Move Complete?", "AV Hier Move Comp Date", "IIF ([AV Hier Move Complete?] = ""Y"", Timestamp (), """")"

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
 

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.