GMS — Grants Accounting
51 documented tables · 107 views — Oracle EBS ETRM 12.2.2
Most-referenced tables
| Table | Description | Data Vault class* |
|---|---|---|
GMS_RESOURCE_ASSIGNMENTS |
Resource assignments for a budget version at a branch of project's work breakdown | satellite-leaning |
GMS_FUNDING_PATTERNS_ALL |
Rule definition for charging transactions of a sponsored project to funding awards | hub-leaning |
GMS_BUDGET_VERSIONS |
Versions of award budgets | satellite-leaning |
GMS_IND_COST_CODES |
Additional information related to indirect cost codes maintained in PA_IND_COST_CODES | standalone |
GMS_NOTIFICATIONS |
Record of notifications sent to users about award events | satellite-leaning |
GMS_PACKET_ARRIVAL_ORDER |
standalone | |
GMS_PROJECT_TYPES |
standalone | |
GMS_BC_PACKETS |
Budgetary control packets for funds checking | link |
GMS_BUDGET_LINES |
Detail lines of project and task budgets | satellite-leaning |
GMS_EVENT_ATTRIBUTE |
Additional information on billing events for mapping billing event information maintained in PA_EVENTS table | satellite-leaning |
GMS_ENCUMBRANCE_GROUPS_ALL |
Groups of pre-approved encumbrances | satellite-leaning |
GMS_UNIQUE_IDENTIFIER_CONTROL |
Next award number for automatic award numbering | standalone |
GMS_DEFAULT_REPORTS |
Default reports of award | standalone |
GMS_BUDGETARY_CONTROLS |
Budgetary control level for awards, tasks, resource groups, and resources | standalone |
GMS_EVENT_INTERSECT |
Relationship between expenditure items and events | link |
*Heuristic classification mined from FK structure — a modeling suggestion, not Oracle's.
Key public APIs
| Package | Class | Procedures | Used by |
|---|---|---|---|
GMS_TRANSACTIONS_PUB |
PUB | 6 | 23 packages |
GMS_AP_API |
API | 11 | 10 packages |
GMS_PA_API |
API | 24 | 7 packages |
GMS_BUDGET_PUB |
PUB | 16 | 6 packages |
GMS_POR_API |
API | 15 | 4 packages |
GMS_PO_API_GRP |
GRP | 14 | 3 packages |
GMS_PO_API2_GRP |
GRP | 4 | 1 packages |
GMS_ACC_GEN_API |
API | 5 | 0 packages |
GMS_AWARD_PUB |
PUB | 9 | 0 packages |