GMS — Grants Accounting

51 documented tables · 107 views — Oracle EBS ETRM 12.2.2

Most-referenced tables

TableDescriptionData 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

PackageClassProceduresUsed 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

✨ Ask AI about GMS objects