OPM Financials Tables

OPM Financials Tables:

TABLE NAME     DESCRIPTION
CM_ACER_MSG     The Actual Cost Process Error Message Table will provide the user a list of inconsistencies found during the actual cost process. These error messages will be used by the OPM  user to evaluate performance and accuracy of the process and if
CM_ACPR_CTL     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 . Using this table, the user may also review past runs and also if necessary force the process to a
CM_ACST_LED     Actual Costing Ledger Table. The purpose of this table is to serve as a depository of all actual costing transactions.  These transactions may originate from Production Batch details (pm_matl_dtl) or POC resource details (pm_oprn_dtl) or Pu
CM_ACST_LED_EFC     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 currency as a part of EFC migration.  The table consists of the primary key columns of CM_ACST_LED and
CM_ADJS_DTL     The Actual Cost Adjustments Details table -  contains the adjustments details required and entered for cost adjustments.
CM_ADJS_DTL_EFC     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 currency as a part of EFC migration.  The table consists of the primary key columns of CM_ACST_LED and
CM_ALPR_CTL     Cost Allocation Process Control Table - Contains the process information such as Fiscal Year and Period, Costing Calendar and Period.
CM_ALYS_MST     Cost Analysis Code Master Table.
CM_APCM_INT     Interface Table that contains the invoice price information brought over from Oracle Financials. The information captured within this table is then downloaded to cm_apcm_mst table which is used by the actual costing engine to determine the
CM_APCM_MST     Invoice Interface master table for Costing - contains the invoice price information brought over from Oracle Financials.  Data is first brought over to cm_apcm_int and then after validation written to this table.   This information is used
CM_APCM_MST_EFC     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 currency as a part of EFC migration.  The table consists of the primary key columns of CM_APCM_DTL and
CM_BRDN_DTL     Cost Burden Details - contains the Burden (Overhead) costs applied to an item
CM_BTCH_SUM     Obsolete
CM_CLDR_DTL     Costing Calendar Details
CM_CLDR_HDR     Costing Calendar Header Table
CM_CLDR_HDR_B     Costing Calendar Header Table
CM_CLDR_HDR_TL     Table to store translated columns of Cost Calendar Header Table
CM_CMPT_DTL     Cost Component Details
CM_CMPT_DTL_EFC     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 currency as a part of EFC migration.  The table consists of the primary key columns of CM_CMPT_DTL and
CM_CMPT_GRP     Cost component Groups
CM_CMPT_MST     Cost Component Master
CM_CMPT_MST_B     Cost Component Master
CM_CMPT_MST_TL     Table to store translated columns for Cost Component Master Table
CM_CMPT_MTL     This table contains the item or item cost class specific material cost component and material analysis code.  Used by the Actual Cost Process.
CM_CUPD_CTL     Cost Update Process Control Table - allows the OPM user to communicate with the Cost Update Process as it is running in the background . Using this table, the user may also review past runs and also if necessary force the process to abort.
CM_CUPD_MSG     Cost Update process error messages table - error messages found during the process.  No duplicate error messages are written.  These error messages will be used by the OPM user to evaluate performance and accuracy of the process and, if nec
CM_MTHD_MST     Item Cost Methods - Cost methods are defined by the user.  Cost calculation types  for raw material and product costs are also specified for Actual Costing Methods.
CM_OPRN_SUM     Obsolete
CM_REAS_CDS     Cost Adjustments Reason Codes -  Reason Codes will allow the user to define specific codes to record the reason for making the adjustment. These codes will be user defined.
CM_RLUP_CTL     Cost Rollup Process Control Table - allows the OPM user to communicate with the Cost Rollup Process as it is running in the background . Using this table, the user may also review past runs and also if necessary force the process to abort.
CM_RLUP_ITM     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 Items Rollup.Regarding removal of delete_mark column between 4.1 and 11.0 releases. - OPM only selects o
CM_RLUP_MSG     The Cost Rollup Process Error Message Table will provide the user a list of inconsistencies found during the process. These error messages will be used by the OPM user to evaluate performance and accuracy of the process and, if necessary, t
CM_RSRC_DTL     Resource Costs
CM_RSRC_DTL_EFC     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 currency as a part of EFC migration.  The table consists of the primary key columns of CM_RSRC_DTL and
CM_SCST_LED     Standard Costs Ledger.  Rows are created during the cost rollup process. It serves the purpose of a ledger on the performed cost calculations of each product. Formula and routing information is maintained within this table.  Has a detailed
CM_SCST_LED_EFC     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 currency as a part of EFC migration.  The table consists of the primary key columns of CM_SCST_DTL and
CM_TEXT_HDR     Header information for Text entered through Edit Text option
CM_TEXT_TBL_TL     Costing Translation Text Table.
CM_WHSE_ASC     The Costing Warehouse Association Table - allows the OPM user to build an association between costing and inventory warehouses.
CM_WHSE_EFF     Costing Warehouse Effectivities.  Used by Cost Rollup Process
CM_WHSE_SRC     Costing Source Warehouses - Used by Rollup process
GL_ACCT_CLS     User-defined Account classes. These classes are used to classify accounts and are used for reporting purposes only. Note that this table is not used under Oracle Financials Integrated setup.
GL_ACCT_HRC     This table contains the account selection priority for the companies and the account titles. These priorities are used by the GL Mapping program to retrieve the accounts for sub-ledger posting, in the order of account selection priority. In
GL_ACCT_KEY     *NOT USED*
GL_ACCT_MAP     GL Account Mapping information - contains the GL Account Mapping info. The Account mappings are defined for a Company,  Account Title and attributes whose priority is >0 in gl_acct_hrc table. Note that these attributes are optional and a NU
GL_ACCT_MST     Contains the Company specific Chart of Accounts. Note that in the Oracle Financials integrated setup this table is populated with Oracle Financials Accounts while entering the Account Mapping information.
GL_ACCT_TTL     This table contains the system defined Account Titles.  User is not allowed to change them in OPM.
GL_ACCT_TYP     This table consists of four pre-defined General Ledger account types which are used to classify accounts into four broad categories. This table is not used with Oracle Financials integrated setup.
GL_ACCT_USG     This table contains the user-defined Acount Usages. These codes are used for reporting purposes only. This table is not used with Oracle Financials integrated setup.
GL_ACCT_VAL     This table contains validation codes assignment to Accounts. The Accounts may only be auto-generated with the Accounting unit with same Validation codes. This table is not used with Oracle Financials integrated setup.
GL_ACCU_MAP     This table contains the GL Account Unit Mapping information. The Account Unit mapping are defined for a Company,  Organization and Warehouse. Organization and Warehouse are optional and a blank value means all value. The GL Mapping program
GL_ACCU_MST     This table contains the User-defined Accounting Units. Accounting units are Organizational units of a company such as cost centers, departments, and divisions, to be included in an Account key.  Note that with Oracle Financial integration,
GL_ACCU_VAL     This table contains validation codes assignment to Account Units. The Accounting unit may only be auto-generated with the Accounts with same Validation codes. This table is not used with Oracle Financials integrated setup.
GL_ALOC_BAS     This table contains the basis information for an allocation code about the items to which expenses will be allocated, the allocation criteria based upon the basis account or fixed percent, and the cost component class bucket to which the al
GL_ALOC_DTL     This table contains the result of the allocation processing. The Actual Costing Process will use this table to determine the expense allocation for the items.
GL_ALOC_DTL_EFC     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 currency as a part of EFC migration.  The table consists of the primary key columns of GL_ALOC_DTL and
GL_ALOC_EXP     This table contains the expense to allocate information for an allocation code. The data from this table is used for GL expense allocation processing in determining total expense to allocate.
GL_ALOC_INP     This table contains the expense and basis amount computed during the allocation processing. Currently these values are being brought over from Oracle Financials and the user has the option to maintain them via a maintenance screen.
GL_ALOC_INP_EFC     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 currency as a part of EFC migration.  The table consists of the primary key columns of GL_ALOC_INP an
GL_ALOC_MST     Master table to store the definition of the allocation codes.
GL_CLDR_DTL     This table contains the period defination for Fiscal year. This table is not used with Oracle Financials integrated setup.
GL_CLDR_HDR     This table contains the Fiscal Year defination for a Company. This table is not used with Oracle Financials integrated setup.
GL_CURR_MST     This table contains the Currency definitions. Note that with Oracle Financials integration this table is populated with the Currency data from Oracle Financials.
GL_CURR_MST_INT     This is an interface table for synchronizing Currencies from Oracle Financials to OPM.
GL_EVNT_MST     This table contains the pre-defined Event codes. An event is any activity within OPM that has a financial impact.
GL_EVNT_MST_TEMP     An internal table used by GL Update process to improve performance
GL_EVNT_PLC     Event specific Company Fiscal Policy information
GL_EXPN_CDS_TMP     Temporary table used for performance improvment in cost allocation process.  This table is populated with values from GL_CODE_COMBINATIONS table.
GL_ITEM_CST     Item costs for transactions.  Maintains accounting and current costs.  Component cost details are available in GL_ITEM_DTL table.
GL_ITEM_CST_EFC     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 currency as a part of EFC migration.  The table consists of the primary key columns of GL_ITEM_CST and
GL_ITEM_DTL     Cost component detail information for the item.  Component details for the Accounting cost available in GL_ITEM_CST table.
GL_ITEM_DTL_EFC     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 currency as a part of EFC migration.  The table consists of the primary key columns of GL_ITEM_DTL and
GL_LDGR_MST     GL ledgers
GL_LEDG_MAP     GL ledger mapping.  Used for GL mapping.
GL_MEMO_STA     Internal Table used by AR Update process
GL_MESG_TBL     General ledger messages table.  Messages generated during transaction posting by Subsidiary Ledger Update process.
GL_PLCY_LGR     Company ledgers
GL_PLCY_MST     Fiscal policy of a company.  Fiscal policy defines the GL attributes of the company.
GL_PLCY_MST_EFC     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 currency as a part of EFC migration.  The table consists of the primary key columns of GL_PLCY_MST and
GL_PLCY_SEG     Segments for account key segregation.  Stores the Chart of Accounts.
GL_PLCY_SYS     Fiscal policy sub-systems
GL_RATE_TYP     Exchange rate Classification such as daily, average, bal sheet.
GL_RATE_TYP_INT     Exchange Rate Type Interface.  Used for synchronzing rate types from Oracle Financials.
GL_SETU_ERR     GL mapping setup errors found during Subsidiary Ledger Update process.  Not currently used.
GL_SEVT_MST     GL mapping subevents.  OPM user is not allowed to modify this information.
GL_SEVT_TTL     GL mapping subevent account titles.  Account titles that are impacted by a subsystem subevent.
GL_SRCE_MST     Subsystem master table
GL_SUBR_LED     GL subsidiary ledger.  Liaison between subsystems and GL.  Stores all the bookings of OPM subsystem transactions (documents).  Updated by the OPM Subsidiary Ledger Update process.
GL_SUBR_LED_EFC     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 currency as a part of EFC migration.  The table consists of the primary key columns of GL_SUBR_LED and
GL_SUBR_LED_VAR     Table for storing all types of batch close variances calculated during actual subledger run.
GL_SUBR_STA     OPM Subsidiary Ledger Update process Control table
GL_SUBR_TST     Subsidiary ledger test run work table.  Used to run Subledger Update process in test mode to verify the bookings before running a live Update.
GL_SUBR_TST_EFC     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 currency as a part of EFC migration.  The table consists of the primary key columns of GL_SUBR_TST and
GL_SUBR_TST_VAR     Table for storing all types of batch close variances calculated during test subledger run.
GL_TEXT_HDR     Table used to store text types for GL
GL_TEXT_TBL_TL     GL Module Text Lines. Descriptive text for all tables in this module.
GL_UPDT_CTL     The control table for OPM GL Update Process.  Only used with OPM integrated with Oracle Financials.
GL_UPDT_MSG     OPM GL Update process error messages table.  Only used with OPM integrated with Oracle Financials.
GL_VALN_CDS     Validation codes for account key auto-generation.
GL_XCHG_RTE     Exchange rates
GMF_BATCH_REQUIREMENTS     Batch  requirement details
GMF_BATCH_REQUIREMENTS_GTMP
GMF_BATCH_REQUIREMENTS_GTMP1
GMF_BATCH_VIB_DETAILS     Virtual incremental batch details
GMF_BURDEN_ASSOCIATION     In OPM Costing, this table is where the Percentage Burden Associations are stored.
GMF_BURDEN_CODES     In OPM Costing, this is where the Percentage Burden Codes are stored.
GMF_BURDEN_PERCENTAGES     In OPM Costing, this is where the Burden Percentages are established.
GMF_BURDEN_PRIORITIES     In OPM Costing, this is where the Percentage Burden Priorities are established.
GMF_CALENDAR_ASSIGNMENTS     Cost Calendar Assignments
GMF_COST_METHOD_LEVEL     Table of all cost methods that cost items at the summary level
GMF_FISCAL_POLICIES     Fiscal policy of legal entity. Fiscal policy defines the GL attributes of legal entity
GMF_INCOMING_MATERIAL_LAYERS     Layer data for consumption transactions
GMF_INV_TXN_FLAGS_GT     
GMF_INVOICE_DISTRIBUTIONS     Supplementary table to store invoice variance amounts for Actual Costing
GMF_ITEM_GROUPS     Stores the grouping of items (representative vs represented) for Summary Level costing
GMF_LAYER_COST_DETAILS     Layer Cost Details
GMF_LC_ACTUAL_COST_ADJS     This table used to store Actual Landed cost adjustments which are processed by actual cost proces for actual cost types
GMF_LC_ADJ_TRANSACTIONS     This table used to store Estimated and Actual Landed Cost adjustments. This table will be populated in Landed cost adjustment import process for each LC adjustment
GMF_LC_LOT_COST_ADJS     This table used to store Actual Landed cost adjustments which are processed by Lot cost process
GMF_LEDGER_VALUATION_METHODS     This table contains valuation cost type of the secondary ledgers associated to the primary ledger of the Legal Entity. With SLA it is possible to create the subledger journals in draft mode for multiple cost types for comparison and simulat
GMF_LOT_COST_ADJUSTMENT_DTLS     OPM Lot Cost Adjustments details table
GMF_LOT_COST_ADJUSTMENTS     OPM Lot Cost Adjustments header table
GMF_LOT_COST_BURDENS     Burden details for lot costed items
GMF_LOT_COST_DETAILS     Lot Cost details table
GMF_LOT_COSTED_ITEMS     Lot cost enabled items
GMF_LOT_COSTED_ITEMS_GT     This table stores all items flaged as lot costed
GMF_LOT_COSTS     OPM Lot Costs Header Table
GMF_MATERIAL_LOT_COST_TXNS     Transaction history table for lot costs
GMF_OUTGOING_MATERIAL_LAYERS     Layer data for the batch yield transactions.
GMF_PERIOD_BALANCES     Period Inventory Balances for Process Orgs
GMF_PERIOD_BALANCES_GT     Temporary table for Period Inventory Balances for Process Orgs
GMF_PERIOD_STATUSES     Cost Period statuses for a Legal Entity & Cost Type
GMF_PERIOD_STATUSES_GT     Global temporary table gmf_period_statuses_gt with on commit delete rows
GMF_PROCESS_ORGANIZATIONS_GT     This table stores process organizations for temporary session
GMF_RCV_ACCOUNTING_TXNS     This table stores information for receiving accounting for process organizations
GMF_RESOURCE_LAYERS     Consumption Resource Layers
GMF_TRANSACTION_VALUATION     Transaction Valuation table for process organizations
GMF_XLA_EVENT_MODEL     This is a helper table for Accounting Pre-Processor.  This table stores the Subledger Accounting event model names that is used by the pre-processor.
GMF_XLA_EXTRACT_HEADERS     This table is the SLA Extract Headers table.  The transactions for process inventory organizations are processed and all the necessary data for accounting are stored in this table.  When the SLA accounting program is run data from this tabl
GMF_XLA_EXTRACT_HEADERS_GT     Stores extract headers temporarily in a Session to create events in SLA. Once events get created, rows from this table are inserted into GMF_XLA_EXTRACT_HEADERS table.
GMF_XLA_EXTRACT_LINES     This table is the SLA Extract Lines table.  The transactions for process inventory organizations are processed and all the necessary data for accounting are stored in this table.  When the SLA accounting program is run data from this table
GMF_XLA_EXTRACT_LINES_GT     Stores extract lines temporarily in a Session to create events in SLA. Once events get created, rows from this table are inserted into GMF_XLA_EXTRACT_LINES table.
GMF_XLA_ITEMS_GT     This table is only used in GMF Accounting Pre-Processor to store item location in the struct. Done to improve performance.
SY_EXCP_TBL     Contains the errors generated by OPM GL Synchronization process for invalid data.  The exception report runs off this table.
SY_SOFT_DTL     Defines tables(sources) and their attributes for use in supporting a given Third-Party integration.
SY_SOFT_MST     Defines Third-Party software which has a supported interface to OPM.