GMA — Process Manufacturing Systems
40 documented tables · 14 views — Oracle EBS ETRM 12.2.2
Most-referenced tables
| Table | Description | Data Vault class* |
|---|---|---|
SY_TEXT_HDR |
Master table for creation and storage of OPM text codes associated with GMA tables. | hub-leaning |
SY_ORGN_MST_B |
Organization code master Base Table. | hub |
SY_ORGN_MST |
Organization code master. | hub-leaning |
SY_ADDR_MST |
OPM Address master. Table which stores addresses for all Oracle Process | hub-leaning |
SY_UOMS_MST |
Unit of measure master for Oracle Process Manufacturing. Synchronized with MTL_UNITS_OF_MEASURE and associated | hub-leaning |
SY_DOCS_SEQ |
Document sequencing by organization. | satellite-leaning |
SY_UOMS_TYP |
Unit of measure type master for Oracle Process Manufacturing products. Define unit of measure types here, whic | hub-leaning |
SY_DOCS_MST |
Oracle Process Manufacturing Document master. This table stores document definitions | hub |
SY_PURG_DEF |
OPM Purge and Archive definitions are stored in this table | hub-leaning |
SY_PURG_MST |
Table storing data of all OPM Archives/Purges that have been run | hub-leaning |
SY_REAS_CDS_B |
The Reason Code table is used to store Reason Code definitions which provide information on the increase or de | hub-leaning |
SY_REAS_CDS |
The Reason Code table is used to store Reason Code definitions which provide information on the increase or de | hub-leaning |
GEM_LOOKUP_TYPES |
OPM Lookups, formerly known as System Types | hub-leaning |
GMA_AUDIT_TMPLT_MST |
This table is to store Industry Templates | hub-leaning |
GMA_PROCDATA_WF |
This table stores users process customizations data. This data determines the approval process behavior and i | standalone |
*Heuristic classification mined from FK structure — a modeling suggestion, not Oracle's.
Key public APIs
| Package | Class | Procedures | Used by |
|---|---|---|---|
GMA_GLOBAL_GRP |
GRP | 3 | 27 packages |
GMA_VALID_GRP |
GRP | 8 | 7 packages |
GMA_MIGRATION_PUB |
PUB | 5 | 0 packages |