My Oracle Support Banner

How To Filter Suppliers Sites LOV For The Selected Supplier In OKC Party Roles? (Doc ID 2915202.1)

Last updated on SEPTEMBER 06, 2024

Applies to:

Oracle Fusion Enterprise Contracts Management Cloud Service - Version 11.13.22.10.0 and later
Information in this document applies to any platform.

Goal

How to filter Supplier Sites value based on the supplier selected for the contract?

  1. Add a Descriptive Flex Field (DFF) as Supplier Site to Contract Party Contact.
  2. Assign a table value set for the created supplier Site field to fetch values from the Supplier Site table POZ_SUPPLIER_SITES_ALL_M.

Expected Output:

         The LOV should list only the supplier sites of the supplier that is assigned to the contract and the business unit the contract belongs to.

Actual Output:         

         The LOV fetches all the supplier sites from POZ_SUPPLIER_SITES_ALL_M table.

Solution

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
Goal
Solution


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