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
