Search Results gms_bc_packets




Overview
Explore in AI Chat

Overview

GMS_BC_PACKETS is the core budgetary control packet table within the Grants Accounting (GMS) product of Oracle E-Business Suite, available in both 12.1.1 and 12.2.2. It stores the packets generated by the funds checking and budgetary control engine, capturing the outcome of funds availability validation for grant-related expenditures across awards, projects, tasks, and resources. Each packet represents a unit of work evaluated against award, task, and resource budgets, and records both the balances and the result codes returned by the funds check process.

The table is physically owned by the GMS schema and is documented with 138 columns in the ETRM 12.2.2 schema definition. It is heavily denormalized by design: the funds check engine pre-computes and caches aggregated budgetary positions (posted, approved, pending, and balance amounts) at multiple levels — award, task, top task, resource group, and resource — so that subsequent checks avoid expensive re-aggregation. The heuristic Data Vault classification derived from its foreign key structure is a link, suggesting this table functions primarily as a transactional relationship record joining awards, projects, tasks, expenditure types, sets of books, and funding patterns.

Key Information Stored

The surrogate primary key is PACKET_ID, with the unique index GMS_BC_PACKETS_U1 defined on BC_PACKET_ID, which serves as the business-key candidate. The most operationally significant columns include:

Common Use Cases and Queries

The table is queried primarily for budgetary control diagnostics, funds check reporting, and troubleshooting failed or pending fund reservations on grants.

  • Identifying packets that failed funds checking for an award: SELECT BC_PACKET_ID, PROJECT_ID, TASK_ID, RESULT_CODE, FC_ERROR_MESSAGE FROM GMS_BC_PACKETS WHERE AWARD_ID = :award AND RESULT_CODE <> 'S';
  • Reporting award-level budget balances: select AWARD_BUDGET_BAL, AWARD_BUDGET_POSTED, AWARD_ENC_POSTED, and AWARD_ACTUAL_POSTED filtered by SET_OF_BOOKS_ID and PERIOD_NAME.
  • Reconciling funding pattern consumption using FUNDING_PATTERN_ID, FUNDING_SEQUENCE, and FP_STATUS.
  • Auditing packets by batch run via REQUEST_ID or SESSION_ID, joining to FND_CONCURRENT_REQUESTS.
  • Extracting packet lineage through PARENT_BC_PACKET_ID and BURDEN_ADJ_BC_PACKET_ID for burden adjustment analysis.

Related Objects

  • PA_PROJECTS_ALL — joined on PROJECT_ID; provides project attributes.
  • PA_TASKS — joined on TASK_ID and TOP_TASK_ID for task-level budgeting.
  • PA_EXPENDITURE_TYPES — joined on EXPENDITURE_TYPE.
  • GL_SETS_OF_BOOKS_11I — joined on SET_OF_BOOKS_ID.
  • IGF_AW_AWARD_ALL — joined on AWARD_ID; the award master.
  • GMS_FUNDING_PATTERNS_ALL — joined on FUNDING_PATTERN_ID.
  • GL_BC_PACKETS — related via GL_BC_PACKETS_ROWID for general ledger budgetary control integration.
  • GMS_AWARD_BUDGETS / GMS_BC_PACKETS child processes — consume and update packet balance columns during funds checking.