Results for “user_updateable_flag”
4 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
FIIBV_AP_HOLD_HOLD_LCV is a Financial Intelligence (FII) base view owned by the APPS schema within Oracle E-Business Suite. It functions as the "Hold" level source within the AP Hold dimension, providing the descriptive and behavioral attributes of accounts payable hold codes in a form suited to ETL extraction, dimensional modeling, and warehouse reporting. In the FII/Enterprise Data Warehouse (EDW) architecture, dimension members are exposed through a layered set of base views (denoted by the FIIBV_ prefix) and their associated language/current-value wrappers. This view supplies the hold-level grain, sitting beneath the AP Hold hierarchy that typically progresses from the Hold Type level downward to the individual Hold code. Its output is consumed by downstream FII loaders that populate the AP Hold dimension table and by BI Publisher, OBIEE, and custom Warehouse Builder mappings that need a stable, denormalized representation of hold metadata. The view is documented as VALID and is available in both 12.1.1 and 12.2.2, where the underlying AP and FND tables retain the same structure.
Underlying Base Objects
The view is defined over three objects: AP_HOLD_CODES (aliased AHC), AP_LOOKUP_CODES (aliased ALC), and FND_LOOKUP_VALUES (aliased FND). AP_HOLD_CODES is the primary driver, holding the definition of each hold code in Payables. AP_LOOKUP_CODES joins on LOOKUP_CODE where LOOKUP_TYPE equals 'HOLD CODE', supplying the displayed field used as the hold name. FND_LOOKUP_VALUES is joined to reconcile the lookup type, lookup code, and meaning, ensuring the code is a valid, active common lookup value. The three-way join constrains rows to genuine hold codes that pass common-lookup validation. Although the ETRM metadata lists no explicitly documented base objects, the embedded view text provides these dependencies unambiguously. Notably, FIIBV_AP_HOLD_HOLD_LCV embeds a datastore reference literal, '_DF:FND:FND_COMMON_LOOKUPS:FND', in its final projection column — a lineage marker used by the FII tooling to trace the dimension source.
Key Columns
- HOLD_PK — the hold lookup code, acting as the primary key of the dimension member.
- HOLD_TYPE_FK — foreign key linking each hold to its parent hold type, enabling the Hold Type-to-Hold hierarchy.
- INSTANCE — the EDW instance identifier derived via EDW_INSTANCE.GET_CODE, truncated to 40 bytes; supports multi-instance consolidation.
- NAME / HOLD_NAME — the displayed field from AP_LOOKUP_CODES, providing the user-facing hold name (HOLD_NAME mirrors NAME).
- USER_RELEASEABLE_FLAG — indicates whether a user may manually release the hold.
- USER_UPDATEABLE_FLAG — indicates whether the hold definition may be updated by a user.
- POSTABLE_FLAG — controls whether invoices carrying the hold may be posted to the ledger.
- INACTIVE_DATE — date the hold code ceased to be active, supporting slowly changing dimension logic.
- DESCRIPTION, CREATION_DATE, LAST_UPDATE_DATE — descriptive text and audit timestamps from AP_HOLD_CODES.
- DELETION_DATE, HOLD_DP — null placeholders conforming to the standard FII base-view column contract; HOLD_DP (the current-record indicator) is populated by higher layers.
Common Use Cases and Queries
Typical usage includes populating the AP Hold dimension, validating hold configuration against common lookups, and reporting on releasable versus non-releasable holds. A representative query listing active holds:
SELECT hold_pk, hold_name, hold_type_fk, postable_flag FROM apps.fiibv_ap_hold_hold_lcv WHERE inactive_date IS NULL;SELECT hold_type_fk, COUNT(*) FROM apps.fiibv_ap_hold_hold_lcv GROUP BY hold_type_fk;SELECT hold_pk, user_releaseable_flag FROM apps.fiibv_ap_hold_hold_lcv WHERE postable_flag = 'Y';
Because the view filters on HOLD_TYPE LIKE '%HOLD%' or equal to 'INSUFFICIENT INFORMATION', it returns only qualifying hold codes, making it safe for direct consumption without additional type filtering.
-
View: FIIBV_AP_HOLD_HOLD_LCV 12.1.1
FIIBV_AP_HOLD_HOLD_LCV is the base view for Hold level of AP Hold dimension
APPS.FIIBV_AP_HOLD_HOLD_LCV·↳ AP_HOLD_CODES·↳ AP_LOOKUP_CODES·↳ EDW_INSTANCE·Explore FII module →
-
FIIBV_AP_RLSE_RELEASE_LCV is the base view for Release level of Release dimension
APPS.FIIBV_AP_RLSE_RELEASE_LCV·↳ AP_HOLD_CODES·↳ AP_LOOKUP_CODES·↳ EDW_INSTANCE·Explore FII module →
-
View: FII_AP_HOLD_HOLD_LCV 12.1.1
FII_AP_HOLD_HOLD_LCV is the collection view for Hold level of AP Hold dimension
APPS.FII_AP_HOLD_HOLD_LCV·↳ EDW_INSTANCE·↳ FIIBV_AP_HOLD_HOLD_LCV·↳ FND_GLOBAL·Explore FII module →
-
FII_AP_RLSE_RELEASE_LCV is the collection view for Release level of Release dimension
APPS.FII_AP_RLSE_RELEASE_LCV·↳ EDW_INSTANCE·↳ FIIBV_AP_RLSE_RELEASE_LCV·↳ FND_GLOBAL·Explore FII module →