Search Results g_context

Overview

GMF_MIGRATION is a migration utility package body owned by APPS and shipped with Oracle E-Business Suite releases 12.1.1 and 12.2.2. It supports the Process Manufacturing (OPM) to Discrete Manufacturing migration path, performing the data transformation work required to align OPM master and transactional data with the Oracle Inventory, Order Management, Bills of Material, and Cost Management models. The package provides two broad categories of functionality: lookup helper functions that resolve legacy OPM identifiers into their Oracle Applications counterparts (inventory items, accounts, legal entities, customers, vendors, order and transaction types, and cost elements), and migration drivers that populate fiscal policy, cost method, and lot cost method configuration. The header comment embedded in the source ("$Header: gmfmigrb.pls 120.48 2006/12/16 ...") confirms the package is an established seed utility rather than a customer-specific object.

Key Procedures and Functions

The package exposes 48 documented procedures and functions. The lookup family includes GET_ACCOUNT_ID, GET_CO_CODE, GET_INVENTORY_ITEM_ID, GET_LEGAL_ENTITY_ID, GET_ITEM_NUMBER, GET_CUSTOMER_NO, GET_VENDOR_NO, GET_REASON_ID, GET_ROUTING_NO, GET_PRICE_ELEMENT_TYPE_ID, GET_COST_CMPNTCLS_CODE, GET_ORDER_TYPE_CODE, GET_LINE_TYPE_CODE, GET_AR_TRX_TYPE_CODE, GET_GL_BUSINESS_CLASS_CAT, and GET_GL_PRODUCT_LINE_CAT. Each accepts a legacy OPM key and returns the corresponding Oracle Applications identifier or code used during conversion.

The migration driver family comprises MIGRATE_FISCAL_POLICIES_LE, MIGRATE_FISCAL_POLICIES_OTHERS, MIGRATE_COST_METHODS, and MIGRATE_LOT_COST_METHODS. These routines move fiscal calendar and cost method definitions from the OPM costing model into the Oracle Cost Management and Inventory structures required after migration. Notably, GET_INVENTORY_ITEM_ID is implemented as an internal function that queries IC_ITEM_MST_B_MIG for a non-null inventory_item_id and raises NO_DATA_FOUND when no mapped row exists; error conditions are recorded through GMA_COMMON_LOGGING.gma_migration_central_log using the package-level globals G_migration_run_id, G_table_name, and G_context.

Tables Accessed

Documented table references are drawn through APPS synonyms and are dominated by Cost Management tables: CM_ACPR_CTL, CM_ACST_LED, CM_ADJS_DTL, CM_BRDN_DTL, CM_CLDR_DTL, CM_CLDR_HDR_B, CM_CMPT_DTL, CM_CMPT_MST, CM_CMPT_MTL, CM_CUPD_CTL, CM_MTHD_MST, CM_RLUP_CTL, CM_RLUP_ITM, CM_RSRC_DTL, and CM_SCST_LED. These support cost adjustment, standard and actual cost ledgers, burden and resource detail, cost component masters and details, rollup control and item rollups, and cost method masters. The lookup functions additionally reference the OPM migration staging table IC_ITEM_MST_B_MIG to derive inventory item identifiers.

Usage Notes

GMF_MIGRATION is normally invoked by the OPM-to-Discrete migration concurrent programs and by the migration forms that drive them; it is not intended for ad hoc or interactive SQL execution. The GET_INVENTORY_ITEM_ID function is the canonical pattern for callers: pass an OPM item_id and receive the Inventory item_id, with failures logged centrally by GMA_COMMON_LOGGING against the current migration run. Custom extensions should follow the same convention, registering a run identifier and context via G_migration_run_id and G_context so that logging records remain complete. Because the package body is seeded and version-stamped, modifications should be made through a supported patching mechanism rather than direct edits. Referenced by one other package, it forms a low-level dependency within the migration stack and should be re-validated after any upgrade between 12.1.1 and 12.2.2.