My Oracle Support Banner

Future Date Validation On 'Date' Field Is Incorrectly Working For AEST Time Zone (Doc ID 2626734.1)

Last updated on JANUARY 08, 2020

Applies to:

Siebel Tools - Version 16.13 [IP2016] and later
Information in this document applies to any platform.


On : 16.13 [IP2016] version, Client Functionality

Future Date validation on 'Resolved Date' field is incorrectly working for AEST time zone

The issue can be reproduced at will with the following steps:

  1. In tools navigate to Business Component --> Fields
  2. Add new date field with "Resolve Date" field name
  3. Create Calculated field with below expression : IIf ([Notice Received Date] > Today(), "Y", "N"), make sure that Force Active property is True
  4. In BC Write record check the calculated field and throw error if calculated field value == Y
  5. Compile the changes
  6. Set GMT time zone for the user by navigating to Administration - User --> Employees
  7. now login to application and try to select Resolve Date as Today Date in (AEDT time)
  8. Note:- Make sure that testing this scenario prior to 11 AM in AEDT 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

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