My Oracle Support Banner

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

Last updated on FEBRUARY 16, 2023

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 19.1 and later
Information in this document applies to any platform.


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?


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

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