Using calculated field in FieldToCheck attribute of On Field Update Set n user property
Last updated on MARCH 02, 2017
Applies to:Siebel Tools - Version 7.5.3 SIA  to 8.1.1  [Release V7 to V8]
z*OBSOLETE: Microsoft Windows 2000
Database: Oracle 184.108.40.206
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 ***
“On Field Update Set n” not working when using a calculated field for the "FieldToCheck"
“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”.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms