Note: Oracle strongly recommends that users do not modify a seeded rule or any other seeded component as it could get overwritten in an upgrade. Instead, copy a seeded rule and then modify it appropriately. The modified rule has an Owner type of User.
When users select rules and other components from a list of values in AMB windows, the name as well as the Owner of the component is displayed. This enables users to distinguish between seeded and user-defined components.
The following procedure describes selected fields.
Navigate to the Account Derivation Rules window, and in the Find Account Derivation Rules window, click New.
The application name defaults from the application associated with the responsibility.
The Owner field is automatically populated by Subledger Accounting. For components seeded by Oracle, the value is Oracle. For components created on site by users, the value is User.
Retain the default for the Enabled check box which is selected to make the account derivation rule available for use for any application with reference objects used in this account derivation rule and accounting chart of accounts.
In the Chart of Accounts region, select values for the charts of accounts.
If a value for the accounting chart of accounts is not selected, users can create an account derivation rule for an Accounting Flexfield qualifier, an Accounting Flexfield, or a value set.
Note: Account derivation rules seeded by Oracle user are independent of the accounting and transaction chart of accounts.
The table below describes the accounting chart of accounts configuration.
Accounting Chart of Accounts Configuration
| Accounting Chart of Accounts | Accounting Flexfield Rule | Segment Rule | Value Set Rule |
|---|---|---|---|
| Null | Value type must be Source and it must be an Accounting Flexfield or account derivation rule. | Value type must be source and the nature of the source can be Accounting Flexfield or segment of an Accounting Flexfield. | Value type can be Source, Mapping, or Constant. |
| Entered | Value type can be Source, Mapping Set, Constant, or Account Derivation Rule. | Value type can be Source, Mapping Set, or Constant. | Not allowed |
In the Output Type region, select the option that the account derivation rule will be based on.
If the output type Segment is selected, in the Segment field, select a segment from the list of values.
If the accounting chart of accounts is specified, the list of values includes all enabled segments for the chart of accounts. If the accounting chart of accounts is not specified, the list of values includes all segment qualifiers for the flexfield application and title.
If the output type Value Set is selected, in the Value Set field, select a value set from the list of values.
In the Priority field, enter a priority number.
Rules are evaluated in ascending order, where the highest priority has the lowest number, until a condition is met. It is advantageous to list the most commonly met rules and conditions first. The order in which rules and conditions are evaluated by updating the priority number instead of by deleting and rewriting detail lines can be changed. Once the conditions associated with a detail line are satisfied, the value from that line is used and other lines are ignored.
See: Account Derivation Rule Conditions
To handle the case in which none of the conditions are met, enter a last detail line with no conditions associated with it. As AMB uses this line as a default, assign the lowest priority to this line. Once a segment has a valid value, it cannot be overwritten and AMB proceeds with the building of the next segment value.
To specify the method of deriving the Accounting Flexfield or segment value, in the Value Type field, select a value type.
In the Value field, enter the value consistent with the value type selected.
The table below summarizes the relationship between accounting chart of accounts, output type, value type, and values in the Value field.
| Accounting Chart of Accounts | Output Type | Value Type | Value Field Values |
|---|---|---|---|
| Null | Flexfield | Source | All enabled sources for the application marked as Accounting Flexfield |
| Null | Accounting Flexfield Qualifier | Source | If creating an account derivation rule for Accounting Flexfield: all enabled sources for the application marked as Accounting Flexfield plus sources marked as the Accounting Flexfield qualifier corresponding to the segment to be derived in the account derivation rule |
| Null | Value Set | Source | If creating an account derivation rule for Accounting Flexfield: all enabled sources for the application marked as an Accounting Flexfield qualifier or Other that have the same value set |
| Null | Value Set | Mapping Set | All enabled mapping sets with the same value set |
| Null | Value Set | Constant | List of values from the value set |
| Null | Value Set | Account Derivation Rule | All account derivation rules with no account derivation rule assigned to it |
| Not Null | Flexfield | Source | All enabled sources for the application marked as Accounting Flexfield |
| Not Null | Flexfield | Mapping Set | All enabled mapping sets with the same accounting chart of accounts and whose output type is Flexfield |
| Not Null | Flexfield | Constant | All enabled combination for the accounting chart of accounts |
| Not Null | Flexfield | Account Derivation Rule | All account derivation rules with no account derivation rule assigned to it are available. |
| Not Null | Segment | Source | If creating an account derivation rule for Accounting Flexfield: all enabled sources for the application marked as Accounting Flexfield plus sources marked as the Accounting Flexfield qualifier corresponding to the segment to be derived in the account derivation rule plus sources marked as the Other segment |
| Not Null | Segment | Mapping Set | All enabled mapping sets with the same accounting chart of accounts and whose output type has the same segment as the segment to be derived in the account derivation rule |
| Not Null | Segment | Constant | All segment values for the accounting chart of accounts and segment |
| Not Null | Segment | Account Derivation Rule | All account derivation rules with no account derivation rule assigned to it |
If value type Mapping Set is selected, in the Input Source field, select the source name to be compared with the mapping set input value.
If output type Segment and value type Source are selected, in the Segment field, select the segment from which the value is to be taken.
The Segment field can be entered if the nature of source in the Value field is Accounting Flexfield or key flexfield or the nature of the input source is Accounting Flexfield or key flexfield.