Results for “schedule_method”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

APPS.GME_CONVERT_FPO_PVT is a private PL/SQL package within the Oracle EBS Process Manufacturing (OPM/GME) module that supports the conversion of Flow Production Orders (FPOs) into discrete batches in the GME_BATCH_HEADER structure. The package is defined with AUTHID CURRENT_USER and is classified as a PVT (private) API, meaning it is intended for internal use by the EBS application rather than as a public integration interface. Its core responsibility is to take forecast or planned FPO records, apply recipe validity rules and lead-time calculations, generate pre-batch header records, and ultimately create executable batch records complete with material details, resource transactions, and inventory transaction staging data.

The package exposes several PL/SQL record and collection types that define its internal data contracts, including pregen_fpo_row, error_return_sts, validity_rule_row, fpo_material_details_tab, generated_pre_batch_tab, recipe_validity_rule_tab, and return_array_sts. Notably, the pregen_fpo_row record carries a validity_rule_id attribute typed against gmd_recipe_validity_rules.recipe_validity_rule_id, which is central to the recipe-validity resolution logic and explains why a search for "validity_rule_id" surfaces this package.

Key Procedures and Functions

• VALIDATION — Validates input FPO parameters and prerequisites before conversion proceeds, returning a status indicator.
• RETRIEVE_FPO_DATA — Fetches the source FPO records and associated planning data required for conversion.
• CALCULATE_LEADTIME — Computes fixed, variable, and total lead times used to derive planned batch start and completion dates.
• GENERATE_PRE_BATCH_HEADER_RECS — Builds preliminary batch header records (the generated_pre_batch_tab) prior to persistence.
• CONVERT_FPO_TO_BATCH — Performs the actual transformation of an FPO into a batch, populating batch header and material detail records.
• CONVERT_FPO_MAIN — Orchestrates the end-to-end conversion flow by coordinating validation, retrieval, calculation, generation, and persistence steps.
• UPDATE_ORIGINAL_FPO — Updates the originating FPO to reflect the quantities and status resulting from the conversion.

Tables Accessed

The package reads and writes several core OPM and inventory tables through APPS synonyms:

• GMD_RECIPE_VALIDITY_RULES — Source of recipe validity rules; supplies recipe_validity_rule_id used to link recipes to producing batches.
• GME_BATCH_HEADER — Target table for created batch headers, including planning dates and plant codes.
• GME_MATERIAL_DETAILS — Stores material lines, planned quantities, UOMs, and assigned/unassigned quantities for generated batches.
• MTL_SYSTEM_ITEMS, MTL_SYSTEM_ITEMS_B, MTL_SYSTEM_ITEMS_KFV — Item master lookups for item descriptions, primary UOMs, and key flexfield value retrieval.
• GME_INVENTORY_TXNS_GTMP, GME_RESOURCE_TXNS_GTMP — Global temporary tables staging inventory and resource transactions generated during conversion.
• PLITBLM — Standard EBS PL/SQL index-by table helper used for list processing.

Usage Notes

Because GME_CONVERT_FPO_PVT is classified as a private API and is referenced by one other package, it is normally invoked indirectly through higher-level OPM conversion logic rather than directly by end users. In practice, it is called by the FPO-to-batch conversion concurrent program or an internal wrapper package during process execution planning. Custom code should avoid calling private APIs directly, as signatures and behavior are subject to change across patch levels. When troubleshooting validity_rule_id-related issues, this package is a relevant checkpoint because it resolves and propagates the recipe validity rule identifier into the batch creation flow.