Search Results get_line_type_code

Overview

GMF_MIGRATION is a PL/SQL package deployed in the APPS schema of Oracle E-Business Suite, classified under the ETRM taxonomy as an OTHER-type API. The package supports the Process Manufacturing (OPM) migration and conversion framework, providing the data-mapping and lookup services that translate legacy or external reference values into the surrogate identifiers and coded values used by the Oracle Process Manufacturing costing and inventory schemas. Its documented header (gmfmigrs.pls, version 120.16) declares a substantial set of global constants that define the canonical migration column names — LEGAL_ENTITY_ID, LEDGER_ID, ORGANIZATION_ID, SUBINVENTORY_CODE, INVENTORY_ITEM_ID, REASON_ID, CURRENCY_CODE, AQUI_COST_ID, RESOURCES, ORDER_TYPE, COST_CMPNTCLS_ID, COST_ANALYSIS_CODE, LINE_TYPE, AR_TRX_TYPE_ID, JOURNAL_LINE_TYPE, and the GL category columns — together with the mode, context, and migration run identifiers used to scope a conversion run. The package is therefore best understood as the shared resolution layer that other migration routines call when populating OPM costing tables.

Key Procedures and Functions

The package exposes 48 documented functions, of which the following are representative. Resolution functions convert a human-readable code into the corresponding internal identifier: GET_ACCOUNT_ID returns the account identifier for an account code combined with a company (CO) code; GET_CO_CODE resolves a warehouse code to a company code; GET_INVENTORY_ITEM_ID, GET_LEGAL_ENTITY_ID, GET_REASON_ID, GET_ROUTING_NO, GET_PRICE_ELEMENT_TYPE_ID, GET_CUSTOMER_NO, and GET_VENDOR_NO perform equivalent lookups against their respective master entities. Companion functions return descriptive values rather than identifiers: GET_ITEM_NUMBER, 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. The remaining documented procedures perform the migration work itself, including MIGRATE_FISCAL_POLICIES_LE and MIGRATE_FISCAL_POLICIES_OTHERS for fiscal policy conversion, and MIGRATE_COST_METHODS and MIGRATE_LOT_COST_METHODS for costing method setup. Parameter lists should be taken from the package specification; the only signatures visible in the header excerpt are those of GET_ACCOUNT_ID, Get_Co_Code, and GET_INVENTORY_ITEM_ID.

Tables Accessed

All table access is performed through APPS synonyms over the CM_ costing tables. The control and ledger tables — CM_ACPR_CTL, CM_ACST_LED, CM_CUPD_CTL, CM_RLUP_CTL, and CM_SCST_LED — hold acquisition cost processing controls, actual cost ledgers, cost update controls, rollup controls, and standard cost ledgers respectively, and are the primary targets of the costing migration routines. Detail and master tables — CM_ADJS_DTL, CM_BRDN_DTL, CM_CLDR_DTL, CM_CLDR_HDR_B, CM_CMPT_DTL, CM_CMPT_MST, CM_CMPT_MTL, CM_MTHD_MST, CM_RLUP_ITM, and CM_RSRC_DTL — supply adjustment, burden, calendar, component, cost method, rollup item, and resource detail used during conversion and validation.

Usage Notes

GMF_MIGRATION is invoked by migration concurrent programs and by other migration packages — the metadata records one package referencing it — rather than by end-user forms. Custom conversion scripts should call the resolution functions to obtain valid OPM identifiers before inserting into CM_ tables, and should respect the G_Mode, G_Migration_run_id, and G_Context globals to keep each run isolated and traceable.