ER: Need Help Creating Custom Validation Rule For CFA on Item Supplier Country (Doc ID 2775131.1)

Last updated on OCTOBER 22, 2024

Applies to:

Goal

The Item Supplier Country Custom Flex Attributes (CFAS) has been set up. Need to create a Custom Validation Rule to ensure that all Item Supplier Countries have these CFAs filled upon Item Approval.

The following scenario works successfully:
Item has 1 supplier and 1 supplier country to that supplier with CFA.

However, the below scenarios are not successful:

Item has 2 suppliers each with 1 supplier country, but only 1 item supplier country has the CFA
Item has 1 supplier and 2 supplier country, but online 1 supplier country has the CFA

But since the options on the UI screen are limited and you could not replicate this exact query.
Could you advise on what to do to make it work?
 

Solution

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