On Field Update Set N Business Component User Property Is Not Working (Doc ID 2577096.1)

Last updated on JANUARY 21, 2021

Applies to:

Symptoms

On Field Update set n Business Component User Property is not Working

In Service Request List Applet , on change of Status Field value to Closed , Close Time Field not getting updated through On Field Update Set user property



 


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

1. Add below user properties under "Service Request" Business Component"
User Property Name :- On Field Update Set 14

Value :- "Status", "Test Resolved Time", "IIF([Test Resolved Time] Is NOT NULL, [Test Resolved Time], IIF ([Status] =LookupValue("SR_STATUS","Resolved"), Timestamp(),[Test Resolved Time]))"

*****************************************

User Property Name :- On Field Update Set 16

Value :- "Status", "Test Closed Time", "IIF ([Status] =LookupValue(""SR_STATUS"",""Closed""), Timestamp(), """")"

*****************************************

User Property Name :- On Field Update Set 19

Value :- "Status", "Test Service Status", "IIF ([Status] = LookupValue(""SR_STATUS"",""Auto Endo-Failed""), ""N"", [Test Service Status])"

2. Compile the changes
3. Login to application
4. Change the SR Status to Closed and verify the "Closed Time" field value

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.