Principais tabelas e views do Oracle OPM

Oracle Process Manufacturing Financials Tables:
TABLE NAMEDESCRIPTION
CM_ACER_MSGThe 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_CTLThe 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_LEDActual 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_EFCShadow 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_DTLThe Actual Cost Adjustments Details table – contains the adjustments details required and entered for cost adjustments.
CM_ADJS_DTL_EFCShadow 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_CTLCost Allocation Process Control Table – Contains the process information such as Fiscal Year and Period, Costing Calendar and Period.
CM_ALYS_MSTCost Analysis Code Master Table.
CM_APCM_INTInterface 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_MSTInvoice 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_EFCShadow 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_DTLCost Burden Details – contains the Burden (Overhead) costs applied to an item
CM_BTCH_SUMObsolete
CM_CLDR_DTLCosting Calendar Details
CM_CLDR_HDRCosting Calendar Header Table
CM_CLDR_HDR_BCosting Calendar Header Table
CM_CLDR_HDR_TLTable to store translated columns of Cost Calendar Header Table
CM_CMPT_DTLCost Component Details
CM_CMPT_DTL_EFCShadow 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_GRPCost component Groups
CM_CMPT_MSTCost Component Master
CM_CMPT_MST_BCost Component Master
CM_CMPT_MST_TLTable to store translated columns for Cost Component Master Table
CM_CMPT_MTLThis table contains the item or item cost class specific material cost component and material analysis code. Used by the Actual Cost Process.
CM_CUPD_CTLCost 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_MSGCost 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_MSTItem 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_SUMObsolete
CM_REAS_CDSCost 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_CTLCost 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_ITMContains 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_MSGThe 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_DTLResource Costs
CM_RSRC_DTL_EFCShadow 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_LEDStandard 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_EFCShadow 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_HDRHeader information for Text entered through Edit Text option
CM_TEXT_TBL_TLCosting Translation Text Table.
CM_WHSE_ASCThe Costing Warehouse Association Table – allows the OPM user to build an association between costing and inventory warehouses.
CM_WHSE_EFFCosting Warehouse Effectivities. Used by Cost Rollup Process
CM_WHSE_SRCCosting Source Warehouses – Used by Rollup process
GL_ACCT_CLSUser-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_HRCThis 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_MAPGL 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_MSTContains 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_TTLThis table contains the system defined Account Titles. User is not allowed to change them in OPM.
GL_ACCT_TYPThis 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_USGThis 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_VALThis 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_MAPThis 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_MSTThis 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_VALThis 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_BASThis 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_DTLThis 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_EFCShadow 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_EXPThis 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_INPThis 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_EFCShadow 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_MSTMaster table to store the definition of the allocation codes.
GL_CLDR_DTLThis table contains the period defination for Fiscal year. This table is not used with Oracle Financials integrated setup.
GL_CLDR_HDRThis table contains the Fiscal Year defination for a Company. This table is not used with Oracle Financials integrated setup.
GL_CURR_MSTThis 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_INTThis is an interface table for synchronizing Currencies from Oracle Financials to OPM.
GL_EVNT_MSTThis table contains the pre-defined Event codes. An event is any activity within OPM that has a financial impact.
GL_EVNT_MST_TEMPAn internal table used by GL Update process to improve performance
GL_EVNT_PLCEvent specific Company Fiscal Policy information
GL_EXPN_CDS_TMPTemporary table used for performance improvment in cost allocation process. This table is populated with values from GL_CODE_COMBINATIONS table.
GL_ITEM_CSTItem costs for transactions. Maintains accounting and current costs. Component cost details are available in GL_ITEM_DTL table.
GL_ITEM_CST_EFCShadow 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_DTLCost component detail information for the item. Component details for the Accounting cost available in GL_ITEM_CST table.
GL_ITEM_DTL_EFCShadow 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_MSTGL ledgers
GL_LEDG_MAPGL ledger mapping. Used for GL mapping.
GL_MEMO_STAInternal Table used by AR Update process
GL_MESG_TBLGeneral ledger messages table. Messages generated during transaction posting by Subsidiary Ledger Update process.
GL_PLCY_LGRCompany ledgers
GL_PLCY_MSTFiscal policy of a company. Fiscal policy defines the GL attributes of the company.
GL_PLCY_MST_EFCShadow 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_SEGSegments for account key segregation. Stores the Chart of Accounts.
GL_PLCY_SYSFiscal policy sub-systems
GL_RATE_TYPExchange rate Classification such as daily, average, bal sheet.
GL_RATE_TYP_INTExchange Rate Type Interface. Used for synchronzing rate types from Oracle Financials.
GL_SETU_ERRGL mapping setup errors found during Subsidiary Ledger Update process. Not currently used.
GL_SEVT_MSTGL mapping subevents. OPM user is not allowed to modify this information.
GL_SEVT_TTLGL mapping subevent account titles. Account titles that are impacted by a subsystem subevent.
GL_SRCE_MSTSubsystem master table
GL_SUBR_LEDGL 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_EFCShadow 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_VARTable for storing all types of batch close variances calculated during actual subledger run.
GL_SUBR_STAOPM Subsidiary Ledger Update process Control table
GL_SUBR_TSTSubsidiary 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_EFCShadow 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_VARTable for storing all types of batch close variances calculated during test subledger run.
GL_TEXT_HDRTable used to store text types for GL
GL_TEXT_TBL_TLGL Module Text Lines. Descriptive text for all tables in this module.
GL_UPDT_CTLThe control table for OPM GL Update Process. Only used with OPM integrated with Oracle Financials.
GL_UPDT_MSGOPM GL Update process error messages table. Only used with OPM integrated with Oracle Financials.
GL_VALN_CDSValidation codes for account key auto-generation.
GL_XCHG_RTEExchange rates
GMF_BATCH_REQUIREMENTSBatch requirement details
GMF_BATCH_REQUIREMENTS_GTMP
GMF_BATCH_REQUIREMENTS_GTMP1
GMF_BATCH_VIB_DETAILSVirtual incremental batch details
GMF_BURDEN_ASSOCIATIONIn OPM Costing, this table is where the Percentage Burden Associations are stored.
GMF_BURDEN_CODESIn OPM Costing, this is where the Percentage Burden Codes are stored.
GMF_BURDEN_PERCENTAGESIn OPM Costing, this is where the Burden Percentages are established.
GMF_BURDEN_PRIORITIESIn OPM Costing, this is where the Percentage Burden Priorities are established.
GMF_CALENDAR_ASSIGNMENTSCost Calendar Assignments
GMF_COST_METHOD_LEVELTable of all cost methods that cost items at the summary level
GMF_FISCAL_POLICIESFiscal policy of legal entity. Fiscal policy defines the GL attributes of legal entity
GMF_INCOMING_MATERIAL_LAYERSLayer data for consumption transactions
GMF_INV_TXN_FLAGS_GT
GMF_INVOICE_DISTRIBUTIONSSupplementary table to store invoice variance amounts for Actual Costing
GMF_ITEM_GROUPSStores the grouping of items (representative vs represented) for Summary Level costing
GMF_LAYER_COST_DETAILSLayer Cost Details
GMF_LC_ACTUAL_COST_ADJSThis table used to store Actual Landed cost adjustments which are processed by actual cost proces for actual cost types
GMF_LC_ADJ_TRANSACTIONSThis 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_ADJSThis table used to store Actual Landed cost adjustments which are processed by Lot cost process
GMF_LEDGER_VALUATION_METHODSThis 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_DTLSOPM Lot Cost Adjustments details table
GMF_LOT_COST_ADJUSTMENTSOPM Lot Cost Adjustments header table
GMF_LOT_COST_BURDENSBurden details for lot costed items
GMF_LOT_COST_DETAILSLot Cost details table
GMF_LOT_COSTED_ITEMSLot cost enabled items
GMF_LOT_COSTED_ITEMS_GTThis table stores all items flaged as lot costed
GMF_LOT_COSTSOPM Lot Costs Header Table
GMF_MATERIAL_LOT_COST_TXNSTransaction history table for lot costs
GMF_OUTGOING_MATERIAL_LAYERSLayer data for the batch yield transactions.
GMF_PERIOD_BALANCESPeriod Inventory Balances for Process Orgs
GMF_PERIOD_BALANCES_GTTemporary table for Period Inventory Balances for Process Orgs
GMF_PERIOD_STATUSESCost Period statuses for a Legal Entity & Cost Type
GMF_PERIOD_STATUSES_GTGlobal temporary table gmf_period_statuses_gt with on commit delete rows
GMF_PROCESS_ORGANIZATIONS_GTThis table stores process organizations for temporary session
GMF_RCV_ACCOUNTING_TXNSThis table stores information for receiving accounting for process organizations
GMF_RESOURCE_LAYERSConsumption Resource Layers
GMF_TRANSACTION_VALUATIONTransaction Valuation table for process organizations
GMF_XLA_EVENT_MODELThis 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_HEADERSThis 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_GTStores 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_LINESThis 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_GTStores 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_GTThis table is only used in GMF Accounting Pre-Processor to store item location in the struct. Done to improve performance.
SY_EXCP_TBLContains the errors generated by OPM GL Synchronization process for invalid data. The exception report runs off this table.
SY_SOFT_DTLDefines tables(sources) and their attributes for use in supporting a given Third-Party integration.
SY_SOFT_MSTDefines Third-Party software which has a supported interface to OPM.
Oracle Process Manufacturing Financials Views:
VIEW NAMEDESCRIPTION
AR_TO_SOP_DRILLDOWN_VIEWAR to SOP drilldown view
CM_ACST_LED_VAcquisition cost LED view
CM_ADJS_DTL_VView to enable master-detail relationship on Actual Cost Adjustments form
CM_APCM_MST_VView to enable master-detail relationship on Invoice Price Maintenance form
CM_BRDN_DTL_VView to enable master-detail relationship on Burden Details form
CM_CLDR_HDR_VLLanguage resolved view of Cost Calendar Header and Translated description table
CM_CLDR_MST_VView on period statuses & calendars
CM_CMPT_DTL_VView to enable master-detail relationship on Cost Details form
CM_CMPT_DTL_VWView of TOTAL_COST
CM_CMPT_DTL_VW1View on cm_cmpt_dtl
CM_CMPT_MST_VLLanguage resolved view of Cost Component Class Master and Translated description table
CM_CMPT_MTL_VView to enable master-detail relationship on Material Cost Components form
CM_RSRC_DTL_VView to enable master-detail relationship on Resource Costs form
CM_TEXT_TBL_VLCM Text table view
CM_WHSE_ASC_VView to enable master-detail relationship on Cost Warehouse Associations form
CM_WHSE_EFF_VView to enable master-detail relationship on Rollup Target Warehouses form
CM_WHSE_SRC_VView to enable master-detail relationship on Rollup Source Warehouses form
GLEX_VIEWGlex view
GL_ALOC_BAS_VView to enable master-detail relationship on Allocation Basis form
GL_ALOC_EXP_VView to enable master-detail relationship on Expenses to Allocate form
GL_ALOC_INP_VView to enable master-detail relationship on Allocation Maintenance form
GL_ALOC_MST_VView to enable master-detail relationship on Allocation Codes form
GL_SUBR_LED_VWOBSOLETE:GL Subsidiary Ledger View
GL_SUBR_TST_VWOBSOLETE:GL Subsidiary Ledger Test View
GL_TEXT_TBL_VLGL Text table view
GMF_COST_CMPNT_CLASS_SLA_VView for the value set , GMF_COST_CMPNT_CLASS_SLA
GMF_FORM_EFF_VWInternal helper view for Standard Cost Rollup
GMF_LC_ADJ_DETAILS_VLC Adjustment details view will contain detailed information for each actual LC adjustment
GMF_LC_ADJ_HEADERS_VView used to store LC adjustments will be populated by LCM tables
GMF_LEDGER_VALUATION_METHODS_VHelper view for Ledger Valuation methods form
GMF_LEGAL_ENTITIESInternal view to retrieve Legal Entity information
GMF_LEGAL_ENTITIES_VW2Helper view for display of Legal Entities in Costing
GMF_LOT_COSTED_ITEMS_VHelper view for Lot Costed Items Form
GMF_LOT_COSTS_VInternal View for the lot item cost details form
GMF_LOT_COST_ADJUSTMENTS_VInternal View for Lot Cost Adjustments
GMF_LOT_COST_BURDENS_VView for lot cost burdens form
GMF_MATERIAL_EFFECTIVITIES_VW1This is a helper view for Item substitution for costing.
GMF_ORDER_TYPES_VView for the value set , GMF_ORDER_TYPES
GMF_ORGANIZATION_DEFINITIONSView of Process Organization Definition Details
GMF_RESOURCE_COSTS_VResource Costs View
GMF_XLA_ACTCOST_ADJS_VView for SLA ADR sources from Actual Cost Adjustments
GMF_XLA_BATCH_DETAILS_VView for SLA ADR sources from Batch Details
GMF_XLA_BATCH_HDR_VSLA batch header view
GMF_XLA_BATCH_RSRC_VSLA batch resources view
GMF_XLA_COST_RVAL_VView for SLA ADR sources from Cost Revaluation
GMF_XLA_CUSTOMER_VView for SLA ADR sources from customers
GMF_XLA_INVENTORY_TXNS_VView for SLA ADR sources from inventory transactions
GMF_XLA_INV_REQ_TXNS_VView for SLA ADR sources from Requisition Transactions View
GMF_XLA_ITEMS_VView for SLA ADR sources from Item Definition
GMF_XLA_ITEM_LOCATIONS_VView for SLA ADR sources from Inventory Item Locations
GMF_XLA_ITEM_REVISIONS_VView for SLA ADR sources from item revisions
GMF_XLA_LC_ADJS_VSLA LC Adjustments view, used to display LC adjustments information in accounting events screen
GMF_XLA_LOTCOST_ADJS_VView for SLA ADR sources from Lot Cost Adjustments View
GMF_XLA_ORG_PARAMETERS_VView for SLA ADR sources from Inventory Organization parameters.
GMF_XLA_PAYABLES_INVOICES_VView for SLA ADR sources from Payable Invoices
GMF_XLA_PM_RSRC_TXNS_VView for SLA ADR sources from Resource Transactions
GMF_XLA_PM_TXNS_VView for SLA ADR sources from Batch Transactions
GMF_XLA_PO_TXNS_VView for SLA ADR sources from purchase order Transactions
GMF_XLA_RCV_TXNS_VView for SLA ADR sources from Receipt Transactions
GMF_XLA_RCV_VENDOR_VView for SLA ADR sources from Receipt Vendor Transactions
GMF_XLA_SO_TXNS_VView for SLA ADR sources from Sales Order Transactions
GMF_XLA_SUBINV_VView for SLA ADR sources from Subinventory definition
GMF_XLA_TXN_REASONS_VView for SLA ADR sources from Inventory Transactions Reasons
GMF_XLA_VENDOR_VView for SLA ADR sources from Vendor
GML_OM_SHIP_DTL_VWOBSOLETE:Selects the OM Shipments and their related information in OPM Inventory Transactions.
IC_ITEM_LOCT_VWOBSOLETE:Used in Financials for Lots
IC_TRAN_PND_OM_VW1OBSOLETE: Pending inventory transactions for OM view
OPM_CUSTOMERSUsed for OPM customer synchronization
OPM_SITE_USES_ALLOPM site uses view
RA_CUST_TRX_LINE_VCustomer transaction line view
TERTORY_VIEWTerritory view

Deixe uma resposta

 
Pular para a barra de ferramentas