Results for “fmeff_id”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
FM_FORM_EFF_VW1 is a database view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the GMD (Process Manufacturing Product Development) application. It is documented as the "Item Effectivity View" and functions as a filtered presentation layer over the item effectivity data used by Oracle Process Manufacturing. In EBS 12.1.1 and 12.2.2, the view exposes a curated subset of the columns and rows held in its underlying base object, allowing reports, concurrent programs, and integration interfaces to retrieve active formula effectivity records without having to re-implement the filtering logic themselves.
The view carries a VALID status in the data dictionary, indicating that it compiles cleanly against its referenced base object. Because it is a view rather than a table, it stores no data of its own; all values are resolved at query time from the synonym referenced in its definition. This makes it a low-risk, read-only access point for developers and analysts who require formula effectivity information in a stable, pre-filtered form.
Underlying Base Objects
The view is defined over a single referenced base object: FM_FORM_EFF, referenced through a synonym in the APPS schema. The view text is a straightforward projection and restriction of that table:
- Source table: FM_FORM_EFF (aliased as EFF in the view definition).
- Row filters applied: FORMULA_USE = 2 and DELETE_MARK = 0.
- Columns projected: ORGN_CODE, ITEM_ID, END_DATE, FMEFF_ID, STD_QTY, ITEM_UM, FORMULA_ID.
The FORMULA_USE = 2 predicate restricts the result set to a specific formula usage classification, while DELETE_MARK = 0 excludes rows that have been logically deleted. Together these filters ensure the view returns only current, meaningful effectivity records. Because it references a synonym rather than fully qualifying the table, the view depends on the APPS synonym resolution remaining intact after patching or cloning operations.
Key Columns
- FMEFF_ID — The primary identifier for the formula effectivity record; useful as a join key and for auditing individual rows.
- FORMULA_ID — Identifies the formula to which the effectivity record belongs, linking effectivity back to the formula definition.
- ITEM_ID — The inventory item associated with the effectivity record, resolved against the item master.
- ORGN_CODE — The organization code, enabling multi-organization filtering in process manufacturing environments.
- STD_QTY — The standard quantity for the effectivity record. This is the column most commonly targeted by searches, since it drives quantity-based effectivity and yield calculations.
- ITEM_UM — The unit of measure for the item quantity, essential for interpreting STD_QTY correctly.
- END_DATE — The date on which the effectivity record ceases to be valid, supporting time-phased queries.
Common Use Cases and Queries
Typical uses include reporting on active formula effectivity by organization, validating standard quantities before integration loads, and joining effectivity data to formula and item master tables. A representative query is:
SELECT FMEFF_ID, FORMULA_ID, ITEM_ID, ORGN_CODE, STD_QTY, ITEM_UM, END_DATE FROM APPS.FM_FORM_EFF_VW1 WHERE ORGN_CODE = :orgn AND END_DATE > SYSDATE;— retrieves currently valid effectivity rows for a given organization.SELECT FORMULA_ID, SUM(STD_QTY) FROM APPS.FM_FORM_EFF_VW1 GROUP BY FORMULA_ID;— aggregates standard quantities per formula.SELECT * FROM APPS.FM_FORM_EFF_VW1 WHERE ITEM_ID = :item_id ORDER BY END_DATE DESC;— lists effectivity history for a specific item.
Because STD_QTY and ITEM_UM must be interpreted together, queries that report quantities should always include the unit of measure to avoid ambiguous results.
-
View: FM_FORM_EFF_VW1 12.1.1
Item Effectivity View
-
Recipe-Effectivity Association Table
-
View: FM_FORM_EFF_VW1 12.2.2
Item Effectivity View
-
View: FM_FORM_EFF_VW3 12.1.1
APPS.FM_FORM_EFF_VW3·↳ GMD_RECIPES_B·↳ GMD_RECIPE_VALIDITY_RULES·↳ GMD_STATUS_B·Explore GMD module →
-
Item costs for transactions. Maintains accounting and current costs. Component cost details are available in GL_ITEM_DTL table.
-
Formula Effectivity Mapping Table
-
Formula Effectivity Mapping Table
-
Item costs for transactions. Maintains accounting and current costs. Component cost details are available in GL_ITEM_DTL table.
-
Table for Routing offsets used in Lead Time Calculations
-
View: FM_FORM_EFF_VW3 12.2.2
APPS.FM_FORM_EFF_VW3·↳ GMD_RECIPES_B·↳ GMD_RECIPE_VALIDITY_RULES·↳ GMD_STATUS_B·Explore GMD module →
-
View: CM_CMPT_DTL_VW 12.2.2
View of TOTAL_COST
-
Table for Routing offsets used in Lead Time Calculations
-
View: GME_BATCH_HEADER_V1 12.1.1
This view is created to maintain backward compatibility for other dependent modules. Batch/FPO header.
APPS.GME_BATCH_HEADER_V1·↳ GME_BATCH_HEADER·Explore GME module →
-
Cost Component Details
-
Recipe-Effectivity Association Table
-
MRP Action messages.
-
Cost Component Details
-
View: CM_CMPT_DTL_VW 12.1.1
View of TOTAL_COST
-
View: GMF_FORM_EFF_VW 12.2.2
Internal helper view for Standard Cost Rollup
APPS.GMF_FORM_EFF_VW·↳ GMD_RECIPES_B·↳ GMD_RECIPE_VALIDITY_RULES·↳ GMD_STATUS_B·Explore GMF module →
-
MRP Action messages.
-
View: FM_FORM_EFF_VW3_OLD 12.2.2
Item Effectivity view
APPS.FM_FORM_EFF_VW3_OLD·↳ FND_PROFILE·↳ GMD_RECIPES_B·↳ GMD_RECIPE_CUSTOMERS·Explore GMD module →
-
View: FM_FORM_EFF_VW3_OLD 12.1.1
Item Effectivity view
APPS.FM_FORM_EFF_VW3_OLD·↳ FND_PROFILE·↳ GMD_RECIPES_B·↳ GMD_RECIPE_CUSTOMERS·Explore GMD module →
-
View: GMF_FORM_EFF_VW 12.1.1
Internal helper view for Standard Cost Rollup
APPS.GMF_FORM_EFF_VW·↳ GMD_RECIPES_B·↳ GMD_RECIPE_VALIDITY_RULES·↳ GMD_STATUS_B·Explore GMF module →
-
View: GME_BATCH_HEADER_V1 12.2.2
This view is created to maintain backward compatibility for other dependent modules. Batch/FPO header.
APPS.GME_BATCH_HEADER_V1·↳ GME_BATCH_HEADER·Explore GME module →
-
VIEW: GMP.MR_ACTN_TBL# 12.2.2
-
VIEW: GMP.GMP_FORM_EFF# 12.2.2
-
TABLE: GMD.FM_FORM_EFF_BAK 12.1.1
-
VIEW: APPS.CM_CMPT_DTL_VW 12.1.1
-
VIEW: GMD.FM_FORM_EFF_BAK# 12.2.2
-
VIEW: GMF.GL_ITEM_CST# 12.2.2
-
VIEW: APPS.FM_FORM_EFF_VW1 12.2.2
-
VIEW: GME.PM_BTCH_HDR_BAK# 12.2.2
-
TABLE: GMD.FM_FORM_EFF_BAK 12.2.2
-
VIEW: GMD.FM_FORM_EFF_BAK# 12.2.2
-
VIEW: GMP.GMP_FORM_EFF# 12.2.2
-
VIEW: GMP.MR_ACTN_TBL# 12.2.2
-
VIEW: APPS.FM_FORM_EFF_VW1 12.1.1
-
VIEW: GMF.CM_CMPT_DTL# 12.2.2
-
VIEW: APPS.FM_FORM_EFF_VW1 12.1.1