GMA Tables (40)
GMA - Process Manufacturing Systems — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.
| Table | Columns | Description |
|---|---|---|
GMA_ACTCOL_WF_B |
12 | This table, will contain information associating a role definition tothe corresponding table and fields to which the role will beassociate |
GMA_ACTCOL_WF_TL |
13 | Checks the availability of Activity Identification in GMA_ACTDEF_WF before inserting a row in GMA_ACTCOL_WF |
GMA_ACTDATA_WF |
29 | This table will contain the actual data of the role association .User Role association with specific set of data is stored in this table. |
GMA_ACTDEF_WF |
11 | This table is used to define the activity where a role has to be |
GMA_AUDIT_DISP_COLS |
7 | This table is to store Display columns for Shown on Audit Query Navigator |
GMA_AUDIT_LKUPS |
4 | This table is to store Lookup Type information to show decoded column values in Audit Query Navigator form |
GMA_AUDIT_REP_DTL |
12 | This table is for Audit Trail Reporting. Data in this table is Temporary in nature |
GMA_AUDIT_REP_HDR |
12 | This table is for Audit Trail Reporting. Data in this table is Temporary in nature |
GMA_AUDIT_TMPLT_DTL |
9 | This table is to store relation between Industry Templates and Audit Groups |
GMA_AUDIT_TMPLT_MST |
8 | This table is to store Industry Templates |
GMA_MIGRATION_CONTROL |
5 | TO TRACK MIGRATION ERRORS |
GMA_MIGRATION_LOG |
23 | TO TRACK MIGRATION ERRORS |
GMA_PROCCOL_WF_B |
14 | This table contains information about configuration columns at workflow process level. Using these columns users can customize the approval |
GMA_PROCCOL_WF_TL |
14 | This table contains translated column prompts and provides multi-lingueal support. |
GMA_PROCDATA_WF |
30 | This table stores users process customizations data. This data determines the approval process behavior and is used by the API to determine |
GMA_PROCDEF_WF |
9 | Purpose of this table is to store workflow processes that are using generic approval process configuration framework. This also stores the |
GMA_REASON_CODE_SECURITY |
8 | Reason Code Security Table |
SY_ADDR_MST |
24 | OPM Address master. Table which stores addresses for all Oracle Process |
SY_CMPY_MST |
6 | Stores Organization Definitions at a single level |
SY_DOCS_MST |
12 | Oracle Process Manufacturing Document master. This table stores document definitions |
SY_DOCS_SEQ |
18 | Document sequencing by organization. |
SY_GEOG_MST |
12 | Geographic regions. |
SY_ORGN_MST_B |
63 | Organization code master Base Table. |
SY_ORGN_MST_TL |
9 | Translations table table holding OPM Organization names in multiple languages |
SY_ORGN_USR |
7 | Associates OPM Organizations with FND users |
SY_PARA_CDS_TL |
20 | Stores paragraph codes |
SY_PURG_DEF |
15 | OPM Purge and Archive definitions are stored in this table |
SY_PURG_DEF_ACT |
14 | Designates the Action to be performed by OPM Purge and Archive on a table by table basis. |
SY_PURG_DEF_CRIT |
18 | Stores the Purge Criteria tags. These criteria are used to determine what rows will be archived and purged. |
SY_PURG_ERR |
8 | Stores the database output from the GMA_PURGE_ENGINE package |
SY_PURG_LOG |
9 | Stores OPM Purge and Archive statistics table by table based on Purge ID. |
SY_PURG_MST |
30 | Table storing data of all OPM Archives/Purges that have been run |
SY_PURG_MST_CRIT |
11 | OPM Purge and Archive table used to store the criteria entered specific to a Purge ID. |
SY_REAS_CDS_B |
15 | The Reason Code table is used to store Reason Code definitions which provide information on the increase or decrease in inventory. Reason c |
SY_REAS_CDS_TL |
9 | Translations table table holding OPM reason code descriptions in multiple languages |
SY_TEXT_HDR |
6 | Master table for creation and storage of OPM text codes associated with GMA tables. |
SY_TEXT_TBL_TL |
13 | GMA product Text Lines (OPM System Administration). Descriptive text for all tables in this module. Also storesText Token text. |
SY_TEXT_TKN_TL |
11 | Stores OPM Text Token definitions |
SY_TRIGGER_ACTIVATION_WF |
10 | Used to store the detail information about theTriggers responsible for Starting the Workflows and their Status ( Enabled, Disabled ) of the |
SY_UOMS_STD |
7 | Table for associating Units of Measure and UOM Types. Not yet used. |