Can't use a Joined field in Associate Applet Search Spec

(Doc ID 528651.1)

Last updated on JULY 12, 2017

Applies to:

Siebel Tools - Version 7.5.2.7 SIA [15058] to 8.1.1.2 SIA[21215] [Release V7 to V8]
Generic Windows

Symptoms

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?

Changes

 

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