GMP Tables (88)
GMP - Process Manufacturing Process Planning — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.
| Table | Columns | Description |
|---|---|---|
CR_ARES_MST |
14 | Alternate resource table |
CR_DOPR_TBL |
9 | Demand order priority table. Allows priority to be set on Demand Orders |
CR_GLED_CLS |
10 | Capacity G/L Class Code Descriptions |
CR_RSRC_CLS_B |
10 | Resource class |
CR_RSRC_CLS_TL |
9 | Resource Master for MRP |
CR_RSRC_DTL |
36 | Plant-specific resource information |
CR_RSRC_MST_B |
22 | Resource master |
CR_RSRC_MST_TL |
9 | Resource Master for MRP |
CR_SQDS_TBL |
15 | Sequence-dependent setup |
CR_TEXT_HDR |
6 | Table used to store text types for Capacity |
CR_TEXT_TBL_TL |
13 | CR Module Text Lines. Descriptive text for all tables in this module. |
FC_FCST_DTL |
14 | Forecast detail |
FC_FCST_HDR |
15 | Forecast header |
FC_TEXT_HDR |
6 | Table used to store text types for Forecasting. |
FC_TEXT_TBL_TL |
13 | FC Module Text Lines. Descriptive text for all tables in this module. |
GMP_ALTRESOURCE_PRODUCTS |
9 | Product specific alternate resources are stored in this table |
GMP_APS_OUTPUT_DTL |
53 | APS Output Detail table |
GMP_APS_OUTPUT_TBL |
23 | Temp table for APS Output |
GMP_BUCKETED_XML_TEMP |
2 | |
GMP_CALENDAR_DETAIL_GTMP |
8 | |
GMP_DEMANDS_API |
12 | API table for Sales and Forecast Demands |
GMP_FORM_EFF |
12 | Formula Effectivity Mapping Table |
GMP_HORIZONTAL_PDR_GTMP |
48 | |
GMP_ITEM_APS |
20 | Item Master Table for APS |
GMP_ITEM_WPS |
17 | Table for OPM Items Scheduling in WPS |
GMP_PARAMETER_VALUES_B |
7 | Process Parameter values |
GMP_PARAMETER_VALUES_TL |
10 | Process Parameter values Translation table |
GMP_PDR_ITEMS_GTMP |
13 | |
GMP_PDR_XML_TEMP |
3 | Table used to store XML generated for Planning Detail Report. |
GMP_PLANT_RSRC_PARAMETERS |
10 | Table for Association of Parameters to the Generic Resources |
GMP_PROCESS_DTL_APS |
8 | APS Process Update Detail Table - Currently Not Used |
GMP_PROCESS_HDR_APS |
14 | APS Process Update Header Table - Currently Not Used |
GMP_PROCESS_MSG_APS |
12 | APS Process Update Message table - Currently Not Used |
GMP_PROCESS_PARAMETERS_B |
44 | Table for Process Parameters |
GMP_PROCESS_PARAMETERS_TL |
9 | Table for to store Process Parameters description ( MLS ) |
GMP_PROCESS_PARAMETER_SETS |
8 | Table for Association of Parameters to the Parameter Sets |
GMP_PROCESS_PARAMETER_SET_B |
7 | Table for Process Parameter Sets |
GMP_PROCESS_PARAMETER_SET_TL |
9 | Table for Process Parameter Sets |
GMP_PROCESS_TYP_APS |
9 | APS Process Update Type table - Currently Not Used |
GMP_RESDISP_XML_TEMP |
2 | Table used to store XML generated for Resource Dispatch Report. |
GMP_RESOURCE_AVAIL |
17 | Table for Resource Availability |
GMP_RESOURCE_DEVICES |
7 | Resource-Device Association |
GMP_RESOURCE_DEVICE_MESSAGES |
11 | Resource Parameter to Device Response Messages Mapping Table |
GMP_RESOURCE_EQUIPMENTS |
7 | Table for Resource Equipment |
GMP_RESOURCE_INSTANCES |
58 | Table for Resource Instances |
GMP_RESOURCE_PARAMETERS |
11 | Table for Association of Parameters to the Generic Resources |
GMP_ROUTING_OFFSETS |
14 | Table for Routing offsets used in Lead Time Calculations |
GMP_RSRC_EXCP_ASNMT |
9 | Resource Assignment Table |
GMP_RSRC_EXCP_DTL |
9 | Exception Details Table |
GMP_RSRC_EXCP_HDR |
9 | Exception Header Table |
GMP_RSRC_UNAVAIL_MAN |
14 | Manual Entries Table |
GMP_SEQUENCE_DEPENDENCIES |
44 | Table for Sequence Dependencies |
GMP_SEQUENCE_TYPES |
8 | Table for Sequence Types |
GMP_UNBUCKETED_XML_TEMP |
2 | Table used to store XML generated for Unbucketed Material Activity Report |
MR_ACTN_TBL |
27 | MRP Action messages. |
MR_MESG_TBL |
25 | MRP Error message log. |
MR_PARM_DTL |
52 | MRP run parameters. |
MR_PEGG_TBL |
12 | Pegging table. Pegging of demands to the shortage warnings is done |
MR_SHCL_DTL |
12 | Shop calendar details. |
MR_SHCL_HDR |
20 | Shop calendar header. |
MR_SHDY_DTL |
12 | Shop day detail. |
MR_SHDY_HDR |
10 | Shop day header. |
MR_SIZE_TBL |
29 | MRP runs sizing. MRP allocates memory based on max number of rows mentioned in this table. The values are updated when a MRP Run gets rows m |
MR_TEXT_HDR |
6 | Table used to store text types for MRP. |
MR_TEXT_TBL_TL |
13 | MR Module Text Lines. Descriptive text for all tables in this module. |
MR_TRAN_TBL |
21 | MRP transactions. |
MR_UBKT_DTL |
16 | This table is a 'temporary table' in the sense that data is deleted with each MRP run and there were issues running the reports with PK, th |
PS_MATL_DTL |
32 | Temporary data about the report |
PS_MATL_HDR |
7 | Temporary data about the report |
PS_OPER_PCL |
11 | Associates operator codes and planning classes. |
PS_SCHD_DTL |
12 | Schedule detail. |
PS_SCHD_FOR |
10 | Schedule forecast association. |
PS_SCHD_HDR |
30 | Schedule header. |
PS_TEXT_HDR |
6 | Table used to store text types for Production Scheduling. |
PS_TEXT_TBL_TL |
13 | PS Module Text Lines. Descriptive text for all tables in this module. |
PS_UBKT_DTL |
18 | Table used to store data for the Material Activity Report. |
PS_WHSE_EFF |
14 | Plant-warehouse relationship (effectivity). |
RH_ACTN_TBL |
11 | Table storing all the syntaxes for the actions executed during data transfer between OPM and Rhythm |
RH_DORD_IMP |
22 | Demand order import table. Stores imported details of demand orders. - Currently Not Used |
RH_EXPT_DTL |
9 | Datils of each export |
RH_EXPT_MST |
13 | Export Master table |
RH_IMPT_DTL |
9 | Demand order import details. |
RH_IMPT_MST |
13 | Import master. |
RH_MESG_TBL |
12 | Message table for data transfers |
RH_MORD_IMP |
27 | Manufacturing order import. - Currently Not Used |
RH_PARM_TBL |
10 | Parameter table for all INSTALLED schedules |
RH_PARM_TYP |
9 | Master table for storing parameters and their default values. During installation of a schedule the parameters are copied from here. |
RH_RSCL_TBL |
10 | * NOT USED * |