Results for “override_allowed_flag”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
FA_HIERARCHY_RULE_DETAILS_V is an Oracle EBS Assets (OFA) view owned by the APPS schema. It exposes the configuration rows that drive hierarchy-based asset assignment and defaulting logic in Oracle Assets. In EBS 12.1.1 and 12.2.2, hierarchy rule sets allow an organization to define how asset attributes (such as depreciation basis, category, or life) are derived by traversing a reporting or accounting hierarchy rather than from a single static source. This view presents the individual rule details belonging to each hierarchy rule set, keyed by HIERARCHY_RULE_SET_ID.
For reporting and integration purposes, the view acts as the readable access point to the hierarchy rule configuration. Because it is a simple projection over the base table without complex joins, it is safe to query directly from custom reports, concurrent programs, or interfaces without incurring the performance penalties associated with generalized flexfield or descriptive flexfield views.
Underlying Base Objects
The view is defined over a single base object, FA_HIERARCHY_RULE_DETAILS, which is exposed to APPS through a synonym. The view text selects ROWID and the full set of application columns from that table, applying no filtering, aggregation, or join logic. Consequently, the row count and cardinality of the view are identical to the underlying base table, and the view contains one row per rule detail line within a hierarchy rule set.
All identifiers and audit columns originate from the base table. No additional calculation, decode, or lookup resolution is performed at the view layer, which means any translatable or descriptive information must be joined separately from the relevant lookup or flexfield views.
Key Columns
- ROW_ID / ROWID — The physical row identifier of the underlying record, useful for direct row addressing and debugging.
- HIERARCHY_RULE_SET_ID — The foreign key identifying the parent hierarchy rule set to which the detail line belongs. This is the column most commonly used to group, filter, and join rule details back to the rule set header.
- ATTRIBUTE_NAME — The asset attribute governed by this rule detail line.
- BOOK_TYPE_CODE — The depreciation book in which the rule applies.
- INCLUDE_HIERARCHY_FLAG — Indicates whether the hierarchy itself is traversed when resolving the attribute.
- INCLUDE_LEVEL — The hierarchy level included in the resolution.
- INCLUDE_ASSET_CATG_LIFE_FLAG, INCLUDE_CATG_END_DATE_FLAG, INCLUDE_ASSET_END_DATE_FLAG, INCLUDE_LEASE_END_DATE_FLAG — Flags controlling which date or life sources participate in determining the attribute value.
- BASIS_CODE — The basis used for the rule computation.
- PRECEDENCE_LEVEL — The order in which this rule detail is evaluated relative to others in the same set.
- OVERRIDE_ALLOWED_FLAG — Indicates whether a user may manually override the value derived by this rule.
- TARGET_FLAG — Identifies the target of the rule resolution.
- Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.
Common Use Cases and Queries
A frequent requirement is to review all detail lines configured for a specific hierarchy rule set, typically located by searching on hierarchy_rule_set_id. The following query returns the full rule definition ordered by evaluation precedence:
SELECT hierarchy_rule_set_id, attribute_name, book_type_code, basis_code, precedence_level, override_allowed_flag, target_flag FROM apps.fa_hierarchy_rule_details_v WHERE hierarchy_rule_set_id = :p_rule_set_id ORDER BY precedence_level, attribute_name;
To audit which book types are referenced across all rule sets, a distinct projection is commonly used:
SELECT DISTINCT hierarchy_rule_set_id, book_type_code FROM apps.fa_hierarchy_rule_details_v ORDER BY hierarchy_rule_set_id;
For troubleshooting unexpected defaults, a report joining the view to the corresponding rule set header on HIERARCHY_RULE_SET_ID allows comparison of the configured precedence and override behavior against the values actually assigned to assets. Because the view performs no filtering, users should always restrict queries by HIERARCHY_RULE_SET_ID or BOOK_TYPE_CODE to avoid returning the complete rule configuration across the instance.
-
APPS.FA_HIERARCHY_RULE_DETAILS_V·↳ FA_HIERARCHY_RULE_DETAILS·Explore OFA module →
-
Specific rules for a rule set, detailing how attributes are derived and where they are derived from.
-
View: SO_MANUAL_DISCOUNTS_V 12.2.2
APPS.SO_MANUAL_DISCOUNTS_V·↳ QP_PRICE_LIST_PVT·↳ QP_VIEW_UTIL·↳ SO_DISCOUNTS·Explore OE module →
-
Standard value rules
-
Specific rules for a rule set, detailing how attributes are derived and where they are derived from.
-
Discounts for use in price adjustments
-
View: OE_DISCOUNTS_V 12.1.1
Obsolete
APPS.OE_DISCOUNTS_V·↳ QP_LIST_HEADERS_B·↳ QP_LIST_HEADERS_TL·↳ QP_LIST_LINES·Explore QP module →
-
Order and line standard notes
-
Order and line standard notes
-
APPS.FA_HIERARCHY_RULE_DETAILS_V·↳ FA_HIERARCHY_RULE_DETAILS·Explore OFA module →
-
Discounts for use in price adjustments
-
View: OE_DISCOUNTS_V 12.2.2
Obsolete
APPS.OE_DISCOUNTS_V·↳ QP_LIST_HEADERS_B·↳ QP_LIST_HEADERS_TL·↳ QP_LIST_LINES·Explore QP module →
-
View: SO_MANUAL_DISCOUNTS_V 12.1.1
APPS.SO_MANUAL_DISCOUNTS_V·↳ QP_PRICE_LIST_PVT·↳ QP_VIEW_UTIL·↳ SO_DISCOUNTS·Explore OE module →
-
This view is used to retrieve Price Adjustments history. This is used by the history form.
APPS.OE_PRICE_ADJS_HISTORY_V·↳ OE_PRICE_ADJS_HISTORY·↳ QP_LIST_HEADERS_TL·Explore ONT module →
-
This view is used to retrieve Price Adjustments history. This is used by the history form.
APPS.OE_PRICE_ADJS_HISTORY_V·↳ OE_PRICE_ADJS_HISTORY·↳ QP_LIST_HEADERS_TL·Explore ONT module →
-
View: OE_PRICE_ADJUSTMENTS_V 12.1.1
This is a view on table OE_PRICE_ADJUSTMENTS.
APPS.OE_PRICE_ADJUSTMENTS_V·↳ OE_PRICE_ADJUSTMENTS·↳ QP_LIST_HEADERS_TL·Explore ONT module →
-
View: SO_PRICE_ADJUSTMENTS_V 12.1.1
APPS.SO_PRICE_ADJUSTMENTS_V·↳ FND_GLOBAL·↳ SO_DISCOUNTS·↳ SO_LOOKUPS·Explore OE module →
-
View: SO_PRICE_ADJUSTMENTS_V 12.2.2
APPS.SO_PRICE_ADJUSTMENTS_V·↳ FND_GLOBAL·↳ SO_DISCOUNTS·↳ SO_LOOKUPS·Explore OE module →
-
View: OE_PRICE_ADJUSTMENTS_V 12.2.2
This is a view on table OE_PRICE_ADJUSTMENTS.
APPS.OE_PRICE_ADJUSTMENTS_V·↳ OE_PRICE_ADJUSTMENTS·↳ QP_LIST_HEADERS_TL·Explore ONT module →
-
Standard value rules
-
APPS.OEXCPSVR SQL Statements 12.1.1
-
APPS.OEXCPSVR SQL Statements 12.2.2
-
VIEW: OE.SO_NOTES# 12.2.2
-
VIEW: OE.SO_DISCOUNTS# 12.2.2
-
PACKAGE BODY: APPS.OEXCPSVR 12.2.2
-
VIEW: OE.SO_NOTES# 12.2.2
-
VIEW: OE.SO_DISCOUNTS# 12.2.2
-
PACKAGE BODY: APPS.OEXCPSVR 12.1.1
-
VIEW: APPS.OE_DISCOUNTS_V 12.1.1
-
VIEW: APPS.OE_DISCOUNTS_V 12.2.2
-
View: XNC_PRICE_ADJ_V 12.2.2
XNC_PRICE_ADJ_V retrieves price adjustments applied to an order line.
Not implemented in this database·Explore XNC module →
-
TABLE: OE.SO_DISCOUNTS 12.2.2
-
View: XNC_PRICE_ADJ_V 12.1.1
XNC_PRICE_ADJ_V retrieves price adjustments applied to an order line.
Not implemented in this database·Explore XNC module →