Element Entry Input Value Is Not Updated With Null by Update Recurring Entry (Doc ID 832026.1)

Last updated on DECEMBER 01, 2023

Applies to:

Symptoms

Problem Statement:

Element entry input value is not updated with formula result by update recurring entry when the return value is null.

The issue occurs when all the following  are applicable.

1. Formula return value in formula result rule contains only spaces.
2. The element input parameter is not the first input parameter of update recurring entry (from the top)defined in formula result rule.

*The issue occurs for the input parameter of the second (and higher) update recurring entry defined in formula result rule. The issue does not occur for the input parameter of the first update recurring entry in the definition.

Steps to Reproduce:

1.     Define element, formula, formula results as following:

For Example:

Element Name: TEST_1
Reccuring: Yes
Input Value :

Name	Units
IV1	Character
IV2	Character
IV3	Integer
IV4	Character

Formula Name:F_REC_TEST 

Formula Text:

L_IV3 = 4 L_IV1 = ' ' L_IV2 = ' ' L_IV4 = ' ' return L_IV1,L_IV2,L_IV3,L_IV4

Formula Results:

Element Name
TEST_1

- Processing Rules

Name	Formula
Active Assignment	F_REC_TEST

- Formula Results

Name	Type	Element Input Value
L_IV1	Update recurring entry (*1)	IV1
L_IV2	Update recurring entry (*2)	IV2
L_IV3	Update recurring entry (*3)	IV3

*1:The first input parameter of update recurring entry from the top.
*2:The first input parameter of update recurring entry from the top.
*3:The first input parameter of update recurring entry from the top.

2.   Create an element entry of the above element for en employee (Element Entry 1).

  Element Entry 1:
  Effective_Start_Date:01-DEC-20XX
  Effective_Start_Date:31-DEC-4712

Input value of input parameters:

Input Parameter	Input Value
IV1	20080401
IV2	20080930
IV3	2
IV4	20080930

 

 

3.  Run bonus process (Date Paid: 20-JUN-20XX).

4.As the result of the bonus process in step 3, the existing element entry (Element Entry 1) is end-dated, and a new entry is created (Element Entry 2).  But the input values of the new entry do not have the formula results except IV1 and IV3.

Element Entry 2:
  Effective_Start_Date:20-JUN-20XX
  Effective_Start_Date:31-DEC-4712

Input value of input parameters:

Input Parameter	Input Value
IV1	(NULL)
IV2	20080930
IV3	4
IV4	20080930

*IV1 is updated with null 

The issue does not occur since it is the first input parameter of update recurring entry

*IV2 is not updated with null (the issue occurs).
*IV4 is not updated with null (the issue occurs).

, where correct input values of REC2 is:

Input value of input parameters:

Input Parameter	Input Value
IV1	(NULL)
IV2	(NULL)
IV3	4
IV4	(NULL)

Changes

Cause

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