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

Last updated on FEBRUARY 02, 2023

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.

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

Add a Descriptive Flex Field (DFF) as Supplier Site to Contract Party Contact.
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.

	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

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