My Oracle Support Banner

Custom Pick Applet Shows Less Records Than Spooled SQL (Doc ID 793895.1)

Last updated on MAY 27, 2021

Applies to:

Siebel Tools - Version 8.0 [20405] and later
Information in this document applies to any platform.
""Checked For Relevance On 03-July-2013""


Symptoms

# Customization done by the customer:
- - -
I have constructed a Custom BC called ‘VBS Employee Positions Skills’, this looks at all Position Skills in the system (S_POS_SKILL_IT) & finds out the positions (via S_PARTY_PER) they belong too, it then uses S_PARTY_PER to lookup the Position employees. The Buscomp then looks up the Position Id on S_PARTY to find the PAR_PARTY_ID (i.e. the Parent Position Id).

Position Skills in our system correspond to Service Request Type, there is a Business Requirement is restrict the Owner in the Owner Pick Applet to anyone who has a Position that has a Positions Skill that corresponds to the Service Request Type. This is captured in the pick map constraint on the Service Request ‘Owner’ field.

Additionally anyone who is logging into their ‘My Team’s Service Request' view should only see their subordinates records. So there is a search spec on the List Applet on this view restricts records to those where the logged in users Position Id is equal to the Parent Position Id or the Position Id. So the user gets to see the records of anyone who has their position as a Parent Position or their own records.
- - -

# Their issue:
- - -
When I click on the pick list the SQL running in the background is different to the data that is displayed in the pick Applet. The pick applet seems to de-duplicate the data by Position prior to showing it, so if there are 10 records produced by running the SQL (and in fact there are just 5 positions with all the positions being associated to two employees) the applet will just show 5 records for each of the positions. So if I then associate just one employee with each of the 5 positions, the SQL will produce 5 records and the Pick Applet will show 5 records.
- - -

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.