Can't use a Joined field in Associate Applet Search Spec
(Doc ID 528651.1)
Last updated on JULY 21, 2020
Applies to:Siebel Tools - Version 220.127.116.11 SIA  to 18.104.22.168 SIA [Release V7 to V8]
We have the following custom applets which are cloned from Vanilla objects: COO Account Pick Applet. COO Bill To Address Mvg Applet and COO Com Address Assoc Applet. The requirement we are trying to satisfy is to create a new "Billing" account from the Pick Applet including its Billing Address and only display Billing Addresses in the Associate applet belonging to the user's Primary Account.
The MVG applet is invoked from the Street Address MVF on the Account Pick Applet & the MVG applet has the COO Com Address Assoc Applet as its associate applet.
We wish to filter the Associate applet records based on the Account Id(CUT Address) and as such have set its Search Specification to [Account Id] = GetProfileAttr("MasterAcctId"). Note: the profile attribute is set prior to invoking the Assoc applet and we have confirmed that this attribute value is retrieved successfully .
The problem seems to be that any joined field in the CUT Address BC cannot be used in the Search Spec as it prevents any records from being displayed. As a test, we used a hard coded Id instead of the GetProfileAttr and it still does not work. The search spec on the Associate applet will work if we use a base table field eg. Postal Code but this does not suit our requirement. When using the joined field(Account Id) in the search spec, the SQL produced includes the following in the Where clause: ('1-ABCD' is null) and as such no records are retrieved.
Any suggestions and/or work arounds?
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