My Oracle Support Banner

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

Last updated on JANUARY 21, 2021

Applies to:

Siebel CRM - Version [21211] and later
Information in this document applies to any platform.


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


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




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.