My Oracle Support Banner

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

Last updated on JULY 13, 2020

Applies to:

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

Symptoms

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:
EMP_HIRE_DATE, ASG_START_DATE

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


Changes

 

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
Changes
Cause
Solution
References


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