GMF Tables (143)
GMF - Process Manufacturing Financials — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.
| Table | Columns | Description |
|---|---|---|
CM_ACER_MSG |
13 | The Actual Cost Process Error Message Table will provide the user a list of inconsistencies found during the actual cost process. These erro |
CM_ACPR_CTL |
38 | The Actual Cost Process Control Table will allow the OPM user to communicate with the Actual Cost Process as it is running in the background |
CM_ACST_LED |
35 | Actual Costing Ledger Table. The purpose of this table is to serve as a depository of all actual costing transactions. These transactions m |
CM_ACST_LED_EFC |
4 | Shadow table of CM_ACST_LED for EFC migration. Stores the original values of columns of CM_ACST_LED that are to be converted tothe Euro cu |
CM_ADJS_DTL |
65 | The Actual Cost Adjustments Details table - contains the adjustments details required and entered for cost adjustments. |
CM_ADJS_DTL_EFC |
10 | Shadow table of CM_ACST_LED for EFC migration. Stores the original values of columns of CM_ACST_LED that are to be converted tothe Euro cu |
CM_ALPR_CTL |
14 | Cost Allocation Process Control Table - Contains the process information such as Fiscal Year and Period, Costing Calendar and Period. |
CM_ALYS_MST |
10 | Cost Analysis Code Master Table. |
CM_APCM_INT |
37 | Interface Table that contains the invoice price information brought over from Oracle Financials. The information captured within this table |
CM_APCM_MST |
37 | Invoice Interface master table for Costing - contains the invoice price information brought over from Oracle Financials. Data is first brou |
CM_APCM_MST_EFC |
12 | Shadow table of CM_APCM_MST for EFC migration. Stores the original values of columns of CM_APCM_DTL that are to be converted to the Euro cu |
CM_BRDN_DTL |
36 | Cost Burden Details - contains the Burden (Overhead) costs applied to an item |
CM_BTCH_SUM |
13 | Obsolete |
CM_CLDR_DTL |
18 | Costing Calendar Details |
CM_CLDR_HDR_B |
44 | Costing Calendar Header Table |
CM_CLDR_HDR_TL |
9 | Table to store translated columns of Cost Calendar Header Table |
CM_CMPT_DTL |
67 | Cost Component Details |
CM_CMPT_DTL_EFC |
3 | Shadow table of CM_CMPT_DTL for EFC migration. Stores the original values of columns of CM_CMPT_DTL that are to be converted to the Euro cu |
CM_CMPT_GRP |
10 | Cost component Groups |
CM_CMPT_MST_B |
49 | Cost Component Master |
CM_CMPT_MST_TL |
9 | Table to store translated columns for Cost Component Master Table |
CM_CMPT_MTL |
22 | This table contains the item or item cost class specific material cost component and material analysis code. Used by the Actual Cost Proces |
CM_CUPD_CTL |
33 | Cost Update Process Control Table - allows the OPM user to communicate with the Cost Update Process as it is running in the background . Usi |
CM_CUPD_MSG |
13 | Cost Update process error messages table - error messages found during the process. No duplicate error messages are written. These error m |
CM_MTHD_MST |
19 | Item Cost Methods - Cost methods are defined by the user. Cost calculation types for raw material and product costs are also specified for |
CM_OPRN_SUM |
18 | Obsolete |
CM_REAS_CDS |
11 | Cost Adjustments Reason Codes - Reason Codes will allow the user to define specific codes to record the reason for making the adjustment. T |
CM_RLUP_CTL |
46 | Cost Rollup Process Control Table - allows the OPM user to communicate with the Cost Rollup Process as it is running in the background . Usi |
CM_RLUP_ITM |
10 | Contains the list of items for which Cost Rollup is to be run. Will have rows only for those rollup runs that are submitted as List of Item |
CM_RLUP_MSG |
13 | The Cost Rollup Process Error Message Table will provide the user a list of inconsistencies found during the process. These error messages w |
CM_RSRC_DTL |
21 | Resource Costs |
CM_RSRC_DTL_EFC |
7 | Shadow table of CM_RSRC_DTL for EFC migration. Stores the original values of columns of CM_RSRC_DTL that are to be converted to the Euro cu |
CM_SCST_LED |
34 | Standard Costs Ledger. Rows are created during the cost rollup process. It serves the purpose of a ledger on the performed cost calculation |
CM_SCST_LED_EFC |
4 | Shadow table of CM_SCST_DTL for EFC migration. Stores the original values of columns of CM_SCST_DTL that are to be converted to the Euro cu |
CM_TEXT_HDR |
6 | Header information for Text entered through Edit Text option |
CM_TEXT_TBL_TL |
13 | Costing Translation Text Table. |
CM_WHSE_ASC |
14 | The Costing Warehouse Association Table - allows the OPM user to build an association between costing and inventory warehouses. |
CM_WHSE_EFF |
17 | Costing Warehouse Effectivities. Used by Cost Rollup Process |
CM_WHSE_SRC |
23 | Costing Source Warehouses - Used by Rollup process |
GL_ACCT_CLS |
10 | User-defined Account classes. These classes are used to classify accounts and are used for reporting purposes only. Note that this table is |
GL_ACCT_HRC |
33 | This table contains the account selection priority for the companies and the account titles. These priorities are used by the GL Mapping pro |
GL_ACCT_KEY |
22 | *NOT USED* |
GL_ACCT_MAP |
68 | GL Account Mapping information - contains the GL Account Mapping info. The Account mappings are defined for a Company, Account Title and at |
GL_ACCT_MST |
21 | Contains the Company specific Chart of Accounts. Note that in the Oracle Financials integrated setup this table is populated with Oracle Fin |
GL_ACCT_TTL |
11 | This table contains the system defined Account Titles. User is not allowed to change them in OPM. |
GL_ACCT_TYP |
12 | This table consists of four pre-defined General Ledger account types which are used to classify accounts into four broad categories. This ta |
GL_ACCT_USG |
10 | This table contains the user-defined Acount Usages. These codes are used for reporting purposes only. This table is not used with Oracle Fin |
GL_ACCT_VAL |
12 | This table contains validation codes assignment to Accounts. The Accounts may only be auto-generated with the Accounting unit with same Vali |
GL_ACCU_MAP |
45 | This table contains the GL Account Unit Mapping information. The Account Unit mapping are defined for a Company, Organization and Warehouse |
GL_ACCU_MST |
14 | This table contains the User-defined Accounting Units. Accounting units are Organizational units of a company such as cost centers, departme |
GL_ACCU_VAL |
12 | This table contains validation codes assignment to Account Units. The Accounting unit may only be auto-generated with the Accounts with same |
GL_ALOC_BAS |
24 | This table contains the basis information for an allocation code about the items to which expenses will be allocated, the allocation criteri |
GL_ALOC_DTL |
25 | This table contains the result of the allocation processing. The Actual Costing Process will use this table to determine the expense allocat |
GL_ALOC_DTL_EFC |
6 | Shadow table of GL_ALOC_DTL for EFC migration. Stores the original values of columns of GL_ALOC_DTL that are to be converted to the Euro cu |
GL_ALOC_EXP |
18 | This table contains the expense to allocate information for an allocation code. The data from this table is used for GL expense allocation p |
GL_ALOC_INP |
20 | This table contains the expense and basis amount computed during the allocation processing. Currently these values are being brought over fr |
GL_ALOC_INP_EFC |
3 | Shadow table of GL_ALOC_INP for EFC migration. Stores the original values of columns of GL_ALOC_INP that are to be converted to the Euro c |
GL_ALOC_MST |
44 | Master table to store the definition of the allocation codes. |
GL_CLDR_DTL |
17 | This table contains the period defination for Fiscal year. This table is not used with Oracle Financials integrated setup. |
GL_CLDR_HDR |
15 | This table contains the Fiscal Year defination for a Company. This table is not used with Oracle Financials integrated setup. |
GL_CURR_MST |
18 | This table contains the Currency definitions. Note that with Oracle Financials integration this table is populated with the Currency data fr |
GL_CURR_MST_INT |
13 | This is an interface table for synchronizing Currencies from Oracle Financials to OPM. |
GL_EVNT_MST |
12 | This table contains the pre-defined Event codes. An event is any activity within OPM that has a financial impact. |
GL_EVNT_MST_TEMP |
4 | An internal table used by GL Update process to improve performance |
GL_EVNT_PLC |
21 | Event specific Company Fiscal Policy information |
GL_EXPN_CDS_TMP |
5 | Temporary table used for performance improvment in cost allocation process. This table is populated with values from GL_CODE_COMBINATIONS t |
GL_ITEM_CST |
28 | Item costs for transactions. Maintains accounting and current costs. Component cost details are available in GL_ITEM_DTL table. |
GL_ITEM_CST_EFC |
3 | Shadow table of GL_ITEM_CST for EFC migration. Stores the original values of columns of GL_ITEM_CST that are to be converted to the Euro cu |
GL_ITEM_DTL |
15 | Cost component detail information for the item. Component details for the Accounting cost available in GL_ITEM_CST table. |
GL_ITEM_DTL_EFC |
5 | Shadow table of GL_ITEM_DTL for EFC migration. Stores the original values of columns of GL_ITEM_DTL that are to be converted to the Euro cu |
GL_LDGR_MST |
10 | GL ledgers |
GL_LEDG_MAP |
12 | GL ledger mapping. Used for GL mapping. |
GL_MEMO_STA |
3 | Internal Table used by AR Update process |
GL_MESG_TBL |
13 | General ledger messages table. Messages generated during transaction posting by Subsidiary Ledger Update process. |
GL_PLCY_LGR |
10 | Company ledgers |
GL_PLCY_MST |
69 | Fiscal policy of a company. Fiscal policy defines the GL attributes of the company. |
GL_PLCY_MST_EFC |
3 | Shadow table of GL_PLCY_MST for EFC migration. Stores the original values of columns of GL_PLCY_MST that are to be converted to the Euro cu |
GL_PLCY_SEG |
16 | Segments for account key segregation. Stores the Chart of Accounts. |
GL_PLCY_SYS |
10 | Fiscal policy sub-systems |
GL_RATE_TYP |
15 | Exchange rate Classification such as daily, average, bal sheet. |
GL_RATE_TYP_INT |
12 | Exchange Rate Type Interface. Used for synchronzing rate types from Oracle Financials. |
GL_SETU_ERR |
11 | GL mapping setup errors found during Subsidiary Ledger Update process. Not currently used. |
GL_SEVT_MST |
12 | GL mapping subevents. OPM user is not allowed to modify this information. |
GL_SEVT_TTL |
14 | GL mapping subevent account titles. Account titles that are impacted by a subsystem subevent. |
GL_SRCE_MST |
12 | Subsystem master table |
GL_SUBR_LED |
44 | GL subsidiary ledger. Liaison between subsystems and GL. Stores all the bookings of OPM subsystem transactions (documents). Updated by th |
GL_SUBR_LED_EFC |
5 | Shadow table of GL_SUBR_LED for EFC migration. Stores the original values of columns of GL_SUBR_LED that are to be converted to the Euro cu |
GL_SUBR_LED_VAR |
25 | Table for storing all types of batch close variances calculated during actual subledger run. |
GL_SUBR_STA |
79 | OPM Subsidiary Ledger Update process Control table |
GL_SUBR_TST |
44 | Subsidiary ledger test run work table. Used to run Subledger Update process in test mode to verify the bookings before running a live Updat |
GL_SUBR_TST_EFC |
5 | Shadow table of GL_SUBR_TST for EFC migration. Stores the original values of columns of GL_SUBR_TST that are to be converted to the Euro cu |
GL_SUBR_TST_VAR |
25 | Table for storing all types of batch close variances calculated during test subledger run. |
GL_TEXT_HDR |
6 | Table used to store text types for GL |
GL_TEXT_TBL_TL |
13 | GL Module Text Lines. Descriptive text for all tables in this module. |
GL_UPDT_CTL |
42 | The control table for OPM GL Update Process. Only used with OPM integrated with Oracle Financials. |
GL_UPDT_MSG |
13 | OPM GL Update process error messages table. Only used with OPM integrated with Oracle Financials. |
GL_VALN_CDS |
10 | Validation codes for account key auto-generation. |
GL_XCHG_RTE |
18 | Exchange rates |
GMF_BATCH_REQUIREMENTS |
20 | Batch Requirements |
GMF_BATCH_REQUIREMENTS_GTMP |
20 | |
GMF_BATCH_VIB_DETAILS |
15 | Batch VIB Details |
GMF_BURDEN_ASSOCIATION |
12 | In OPM Costing, this table is where the Percentage Burden Associations are stored. |
GMF_BURDEN_CODES |
27 | In OPM Costing, this is where the Percentage Burden Codes are stored. |
GMF_BURDEN_PERCENTAGES |
31 | In OPM Costing, this is where the Burden Percentages are established. |
GMF_BURDEN_PRIORITIES |
18 | In OPM Costing, this is where the Percentage Burden Priorities are established. |
GMF_CALENDAR_ASSIGNMENTS |
42 | Cost Calendar Assignments |
GMF_COST_METHOD_LEVEL |
8 | Table of all cost methods that cost items at the summary level |
GMF_FISCAL_POLICIES |
48 | Fiscal Policies Table |
GMF_INCOMING_MATERIAL_LAYERS |
18 | Incoming Material Layers |
GMF_INVOICE_DISTRIBUTIONS |
42 | Supplementary table to store invoice variance amounts for Actual Costing |
GMF_INV_TXN_FLAGS_GT |
3 | |
GMF_ITEM_GROUPS |
9 | Stores the grouping of items (representative vs represented) for Summary Level costing |
GMF_LAYER_COST_DETAILS |
14 | Layer Cost Details |
GMF_LC_ACTUAL_COST_ADJS |
26 | This table used to store Actual Landed cost adjustments which are processed by actual cost process for actual cost types |
GMF_LC_ADJ_TRANSACTIONS |
51 | This table used to store Estimated and Actual Landed Cost adjustments. This table will be populated in Landed cost adjustment import process |
GMF_LC_LOT_COST_ADJS |
28 | This table used to store Actual Landed cost adjustments which are processed by Lot cost process |
GMF_LEDGER_VALUATION_METHODS |
41 | This table contains valuation cost type of the secondary ledgers associated to the primary ledger of the Legal Entity. With SLA it is possib |
GMF_LOT_COSTED_ITEMS |
50 | Lot cost enabled items |
GMF_LOT_COSTED_ITEMS_GT |
3 | This table stores all items flaged as lot costed |
GMF_LOT_COSTS |
60 | OPM Lot Costs Header Table |
GMF_LOT_COST_ADJUSTMENTS |
60 | OPM Lot Cost Adjustments header table |
GMF_LOT_COST_ADJUSTMENT_DTLS |
12 | OPM Lot Cost Adjustments details table |
GMF_LOT_COST_BURDENS |
67 | Burden details for lot costed items |
GMF_LOT_COST_DETAILS |
52 | Lot Cost details table |
GMF_MATERIAL_LOT_COST_TXNS |
61 | Transaction history table for lot costs |
GMF_OUTGOING_MATERIAL_LAYERS |
14 | Consumption Material Layers |
GMF_PERIOD_BALANCES |
25 | Period Inventory Balances for Process Orgs |
GMF_PERIOD_BALANCES_GT |
14 | Temporary table for Period Inventory Balances for Process Orgs |
GMF_PERIOD_STATUSES |
46 | Cost Period statuses for a Legal Entity & Cost Type |
GMF_PERIOD_STATUSES_GT |
16 | Global temporary table gmf_period_statuses_gt with on commit delete rows |
GMF_PROCESS_ORGANIZATIONS_GT |
6 | This table stores process organizations for temporary session |
GMF_RCV_ACCOUNTING_TXNS |
54 | This table stores information for receiving accounting for process organizations |
GMF_RESOURCE_LAYERS |
11 | Consumption Resource Layers |
GMF_TRANSACTION_VALUATION |
46 | Transaction Valuation table for process organizations |
GMF_XLA_EVENT_MODEL |
20 | This is a helper table for Accounting Pre-Processor. This table stores the Subledger Accounting event model names that is used by the pre-p |
GMF_XLA_EXTRACT_HEADERS |
53 | This table is the SLA Extract Headers table. The transactions for process inventory organizations are processed and all the necessary data |
GMF_XLA_EXTRACT_HEADERS_GT |
50 | Stores extract headers temporarily in a Session to create events in SLA. Once events get created, rows from this table are inserted into GMF |
GMF_XLA_EXTRACT_LINES |
36 | This table is the SLA Extract Lines table. The transactions for process inventory organizations are processed and all the necessary data fo |
GMF_XLA_EXTRACT_LINES_GT |
26 | Stores extract lines temporarily in a Session to create events in SLA. Once events get created, rows from this table are inserted into GMF_X |
GMF_XLA_ITEMS_GT |
3 | This table is only used in GMF Accounting Pre-Processor to store item location in the struct. Done to improve performance. |
SY_EXCP_TBL |
17 | Contains the errors generated by OPM GL Synchronization process for invalid data. The exception report runs off this table. |
SY_SOFT_DTL |
26 | Defines tables(sources) and their attributes for use in supporting a given Third-Party integration. |
SY_SOFT_MST |
9 | Defines Third-Party software which has a supported interface to OPM. |