The Segment Value Inheritance program automatically propagates the attributes of a segment value to all account combinations that contain that segment value.
To protect account combinations from changes when you run the Segment Value Inheritance program, check the Preserve check box in the GL Accounts window. See: Defining Accounts.
You can assign attributes at two levels:
The individual segment value in the Segment Values window. See: Defining Segment Qualifiers.
The account combination in the GL Accounts window.
For example, you can disable the 200 cost center segment in the Segment Values window, but retain existing account combinations using cost center 200 by marking the Preserve check box for each combination in the GL Accounts window. Then, when you run the Segment Value Inheritance program, all account combinations that contain the 200 cost center will be disabled except for those you preserved and no new combinations will be created during data entry. You can view the account code combinations that have been changed in either the GL Accounts window or the Segment Value Inheritance Execution Report.
Warning: Individual segment value attributes override account combination attributes. See the table below for guidelines.
How Segment Value Attributes Override Account Code Combination
| Segment Value Attribute | Account combination attribute in GL Accounts window | Result When Running the Segment Value Inheritance program and the Account Combination is not Preserved |
|---|---|---|
| Segment Value Disabled | Account combination enabled | All account combinations that contain that segment value will be disabled. |
| Segment Value Enabled | Account combination disabled | All account combinations that contain that segment value will be enabled. |
| Budgeting Not Allowed | Budgeting Allowed | All the account combinations that contain that segment value will not allow budgeting. |
| Budgeting Allowed | Budgeting Not Allowed | All account combinations that contain that segment value will allow budgeting. |
| Posting Not Allowed | Posting Allowed | All account combinations that contain that segment value will not allow posting. |
| Posting Allowed | Posting Not Allowed | All the account combinations that contain that segment value will allow posting. |
| From Date | Latest date used | If you have a three-segment accounting flexfield, and each segment value has a different start date, the segment value with the latest start date determines the effective date of that account combination. |
| To Date | Earliest date used | If you have a three-segment accounting flexfield, and each segment value has a different end date, the segment value with the earliest end date determines the effective date of that account combination. |
| Control Account: No | N/A | All the account combinations that contain that segment value will not become control accounts. |
| Control Account: Yes | N/A | All the account combinations that contain that segment value will become control accounts. |
| Control Account: Payables | N/A | All the account combinations that contain that segment value will become Payables control accounts. |
| Control Account: Receivables | N/A | All the account combinations that contain that segment value will become Receivables control accounts. |
| Reconciliation: Yes | No | All the account combinations that contain that segment value will allow Global Reconciliation. |
| Reconciliation: No | Yes | All the account combinations that contain that segment value will not allow Global Reconciliation. |
Navigate to the GL Accounts window.
Query the account combinations you want to protect from changes and check the Preserve check box.
Save your work.
Navigate to the Segment Values window.
Change the attributes associated with your chosen segment value.
Save your work.
Navigate to the Key Flexfield Segment window.
Check the Freeze Flexfield Definition check box to freeze your accounting flexfield structure.
Navigate to the Submit Requests window.
From the List of Values, choose Program - Inherit Segment Value Attributes. In the parameters window, choose Yes or No to automatically generate the Segment Value Inheritance Execution Report. The program automatically updates the accounting flexfield structure assigned to the Data Access Set for your responsibility. If you want to update another accounting flexfield structure, you must use the responsibility for that structure.
Submit your request.
(Optional) If you choose to generate the Segment Value Inheritance Execution Report, note the concurrent request ID. The report lists all account combinations that have been updated and details which attributes were changed.
Warning: Check the Freeze Flexfield Definition check box to protect your accounting flexfield structure after you change attributes associated with your segment value.
Suggestion: If you want to protect the updated account combinations from any additional changes, query the account combinations in the GL Accounts window and check the Preserve check box.
Note: The Oracle Workflow Business Event System, introduced in Release 2.6, allows products to seed business events and event subscriptions.
A General Ledger account disabled by the Inherit Segment Value Attributes program is a seeded business event. See: Business Events
If you run the Inherit Segment Value Attributes program for a chart of accounts that contains a table validated value set, the table must contain two columns: last update date and creation date. Both these columns must contain values; they cannot be Null. If the table does not have these columns, the Inherit Segment Value Attributes program cannot determine which segment value's attributes have changed since it was last run, and it assumes that no segment value changed. The execution report shows the same information for both the original and current attributes and the Inherit Segment Value Attributes program issues a warning upon completion.
Note: You must run the program called Setup Flattening Program for Table Validated Value Sets whenever you change the parent/child hierarchies or add segment values to the value set. This program moves the relevant information from your table validated value set into GL hierarchy and security tables.