GME Tables (66)

GME - Process Manufacturing Process Execution — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.

Table	Columns	Description
GME_BATCH_GROUPS_ASSOCIATION	7	Batch to Group Association
GME_BATCH_GROUPS_B	8	Base table to define the Group to which batches can be associated
GME_BATCH_GROUPS_TL	9	Translated view of batch groups
GME_BATCH_HEADER	89	Batch/FPO header. This table stores the header information for both Firm Planned Orders (FPOs) and Batches, including the plant, the validit
GME_BATCH_HEADER_MIG	87
GME_BATCH_HISTORY	16	Production history table. History table for the production events. Records event with financial implications, such as status changes and WIP
GME_BATCH_MAPPING_MIG	11
GME_BATCH_SALES_ORDERS	8	This table tracks the sales order(s) used to generate the batch(es).
GME_BATCH_STEPS	74	Batch steps table. This table contains data about each step (operation) in a batch, such as the step status and planned and actual start and
GME_BATCH_STEPS_MIG	74
GME_BATCH_STEP_ACTIVITIES	54	Batch operation (step) details. This table contains information for each activity within a batch step.
GME_BATCH_STEP_ACTIV_MIG	54
GME_BATCH_STEP_CHARGES	13	Table to store the charge details
GME_BATCH_STEP_CHARGES_MIG	13
GME_BATCH_STEP_DEPENDENCIES	49	This table contains data about dependencies between batch steps. For example, the start of a step can be dependent on the completion of a pr
GME_BATCH_STEP_DEP_MIG	49
GME_BATCH_STEP_ITEMS	43	This table defines relationship between batch steps and batch lines. For example, if the third ingredient in a batch is consumed in the seco
GME_BATCH_STEP_ITEMS_MIG	12
GME_BATCH_STEP_RESOURCES	80	Batch operation (step) details. This table contains information for each resource within an activity of batch step.
GME_BATCH_STEP_RESOURCES_MIG	80
GME_BATCH_STEP_RSRC_SUMMARY	13	Batch step resource usages for Pending and WIP batch steps
GME_BATCH_STEP_TRANSFERS	47	This table records information (quantity and date) about material that a step has received from a previous step and material that it has sen
GME_BATCH_STEP_TRANSFERS_MIG	47
GME_BATCH_TXNS_MIG	3
GME_ERES_GTMP	12
GME_EXCEPTIONS_GTMP	10	This is a new table that holds material details information for the exception materials
GME_GANTT_DOCUMENT_FILTER	14	Filter for the GME Gantt Chart informaiton
GME_GANTT_GTMP	16
GME_INVENTORY_TXNS_GTMP	38
GME_LAB_BATCH_LOTS	44	This tables tracks lot values for a Lab batch when inventory is not updated for lot-controlled items.
GME_MATERIAL_DETAILS	75	New quantity columns; for scaling a WIP batch. Actual quantities must match on the PM & POC sides. If a WIP batch is scaled the actual qua
GME_MATERIAL_DETAILS_MIG	75
GME_MATERIAL_DISPENSING_GTMP	8
GME_MIGRATION_CONTROL	8	Control Table for Migration to determine whether a table has been migrated
GME_MTO_RULES	16	This table store Make to Order Rules
GME_MTO_RULE_ASSIGNMENTS	13	This table stores association between Make to Order Rule to Assignment
GME_PARAMETERS	38	This is a new table that holds all the GME parameters at the org level
GME_PENDING_PRODUCT_LOTS	14	This table contains the lots information for the lab batches, and the lot information for the products/byproducts for production batches.
GME_PROCESS_PARAMETERS	49	GME Process Parameters, table to store actual values of Process Parameters attached to a resource
GME_PROCESS_PARAMETERS_MIG	49
GME_RESOURCE_TXNS	65	Process operations control transaction table. This table stores resource transactions created in POC.
GME_RESOURCE_TXNS_GTMP	56
GME_RESOURCE_TXNS_MIG	66
GME_RESOURCE_TXNS_SUMMARY	11	Pending resource transaction summary
GME_SCALE_DETAIL	7	Table used by the Batch Yield Variance and Batch Usage and Substitution Variance reports to hold scaled batch data.
GME_TEMP_EXCEPTIONS	6	Used to store the exceptions during the migration of data
GME_TEXT_HEADER	6	Master table for creation and storage of text codes associated with Process Execution tables.
GME_TEXT_TABLE_TL	13	Production Management module text lines. Descriptive text for all tables in this module
GME_TRANSACTION_PAIRS	5	This table store relationship between transaction row and its reversal
GME_UNALLOCATED_ITEMS_GTMP	10
PC_BATCH_STEP_WK	9	Batch Step Variance Inquiry table.
PC_RESOURCE_WK	21	Resource Variance Inquiry table.
PC_TEXT_HDR	6	Table used to store text types for POC
PC_TEXT_TBL_TL	13	PC Module Text Lines. Descriptive text for all tables in this module.
PC_TRAN_PND	59	POC transaction table.
PC_WIP_INQ_WK	10	WIP Inquiry table.
PM_BTCH_PKG	8	* NOT USED *
PM_HIST_HDR	16	Production history table.
PM_OPRN_DTL	61	Batch operation details.
PM_OPRN_WIP	46	Completed incoming/output WIP transactions.
PM_ROUT_DEP	16	Non-standard batch steps dependencies.
PM_ROUT_DTL	56	Batch routing steps.
PM_ROUT_MTL	9	Batch steps to batch lines relationships.
PM_SCAL_DTL	7	Variance reports table.
PM_TEXT_HDR	6	Table used to store text types for Production Management
PM_TEXT_TBL_TL	14	PM Module Text Lines. Descriptive text for all tables in this module.