How to Create Related Value Sets for a Chart of Accounts
You can define related value sets and values manually, or you can use an import process.
Manual Method
To create a value set relationship for a chart of accounts, or to edit or delete an existing value set relationship:
-
In the Setup and Maintenance work area, go to the following:
-
Offering: Financials
-
Functional Area: Financial Reporting Structures
-
Task: Manage Chart of Accounts Value Sets
-
-
Search for the Independent value set that you want another value set to be related to.
For example, a chart of accounts has the following segments in this order: Company, Department, and Account. The corresponding value sets are also named Company, Department, and Account. To filter Department values based on the selected Company value, search for either the Company or Department value set.
-
In the Search Results section, click the Related Value Sets tab.
-
From the Actions menu, select Create to create the relationship, or select Edit or Delete to update or delete an existing relationship.
To create a relationship, select the applicable value set in the Related Value Set Code field. For example, select the value set for the Department segment if you had selected the Company value set in the previous step.
-
Click Save.
-
Click the Add Row icon.
-
Add the values and save.
Note:When creating a new relationship between value sets, don't enable the relationship until after you finish mapping all of the related values.
-
Redeploy the chart of accounts structure for the value set relationship to take effect.
-
Offering: Financials
-
Functional Area: Financial Reporting Structures
-
Task: Manage Chart of Accounts Structure Instances
Note:You don't have to redeploy the chart of accounts when you're adding and updating related values.
-
Import Method
The import method is useful when you have to map a large number of related values. You can import both related value sets and related values, or either one of them. You can also use this method for future maintenance, such as updating existing relationships.
The import method uses .csv files. One file is used for relationship definitions and the other for the related values.
To create value set relationships:
-
Enter the following header information in the first row of the .csv file, separating each attribute with a vertical bar (|):
VALUE_SET_CODE1|VALUE_SET_CODE2|ENABLED_FLAG
-
In the subsequent rows, enter the names of the related value sets followed by Y or N to indicate whether the relationship is enabled. Separate the values in each row using the vertical bar (|).
To create or maintain the values for defined relationships:
-
Enter the following header information in the first row of the .csv file, separating each attribute with a vertical bar (|):
VALUE_SET_CODE1|VALUE_SET_CODE2|VALUE1|VALUE2|ENABLED_FLAG
-
In the subsequent rows, enter the names of the related value sets, the related values, and Y or N to indicate whether the row is enabled. Separate the values in each row using the vertical bar (|).
To import the .csv files into the document repository:
-
Navigate to the Tools work area and select the File Import and Export link.
-
Select Upload from the Actions menu.
-
Choose a .csv file that you prepared earlier.
-
In the Account field, specify the location for upload. For example, select
fin/generalLedger/import
. -
Click Save and Close.
To import the value set relationships and related values into the application:
-
In the Setup and Maintenance work area, go to the following:
-
Offering: Financials
-
Functional Area: Financial Reporting Structures
-
Task: Manage Chart of Accounts Value Sets
-
-
From the Search Results section Actions menu, select Import Related Values.
-
On the Import Related Values dialog box, select the account location where you previously uploaded the .csv files.
-
Specify the names of the files in the Related Value Set File Name and Related Values File Name fields. If the relationship between value set pairs has already been manually created, upload only the related values files.
-
Click Upload.
-
Click the Download Log File link to verify the results.
-
If you created or updated a value set relationship, verify that the chart of accounts structure was successfully redeployed.
-
Optionally, verify the impact of related values on account combinations on the Create Journal page.
As an alternative to steps 1 through 6, you can go to the Scheduled Processes page and submit the process called Upload Comma-Separated Values File. Enter the .csv file name and its location in the document repository. Select the appropriate file type of either RELATEDVALUESET or RELATEDVALUESETVALUES, depending on what you want to upload.