Deactivated Values Are Displayed On A Standard Lookup

(Doc ID 2096129.1)

Last updated on JANUARY 13, 2016

Applies to:

Oracle Fusion Sales Cloud Service - Version and later
Information in this document applies to any platform.


On : version, Accounts, Contacts, Households

Customer requires custom values for the attribute Function (API name: MemberFunctionCode) under Application: Sales --> Sales Account --> Sales Account Resource. This field is displayed as attribute of the account team member.

The Function role should be deactivated.

The issue can be reproduced at will with the following steps:
1. Go on "Setup and Maintenance" --> "Manage Standard Lookups"
2. Search for ZCA_RESOURCE_FUNCTION lookup type
3. Create new values and deactivate the standard ones
4. Save and Close
5. Go on Account Team tab
6. Add a resource
7. Under the field function are displayed all values, including those deactivated

The issue has the following business impact:
All Function roles are listed in dropdown where Customer needs to disable few


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