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.
To Define Account Derivation Rules for Accounting Flexfields
The following procedure describes selected fields.
1. 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.
2. 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.
3. 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
See: Transaction and Accounting Charts of Accounts, page 2-7
4. In the Output Type region, select the option that the account derivation rule will be based on.
5. 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.
6. If the output type Value Set is selected, in the Value Set field, select a value set from
the list of values.
7. 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, page 2-70
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.
8. To specify the method of deriving the Accounting Flexfield or segment value, in the Value Type field, select a value type.
9. 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
Accounting Chart
of Accounts Output Type Value Type Value Field Values
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
Accounting Chart
of Accounts Output Type Value Type Value Field Values
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
Accounting Chart
of Accounts Output Type Value Type Value Field Values
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