You are browsing the archive for GMS.

Oracle Grants Accounting Tables

Oracle Grants Accounting – List of database tables:

  • GMS_ALLOWABILITY_SCHEDULES
  • GMS_ALLOWABLE_EXPENDITURES
  • GMS_AWARDS_ALL
  • GMS_AWARDS_CONTACTS
  • GMS_AWARDS_TERMS_CONDITIONS
  • GMS_AWARD_DISTRIBUTIONS
  • GMS_AWARD_EXP_TYPE_ACT_COST
  • GMS_BALANCES
  • GMS_BC_PACKETS
  • GMS_BC_PACKETS_BVID
  • GMS_BC_PACKETS_SUMMARY
  • GMS_BC_PACKET_ARRIVAL_ORDER
  • GMS_BILLING_CANCELLATIONS
  • GMS_BILLING_FORMS
  • GMS_BIS_AWD_ACT_F
  • GMS_BIS_AWD_GR_SUMM
  • GMS_BIS_AWD_ORG_SUMM
  • GMS_BIS_AWD_PURPOSE_SUMM
  • GMS_BIS_AWD_TYPE_SUMM
  • GMS_BIS_NEW_AWD_GR_SUMM
  • GMS_BIS_NEW_AWD_ORG_SUMM
  • GMS_BIS_PAR_GR_SUMM
  • GMS_BIS_PAR_ORG_SUMM
  • GMS_BIS_PPSL_ACT_F
  • GMS_BIS_SPECIAL_REVIEW_FACT_F
  • GMS_BUDGETARY_CONTROLS
  • GMS_BUDGET_LINES
  • GMS_BUDGET_VERSIONS
  • GMS_BURDEN_ADJUSTMENTS_LOG
  • GMS_BURDEN_COMPONENTS
  • GMS_CONCURRENCY_CONTROL
  • GMS_DEFAULT_REPORTS
  • GMS_DISTRIBUTIONS
  • GMS_DISTRIBUTION_DETAILS
  • GMS_ENCUMBRANCES_ALL
  • GMS_ENCUMBRANCE_GROUPS_ALL
  • GMS_ENCUMBRANCE_ITEMS_ALL
  • GMS_EVENT_ATTRIBUTE
  • GMS_EVENT_INTERSECT
  • GMS_FP_DISTRIBUTIONS
  • GMS_FUNDING_PATTERNS_ALL
  • GMS_IMPLEMENTATIONS_ALL
  • GMS_IND_COST_CODES
  • GMS_INSTALLMENTS
  • GMS_NOTIFICATIONS
  • GMS_OVERRIDE_SCHEDULES
  • GMS_PACKET_ARRIVAL_ORDER
  • GMS_PERSONNEL
  • GMS_PROJECT_FUNDINGS
  • GMS_PROJECT_TYPES
  • GMS_PROJECT_TYPES_ALL
  • GMS_REFERENCE_NUMBERS
  • GMS_REPORTS
  • GMS_REPORT_TEMPLATES
  • GMS_RESOURCE_ASSIGNMENTS
  • GMS_SUMMARY_PROJECT_FUNDINGS
  • GMS_TC_CATEGORIES
  • GMS_TERMS_CONDITIONS
  • GMS_TRANSACTION_INTERFACE_ALL
  • GMS_UNIQUE_IDENTIFIER_CONTROL
  • GMS_UPGRADE_CONTROL
  • GMS_UPGRADE_DEBUG
  • GMS_UPGRADE_IDC_SUMMARY_TEMP
  • GMS_WF_PROCESSES

Views in Grants Accounting Module

List of views in Oracle Grants Accounting Module

GMS_1034_REPORT_V
GMS_ACT_PROJECTS_BASIC_V
GMS_AWARD_BAL_V
GMS_AWARD_PROJECTS_V
GMS_AWARD_STATUS_V
GMS_AWARDS_ALL_DFV
GMS_AWARDS_BASIC_V
GMS_AWARDS_SRS_V
GMS_AWARDS_V
GMS_AWD_V
GMS_BILL_AWARD_PROJECTS_V
GMS_BUDG_CONTROL_RES_GRP_V
GMS_BUDGET_CHANGE_REASON_V
GMS_BUDGET_LINES_DFV
GMS_BUDGET_LINES_V
GMS_BUDGET_MATRIX_V
GMS_BUDGET_VERSIONS_BASELND_V
GMS_BUDGET_VERSIONS_DFV
GMS_BUDGET_VERSIONS_DRAFT_V
GMS_BUDGETARY_CONTROL_AWARD_V
GMS_BUDGETARY_CONTROL_PROJ_V
GMS_BUDGETARY_CONTROL_TASK_V
GMS_CDL_BURDEN_DETAIL_V
GMS_COMMITMENT_BURDEN_V
GMS_COMMITMENT_ENCUMBERED_V
GMS_COMMITMENT_TXNS_V
GMS_COMMITMENTS_OVERRIDE_V
GMS_CONTACTS_V
GMS_DEFAULT_REPORTS_V
GMS_DRAFT_INV_LINE_DETAILS_V
GMS_DRAFT_INVOICES_V
GMS_DRAFT_REVENUES_V
GMS_DTRANGE_BAL_V
GMS_EMPLOYEES
GMS_ENC_PSI_V
GMS_ENCUMBRANCE_GROUPS_V
GMS_ENCUMBRANCE_ITEMS_ALL_DFV
GMS_ENCUMBRANCE_ITEMS_V
GMS_ENCUMBRANCES_ALL_DFV
GMS_ENCUMBRANCES_V
GMS_EVENTS_V
GMS_EXPEND_ITEMS_ADJUST_V
GMS_FP_DISTRIBUTIONS_V
GMS_FUNDING_AWARDS_V
GMS_FUNDING_PATTERNS_V
GMS_FUNDSCTL_RES_V
GMS_FUNDSCTL_V
GMS_INSTALLMENTS_DFV
GMS_INSTALLMENTS_V
GMS_IP_AWARD_LOV_V
GMS_KEY_MEMBER_ROLE_V
GMS_LOC_CONTACTS_V
GMS_LOOKUPS
GMS_NONE_BAL_V
GMS_NOTIFICATIONS_V
GMS_OPERATING_UNITS_V
GMS_OVERRIDE_SCHEDULES_V
GMS_PERSONNEL_V
GMS_PHONE_CONTACTS_V
GMS_PQH_AWARDS_V
GMS_PQH_EXP_TYPES_V
GMS_PQH_PROJECTS_V
GMS_PROJECT_FUNDINGS_V
GMS_PROJECT_TYPES
GMS_PROJECTS_BASIC_V
GMS_PROJECTS_BURDEN_V
GMS_PROJECTS_EXPEND_V
GMS_PROJECTS_V
GMS_REFERENCE_NUMBERS_V
GMS_REPORT_TEMPLATES_V
GMS_REPORTS_V
GMS_RES_V
GMS_RESG_BAL_V
GMS_RESG_BC_V
GMS_RESG_V
GMS_SSA_AWARD_EXPTYPE_V
GMS_SSA_AWARDS_V
GMS_STATUS_ACCUM_PROJ_BASE_V
GMS_STATUS_ACCUM_PROJECT_V
GMS_STATUS_ACCUM_TASK_BASE_V
GMS_STATUS_ACTUALS_BASE1_V
GMS_STATUS_ACTUALS_BASE2_V
GMS_STATUS_ACTUALS_V
GMS_STATUS_AWARD_ACCUM_BASE_V
GMS_STATUS_AWARD_ACCUM_TASK_V
GMS_STATUS_AWARD_ACCUM_V
GMS_STATUS_COMMITMENTS_V
GMS_STATUS_PROJ_GENERIC_V
GMS_STATUS_RESOURCES_BASE_V
GMS_STATUS_RESOURCES_V
GMS_SUM_PRJ_FUNDINGS_V
GMS_TASK_BAL_V
GMS_TASK_BUDGETS_V
GMS_TASK_BUDGETS2_V
GMS_TASK_V
GMS_TERMS_CONDITIONS_V
GMS_XLA_AWARD_REF_V
GMS_XLA_PROJECT_REF_V

Grants Accounting Descriptive Flex Field

Oracle Grants Accounting Module DFF list

DFF View DFF CODE NAME DFF name
GMS_AWARDS_ALL_DFV GMS_AWARDS_DESC_FLEX Awards Descriptive Flexfield
GMS_INSTALLMENTS_DFV GMS_INSTALLMENTS_DESC_FLEX Installments Descriptive Flexfield
GMS_BUDGET_LINES_DFV GMS_BUDGET_LINES_DESC_FLEX Award Budget Lines Descriptive Flexfield
GMS_BUDGET_VERSIONS_DFV GMS_BUDGET_VERSIONS_DESC_FLEX Award Budget Versions Descriptive Flexfield
GMS_ENCUMBRANCES_ALL_DFV GMS_ENCUMBRANCES_DESC_FLEX Encumbrances Descriptive Flex Field
GMS_ENCUMBRANCE_ITEMS_ALL_DFV GMS_ENC_ITEMS_DESC_FLEX Encumbrance Items Descriptive Flex Field