Date Stamps and eScript (Doc ID 509653.1)

Last updated on MARCH 02, 2017

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms