Using calculated field in FieldToCheck attribute of On Field Update Set n user property (Doc ID 512944.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel Tools - Version 7.5.3 SIA [16157] to 8.1.1 [21112] [Release V7 to V8]
z*OBSOLETE: Microsoft Windows 2000
Database: Oracle 8.1.7.4
Application Server OS: Microsoft Windows 2000 Advanced Server SP 2
Database Server OS: IBM AIX 4.3.3

This document was previously published as Siebel SR 38-1097717131.


*** Checked for Relevance on 02-FEB-2015 ***

Symptoms

“On Field Update Set n” not working when using a calculated field for the "FieldToCheck"

 

Specifics:

“On Field Update Set n” not working with “CPG Plan Account Promotion” BC (based on CSBCPromoAccountSIS) in ConsumerSector. We have a field “WHVExpire Date” which is mapped to X_Expire_Dt column in S_SRC table in this BC. We need to update this field based on other fields.

To meet the requirements we ave created the following configuration in this BC.

1)Field WHVClassOfTrade: Join on Account_id to s_org_ext.Par_Row_id, brings in OU_TYPE_CD.

2)Calc Field WHVComputedEndDate: value is IIF([WHVClassOfTrade]=”Wholesale”, [End Date Promo For Acct]+180, [End Date Promo For Acct] + 120. [End Date Promo For Acct] is entered by user.

3)Calc field WHVComputedStartDate: value is IIF([WHV Submitted Date] IS NOT NULL, IIF([WHVClassOfTrade]=”Wholesale”, [WHV Submitted Date]+180, [WHV Submitted Date] + 120, IIF([WHVClassOfTrade]=”Wholesale”, [End Date Promo For Acct]+180, [End Date Promo For Acct] + 120). [WHV Submitted Date] is populated by user.

4)Calc Field WHVComputeExpireDate: value is IIF([WHVComputedEndDate] >= [WHVComputedStartDate], [WHVComputedEndDate], WHVComputedStartDate]).

Fields are exposed on the UI and computed correctly. I have also set the Force Active and Post Immediate on all fields.  Next, under BC user Props, I have created the “On Field Update Set 8” with values “WHVComputedExpireDate”, “WHVExpire Date”, “WHVComputedExpireDate”.  Aim is that whenever the WHVComputedExpireDate is updated than we want that value posted to “WHVExpire Date”.

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms