Results for “ending_bal”
31 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
IC_PERD_BAL_VW1 is a reporting view owned by the APPS schema in Oracle E-Business Suite, catalogued under the GMI (Process Manufacturing Inventory) product family. Its documented status is VALID, and the ETRM description identifies it simply as a "Period balance view." The object is classified as a VIEW rather than a table, which means it stores no data of its own; it exposes a consolidated, query-ready projection of period-end inventory balances held in the underlying Process Manufacturing tables.
The view's practical role is to present inventory on-hand quantities aggregated to the fiscal period level rather than at the individual transaction or lot level. This aggregation makes it suitable for period-close reporting, inventory valuation reconciliation, and downstream integration extracts where consumers require one row per item, warehouse, fiscal year, and accounting period. Because the view is defined in the APPS schema, it is accessible to standard EBS responsibilities and to custom concurrent programs and reports that connect as APPS or through a synonym. The presence of the FISCAL_YEAR column — the term for which the user searched — confirms that the view is oriented around fiscal calendar reporting, allowing inventories to be sliced and compared across accounting years.
Underlying Base Objects
The ETRM metadata lists a single referenced base object: IC_PERD_BAL, accessed through a synonym. IC_PERD_BAL is the Process Manufacturing inventory period balance table, which stores on-hand quantities captured or derived at period boundaries. The view is defined with a straightforward aggregation query over that table:
- Columns selected: FISCAL_YEAR, PERIOD, ITEM_ID, WHSE_CODE, and SUM(LOCT_ONHAND).
- Grouping: GROUP BY FISCAL_YEAR, PERIOD, ITEM_ID, WHSE_CODE.
- Result set: one row per unique combination of fiscal year, period, item, and warehouse, with total location on-hand quantity summed across locations.
Because the definition performs no joins to item masters, warehouses, or calendars, it is a thin consolidation layer. Any enrichment such as item descriptions, warehouse names, or unit-of-measure conversion must be supplied by the calling query joining to the relevant master tables.
Key Columns
- FISCAL_YEAR — The fiscal year to which the balance belongs. This is the principal filter column for year-over-year and year-to-date analysis, and it is the column implicated in the user's "fiscal_year" search.
- PERIOD — The accounting period within the fiscal year, typically expressed as a period number or name, enabling month-by-month trend reporting.
- ITEM_ID — The internal inventory item identifier, joining to the item master for descriptive attributes.
- WHSE_CODE — The warehouse code, identifying the stocking location at which the balance resides.
- ENDING_BAL — The aggregated on-hand quantity for the item/warehouse/period combination. In the view definition this is produced by SUM(LOCT_ONHAND) from IC_PERD_BAL; documentation lists the exposed column as ENDING_BAL, representing total location on-hand.
Common Use Cases and Queries
Typical scenarios include period-end stock reporting, reconciliation of perpetual inventory to the general ledger, and extracts feeding a data warehouse or planning system. The following query returns all item and warehouse balances for a given fiscal year and period:
SELECT fiscal_year, period, item_id, whse_code, ending_bal FROM apps.ic_perd_bal_vw1 WHERE fiscal_year = 2019 AND period = 12 ORDER BY item_id, whse_code;
To compare successive periods for a single item, aggregate or filter as follows:
SELECT fiscal_year, period, whse_code, SUM(ending_bal) FROM apps.ic_perd_bal_vw1 WHERE item_id = :item_id GROUP BY fiscal_year, period, whse_code ORDER BY fiscal_year, period;
Because the view pre-aggregates location-level detail, it should not be used where lot, locator, or transaction-level granularity is required; in those cases the base table IC_PERD_BAL or a lower-level view is appropriate. Performance is generally favourable for fiscal-period reporting since the grouping is performed on a single source table, but composite filters on FISCAL_YEAR and PERIOD are recommended to limit the scan.
-
View: IC_PERD_BAL_VW1 12.1.1
Period balance view.
-
Table: FV_FACTS2_RETAIN_BAL 12.2.2
Stores the ending balance of previous fiscal year and beginning balance of current fiscal year.
-
View: IC_PERD_BAL_VW1 12.2.2
Period balance view.
-
Temporary data about the report
-
Temporary data about the report
-
VIEW: GMP.PS_MATL_DTL# 12.2.2
-
VIEW: APPS.IC_PERD_BAL_VW1 12.1.1
-
VIEW: APPS.IC_PERD_BAL_VW1 12.2.2
-
VIEW: GMP.PS_MATL_DTL# 12.2.2
-
TABLE: GMP.PS_MATL_DTL 12.1.1
-
TABLE: GMP.PS_MATL_DTL 12.2.2
-
eTRM - GMP Tables and Views 12.1.1
* NOT USED *
-
eTRM - GMP Tables and Views 12.2.2
* NOT USED *
-
eTRM - GMI Tables and Views 12.2.2
Table used to relate Item ID with Roles. If the Item ID is NULL, then Roles will be associated with the warehouse Item ID. This table will be used by the Lot Expiry/Retest Workflow.
-
eTRM - GMI Tables and Views 12.1.1
Table used to relate Item ID with Roles. If the Item ID is NULL, then Roles will be associated with the warehouse Item ID. This table will be used by the Lot Expiry/Retest Workflow.
-
eTRM - FV Tables and Views 12.2.2
Temporary table populated during the Year End Closing process