Results for “invfv_cycle_count_adjustments”
32 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
INVFV_CYCLE_COUNT_ADJUSTMENTS is an APPS-owned database view in the Oracle E-Business Suite Inventory (INV) module. It presents a consolidated, denormalized picture of physical cycle count activity and the resulting adjustments recorded against an organization's inventory. The view is built primarily over MTL_CYCLE_COUNT_ENTRIES, joined to MTL_CYCLE_COUNT_HEADERS, MTL_SYSTEM_ITEMS, MTL_ITEM_LOCATIONS, MTL_PARAMETERS, MTL_TRANSACTION_REASONS, GL_CODE_COMBINATIONS, HR_EMPLOYEES, and HR_ALL_ORGANIZATION_UNITS. In the ETRM 12.2.2 metadata the object carries a status of VALID and is described as "Retrofitted," indicating it was reconstructed for the later release lineage from the 12.1.1 definitions.
The view's reporting role is to expose, in a single queryable structure, the count quantities captured during the first, current, and prior count events, the system quantities the application expected, the variance, and the adjustment quantity, amount, and accounting date that resulted. Because it resolves employee identifiers to names and lookup codes to their meanings, it is suited to operational reporting, count reconciliation, and audit review without the reporting author having to reproduce the underlying joins.
Underlying Base Objects
The principal driving table is MTL_CYCLE_COUNT_ENTRIES (synonym), aliased MCE, which supplies the count header reference, item, subinventory, locator, count dates, count quantities, system quantities, adjustment values, approval attributes, lot and serial information, and the Who columns. It is joined to MTL_CYCLE_COUNT_HEADERS (MCH) on CYCLE_COUNT_HEADER_ID to obtain the cycle count header name, to MTL_PARAMETERS (MP) on ORGANIZATION_ID for the organization code, to MTL_TRANSACTION_REASONS (MTR) on TRANSACTION_REASON_ID for the reason name, and to GL_CODE_COMBINATIONS (GLC) for the inventory adjustment account.
Four employee references are resolved through HR_EMPLOYEES: the first, current, and prior counted-by employees and the approver. The HR_EMPLOYEES view is documented here as a base object and depends in turn on the HR_PERSON_NAME, HR_GENERAL, HR_SECURITY, and FND_PROFILE packages. HR_ALL_ORGANIZATION_UNITS supplies the organization name. Additional key flexfield and lookup references are resolved through MTL_SYSTEM_ITEMS (item), MTL_ITEM_LOCATIONS (locator), and MFG_LOOKUPS for entry status, count type, approval type, approval condition, and serial detail.
Key Columns
- CYCLE_COUNT_ENTRY_ID, CYCLE_COUNT_HEADER_ID, CYCLE_COUNT_HEADER_NAME — identifiers linking the entry to its count definition.
- COUNT_DATE_FIRST, COUNT_DATE_CURRENT, COUNT_DATE_PRIOR — the three count event dates tracked for each entry.
- COUNTED_BY_EMPLOYEE_ID_FIRST / _CURRENT / _PRIOR with HR1, HR2, HR3 LAST_NAME — counted-by personnel and their resolved names.
- COUNT_QUANTITY_FIRST / _CURRENT / _PRIOR and SYSTEM_QUANTITY_FIRST / _CURRENT / _PRIOR — counted versus expected quantities per event.
- PRIMARY_UOM_QUANTITY_FIRST / _CURRENT / _PRIOR and COUNT_UOM_FIRST / _CURRENT / _PRIOR — quantities in both primary and count units of measure.
- ADJUSTMENT_QUANTITY, ADJUSTMENT_DATE, ADJUSTMENT_AMOUNT, ITEM_UNIT_COST, INVENTORY_ADJUSTMENT_ACCOUNT — the resulting adjustment and its costing and accounting context.
- APPROVAL_DATE, APPROVER_EMPLOYEE_ID (with HR4.LAST_NAME), and the approval type and condition lookup meanings.
- ORGANIZATION_ID, ORGANIZATION_CODE, ORGANIZATION_NAME — inventory organization context.
- REVISION, LOT_NUMBER, LOT_CONTROL, SERIAL_NUMBER — item revision and lot/serial control attributes.
- NEG_ADJUSTMENT_QUANTITY and NEG_ADJUSTMENT_AMOUNT — negative adjustment values.
Common Use Cases and Queries
Typical uses include reconciliation of counted quantities against system quantities, monitoring adjustments awaiting approval, and auditing adjustment values and accounts by organization or reason. A representative query listing open approvals might select the header, item, counted name, and approval date filtered on APPROVAL_DATE IS NULL.
SELECT header_name, inventory_item_id, subinventory,
count_quantity_current, system_quantity_current,
adjustment_quantity, adjustment_amount
FROM apps.invfv_cycle_count_adjustments
WHERE organization_id = :org_id
AND approval_date IS NOT NULL;
For participation reporting, the view can be grouped by the resolved counted-by names, and for audit, filtered on adjustment_date ranges. Because HR_EMPLOYEES applies HR security, results are constrained by the running user's access, which is an important consideration when the view is used in concurrent programs or integrations.
-
- Retrofitted
APPS.INVFV_CYCLE_COUNT_ADJUSTMENTS·↳ FND_PROFILE·↳ GL_CODE_COMBINATIONS·↳ HR_ALL_ORGANIZATION_UNITS·Explore INV module →
-
- Retrofitted
APPS.INVFV_CYCLE_COUNT_ADJUSTMENTS·↳ FND_PROFILE·↳ GL_CODE_COMBINATIONS·↳ HR_ALL_ORGANIZATION_UNITS·Explore INV module →
-
12.1.1 FND Design Data 12.1.1
-
VIEW: APPS.HR_EMPLOYEES 12.1.1
-
12.2.2 FND Design Data 12.2.2
-
VIEW: APPS.HR_EMPLOYEES 12.2.2
-
SYNONYM: APPS.MTL_PARAMETERS 12.1.1
-
SYNONYM: APPS.MTL_PARAMETERS 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
eTRM - PO Tables and Views 12.1.1
Temporary table for tracking a receiving upgrade from Release 9 to Release 10
-
eTRM - INV Tables and Views 12.2.2
-
eTRM - INV Tables and Views 12.1.1
-
eTRM - INV Tables and Views 12.1.1
-
eTRM - INV Tables and Views 12.2.2
-
eTRM - PO Tables and Views 12.1.1
Temporary table for tracking a receiving upgrade from Release 9 to Release 10