My Oracle Support Banner

Database Items Used in Element Input Validation Formula are not Getting Refreshed (Doc ID 2493211.1)

Last updated on FEBRUARY 15, 2024

Applies to:

Oracle Payroll - Version 12.1.3 and later
Information in this document applies to any platform.


Problem Statement:

There is an element with an input value of Date type. This input value has a fast formula for validation using the following database items:

The validation formula is working perfectly, unless the latest_start_date for an employee is changed. If user changes the latest start date, the formula still sees it as the old one and the validation failed.
The only thing which makes refreshing the DBI and get the correct value is to re-query the employee, case in which the validation is passed

Steps to reproduce
The issue can be reproduced at will with the following steps:
1. original hire_date was 23-oct-2018, this was updated to 01-oct-2018
2. Try to enter date input value as 11-oct-2018




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.