Related Value Sets

In this article you will about the new feature provided by Oracle - Related Value Sets

Lets look into the below article for more insights.

With new updates to the Cloud Solution, Oracle has now introduced the concept of Related Value Sets in the Chart of Accounts. This functionality enables the users to define the relations between different segments and their values while defining the Chart of Accounts Values. With this functionality, we can now restrict the values in one of the segments based on the value selected in another segment, thus eliminating the need to define cross-validation rules and reducing the dependence on Segment Value Security Rules.

Benefits :

 This functionality offers the following benefits to the organization as a whole:

 • This feature reduces the possibility of entering incorrect account combinations since the value set relationship automatically applies valid value filters to succeeding segments.

 • This reduces the need for having to define large numbers of cross-validation rules and the associated cost incurred for otherwise maintaining them.

 • This results in improved performance during data entry because the application doesn't have to repeatedly scan through a large number of cross-validation rules before determining that a new account combination is a valid one.  

Configuration:

Upload of Values in Related Value Set is possible, which also defines the relationship with the driving segment values.

 Import Method: Upload the File in the below format in File Import & Export under Account fin/general ledger/import 

To process the file, Navigate to Chart of Accounts Value Sets, Search for the Value Sets, in search results, click on Action & Import Related Values. 

 Provide the file names for both value sets and value set values.

ESS Route: After uploading the file in File Import & Export, submit the process - ESS Process for Applcore csv file upload as below