eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: GMS.GMS_BC_PACKETS

Object Details

Object Name:	GMS_BC_PACKETS
Object Type:	TABLE
Owner:	GMS
FND Design Data:	GMS.GMS_BC_PACKETS
Subobject Name:
Status:	VALID

GMS_BC_PACKETS is Oracle Grants Accounting's main table for the budgetary control feature. This table stores the budgetary control packets that need to be approved before creating journal entries. A budgetary control packet contains information about a set of transactions to be approved before entering it into the system. The funds check program evaluates these packets and updates the RESULT_CODE column in GMS_BC_PACKETS with a lookup code signifying the result of the funds check. Once a packet passes its funds check and the balances are updated in GMS_BALANCES, the packet is removed from GMS_BC_PACKETS.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GMS_BC_PACKETS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	BC_PACKET_ID
GMS_BC_PACKETS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PACKET_ID PROJECT_ID AWARD_ID TASK_ID
GMS_BC_PACKETS_N10	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PACKET_ID ADJUSTED_DOCUMENT_HEADER_ID
GMS_BC_PACKETS_N11	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DOCUMENT_TYPE DOCUMENT_HEADER_ID
GMS_BC_PACKETS_N12	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	STATUS_CODE
GMS_BC_PACKETS_N13	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SOURCE_EVENT_ID
GMS_BC_PACKETS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BUDGET_VERSION_ID PACKET_ID STATUS_CODE
GMS_BC_PACKETS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PARENT_BC_PACKET_ID
GMS_BC_PACKETS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PACKET_ID DOCUMENT_HEADER_ID DOCUMENT_DISTRIBUTION_ID DOCUMENT_TYPE
GMS_BC_PACKETS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PACKET_ID STATUS_CODE EFFECT_ON_FUNDS_CODE
GMS_BC_PACKETS_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PACKET_ID BUD_TASK_ID
GMS_BC_PACKETS_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PROJECT_ID TASK_ID
GMS_BC_PACKETS_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	AWARD_ID EXPENDITURE_TYPE STATUS_CODE BURDEN_CALCULATION_SEQ
GMS_BC_PACKETS_N9	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REQUEST_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PACKET_ID	NUMBER	(15)	Yes	Budgetary control packet defining column
PROJECT_ID	NUMBER	(15)	Yes	Project defining column
AWARD_ID	NUMBER	(15)	Yes	Award defining column
TASK_ID	NUMBER	(15)	Yes	Task defining column
EXPENDITURE_TYPE	VARCHAR2	(30)	Yes	Expenditure type defining column
EXPENDITURE_ITEM_DATE	DATE		Yes	Expenditure item date for the expenditure
ACTUAL_FLAG	VARCHAR2	(1)	Yes	Balance type. Valid values are A indicates Actual, B indicates Budget, or E indicates Encumbrance.
STATUS_CODE	VARCHAR2	(1)	Yes	Funds check or reservation status
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes	Standard Who column
SET_OF_BOOKS_ID	NUMBER	(15)	Yes	Accounting books defining column
JE_CATEGORY_NAME	VARCHAR2	(30)	Yes	Journal entry category name
JE_SOURCE_NAME	VARCHAR2	(30)	Yes	Journal entry source name
TRANSFERED_FLAG	VARCHAR2	(1)	Yes	Not currently used
DOCUMENT_TYPE	VARCHAR2	(3)	Yes	Document type defining column. Possible values are REQ, PO, Payables, or Project Accounting.
EXPENDITURE_ORGANIZATION_ID	NUMBER	(15)		Organization-incurred expenditure
PERIOD_NAME	VARCHAR2	(15)		Accounting period
PERIOD_YEAR	NUMBER	(15)		Accounting period year
PERIOD_NUM	NUMBER	(15)		Accounting period number
DOCUMENT_HEADER_ID	NUMBER	(15)		Document header defining column
DOCUMENT_DISTRIBUTION_ID	NUMBER	(15)		Document distribution defining column
TOP_TASK_ID	NUMBER	(15)		Top task defining column
PARENT_RESOURCE_ID	NUMBER	(15)		Parent task defining column
BUDGET_VERSION_ID	NUMBER	(15)		Budget version
RESOURCE_LIST_MEMBER_ID	NUMBER	(15)		Resource list member defining column
ACCOUNT_TYPE	VARCHAR2	(1)		Oracle Public Sector General Ledger account type
ENTERED_DR	NUMBER			Transaction debit amount in entered currency
ENTERED_CR	NUMBER			Transaction credit amount in entered currency
TOLERANCE_AMOUNT	NUMBER			Allowable amount to exceed funding budget
TOLERANCE_PERCENTAGE	NUMBER			Percentage of funding budget that can be increased
OVERRIDE_AMOUNT	NUMBER			Maximum transaction amount that can be used to override a funds check
EFFECT_ON_FUNDS_CODE	VARCHAR2	(1)		Increasing or decreasing effect of a transaction on funds available
RESULT_CODE	VARCHAR2	(3)		Result of funds check or reservation
GL_BC_PACKETS_ROWID	VARCHAR2	(30)		GL_BC_PACKETS row identifier defining column
AWARD_BUDGET_POSTED	NUMBER			Award budget posted
AWARD_BUDGET_APPROVED	NUMBER			Award budget approved
AWARD_BUDGET_PENDING	NUMBER			Award budget pending
AWARD_ENC_POSTED	NUMBER			Award encumbrance posted
AWARD_ENC_APPROVED	NUMBER			Award encumbrance approved
AWARD_ENC_PENDING	NUMBER			Award encumbrance pending
AWARD_ACTUAL_POSTED	NUMBER			Award actuals posted
AWARD_ACTUAL_APPROVED	NUMBER			Award actuals approved
AWARD_ACTUAL_PENDING	NUMBER			Award actuals pending
AWARD_RESULT_CODE	VARCHAR2	(3)		Result code of funds check at award level
TASK_BUDGET_POSTED	NUMBER			Task budget posted
TASK_BUDGET_APPROVED	NUMBER			Task budget approved
TASK_BUDGET_PENDING	NUMBER			Task budget pending
TASK_ENC_POSTED	NUMBER			Task encumbrances posted
TASK_ENC_APPROVED	NUMBER			Task encumbrances approved
TASK_ENC_PENDING	NUMBER			Task encumbrances pending
TASK_ACTUAL_POSTED	NUMBER			Task actuals posted
TASK_ACTUAL_APPROVED	NUMBER			Task actuals approved
TASK_ACTUAL_PENDING	NUMBER			Task actuals pending
TASK_RESULT_CODE	VARCHAR2	(3)		Result code of funds check at task level
RES_GRP_BUDGET_POSTED	NUMBER			Resource group budget posted
RES_GRP_BUDGET_APPROVED	NUMBER			Resource group budget approved
RES_GRP_BUDGET_PENDING	NUMBER			Resource group budget pending
RES_GRP_ENC_POSTED	NUMBER			Resource group encumbrances posted
RES_GRP_ENC_APPROVED	NUMBER			Resource group encumbrances approved
RES_GRP_ENC_PENDING	NUMBER			Resource group encumbrances pending
RES_GRP_ACTUAL_POSTED	NUMBER			Resource group actuals posted
RES_GRP_ACTUAL_APPROVED	NUMBER			Resource group actuals approved
RES_GRP_ACTUAL_PENDING	NUMBER			Resource group actuals pending
RES_GRP_RESULT_CODE	VARCHAR2	(3)		Result code of funds checker at resource group level
RES_BUDGET_POSTED	NUMBER			Resource budget posted
RES_BUDGET_APPROVED	NUMBER			Resource budget approved
RES_BUDGET_PENDING	NUMBER			Resource budget pending
RES_ENC_POSTED	NUMBER			Resource encumbrances posted
RES_ENC_APPROVED	NUMBER			Resource encumbrances approved
RES_ENC_PENDING	NUMBER			Resource encumbrances pending
RES_ACTUAL_POSTED	NUMBER			Resource actuals posted
RES_ACTUAL_APPROVED	NUMBER			Resource actuals approved
RES_ACTUAL_PENDING	NUMBER			Resource actuals pending
RES_RESULT_CODE	VARCHAR2	(3)		Result code of funds check at resource level
STATUS_FLAG	VARCHAR2	(2)		Not currently used
RES_BUDGET_BAL	NUMBER			Resource level budget balance after funds check
RES_GRP_BUDGET_BAL	NUMBER			Resource group level budget balance after funds check
TASK_BUDGET_BAL	NUMBER			Task level budget balance after funds check
TOP_TASK_BUDGET_BAL	NUMBER			Top task level budget balance after funds check
AWARD_BUDGET_BAL	NUMBER			Award level budget balance after funds check
GL_ROW_NUMBER	NUMBER			GL_BC_PACKETS row sequence number
BC_PACKET_ID	NUMBER			Bugetary control records unique identifier
PARENT_BC_PACKET_ID	NUMBER			Raw budgetary control record, which the burdened budgetary control record is associated with
BURDENABLE_RAW_COST	NUMBER			Amount of raw cost that is burdenable. Portion of raw cost that does not exceed maximum indirect base.
BUD_RESOURCE_LIST_MEMBER_ID	NUMBER	(15)		Resource list member identifier for the record
BUD_TASK_ID	NUMBER	(15)		Budgeted task identifier for the record
FUNDING_PATTERN_ID	NUMBER	(15)		Funding pattern identifier for the record
FUNDING_SEQUENCE	NUMBER	(15)		Sequence number within the funding pattern for the record
FP_STATUS	VARCHAR2	(1)		Status of the funding pattern
R_FUNDS_CONTROL_LEVEL_CODE	VARCHAR2	(1)		Funds control level code at resource level
RG_FUNDS_CONTROL_LEVEL_CODE	VARCHAR2	(1)		Funds control level code at resource group level
T_FUNDS_CONTROL_LEVEL_CODE	VARCHAR2	(1)		Funds control level code at task level
TT_FUNDS_CONTROL_LEVEL_CODE	VARCHAR2	(1)		Funds control level code at top task level
A_FUNDS_CONTROL_LEVEL_CODE	VARCHAR2	(1)		Funds control level code at award level
TOP_TASK_BUDGET_POSTED	NUMBER			Posted budget balance at top task
TOP_TASK_BUDGET_APPROVED	NUMBER			Budget balance at top task after approved transactions are posted
TOP_TASK_BUDGET_PENDING	NUMBER			budget balance at top task after pending transactions
TOP_TASK_ENC_POSTED	NUMBER			Encumbrance amount already posted at top task level
TOP_TASK_ENC_APPROVED	NUMBER			Encumbrance amount approved but not posted at top task level
TOP_TASK_ENC_PENDING	NUMBER			Encumbrance amount pending for approval at top task level
TOP_TASK_ACTUAL_POSTED	NUMBER			Actual transaction amount already posted at top task level
TOP_TASK_ACTUAL_APPROVED	NUMBER			Actual transaction amount already approved but not posted at top task level
TOP_TASK_ACTUAL_PENDING	NUMBER			Actual transaction amount pending approval at top task level
TOP_TASK_RESULT_CODE	VARCHAR2	(3)		Funds check result code at top task level
REQUEST_ID	NUMBER	(15)		Standard Who column
BALANCE_POSTED_FLAG	VARCHAR2	(1)		Flag indicating the transaction updated in Grants Accounting balance
BURDEN_POSTED_FLAG	VARCHAR2	(1)		Flag indicating the burden posted to balances and summary tables
BURDENED_COST	NUMBER	(22)		Burdened Cost
FUNDS_CHECK_SEQ	NUMBER	(15)		Funds check sequence
AMOUNT_TYPE	VARCHAR2	(4)		Amount Type of Award
BOUNDARY_CODE	VARCHAR2	(2)		Boundary code of Award
BUDGET_PERIOD_START_DATE	DATE			Budget Period start date based on Amount type, boudary code & time phased code
BUDGET_PERIOD_END_DATE	DATE			Budget Period end date based on Amount type, boundary code & time phased code
CATEGORIZATION_CODE	VARCHAR2	(30)		Categorization code of budget Entry Method of project
PARENT_TASK_ID	NUMBER	(15)		Parent Task id of Task
RESOURCE_LIST_ID	NUMBER	(15)		Resource List id of Transaction
TIME_PHASED_TYPE_CODE	VARCHAR2	(1)		Time phase type code of budget Entry Method
BUDGETED_AT_RESOURCE_LEVEL	VARCHAR2	(1)		Whether budgeted at Resource or Resource Group Level
FC_ERROR_MESSAGE	VARCHAR2	(2000)		Error Message
IND_COMPILED_SET_ID	NUMBER	(15)		Indirect Compiled set Id
PERSON_ID	NUMBER	(9)		Person Id
JOB_ID	NUMBER	(15)		Job Id
VENDOR_ID	NUMBER	(15)		Vendor Id
EXPENDITURE_CATEGORY	VARCHAR2	(30)		Expenditure Category
REVENUE_CATEGORY	VARCHAR2	(30)		Revenue Category
ADJUSTED_DOCUMENT_HEADER_ID	NUMBER	(15)		The identifier of the transaction adjusted by this transaction.
AWARD_SET_ID	NUMBER	(15)		System generated number for a distribution set
TRANSACTION_SOURCE	VARCHAR2	(30)		Implementation-defined classification of a transaction loaded into PA from an external system
BURDEN_ADJUSTMENT_FLAG	VARCHAR2	(1)		Indicate this record is a burden adjustment.
BURDEN_ADJ_BC_PACKET_ID	NUMBER			bc_packet_id of the original record for which this burden adjustment has been created to maximize burden
BURDEN_CALCULATION_SEQ	NUMBER			Indicates the sequence in which record were picked for burden calculation.
TXN_INTERFACE_ID	NUMBER	(15)		System-generated number that identifies all the transactions processed by a given transaction import process request
SESSION_ID	NUMBER	(38)		Identifier of the user session
SERIAL_ID	NUMBER	(38)		Identifier of the serial number of the session
SOURCE_EVENT_ID	NUMBER	(15)		Identifier of the source event

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PACKET_ID
,      PROJECT_ID
,      AWARD_ID
,      TASK_ID
,      EXPENDITURE_TYPE
,      EXPENDITURE_ITEM_DATE
,      ACTUAL_FLAG
,      STATUS_CODE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      SET_OF_BOOKS_ID
,      JE_CATEGORY_NAME
,      JE_SOURCE_NAME
,      TRANSFERED_FLAG
,      DOCUMENT_TYPE
,      EXPENDITURE_ORGANIZATION_ID
,      PERIOD_NAME
,      PERIOD_YEAR
,      PERIOD_NUM
,      DOCUMENT_HEADER_ID
,      DOCUMENT_DISTRIBUTION_ID
,      TOP_TASK_ID
,      PARENT_RESOURCE_ID
,      BUDGET_VERSION_ID
,      RESOURCE_LIST_MEMBER_ID
,      ACCOUNT_TYPE
,      ENTERED_DR
,      ENTERED_CR
,      TOLERANCE_AMOUNT
,      TOLERANCE_PERCENTAGE
,      OVERRIDE_AMOUNT
,      EFFECT_ON_FUNDS_CODE
,      RESULT_CODE
,      GL_BC_PACKETS_ROWID
,      AWARD_BUDGET_POSTED
,      AWARD_BUDGET_APPROVED
,      AWARD_BUDGET_PENDING
,      AWARD_ENC_POSTED
,      AWARD_ENC_APPROVED
,      AWARD_ENC_PENDING
,      AWARD_ACTUAL_POSTED
,      AWARD_ACTUAL_APPROVED
,      AWARD_ACTUAL_PENDING
,      AWARD_RESULT_CODE
,      TASK_BUDGET_POSTED
,      TASK_BUDGET_APPROVED
,      TASK_BUDGET_PENDING
,      TASK_ENC_POSTED
,      TASK_ENC_APPROVED
,      TASK_ENC_PENDING
,      TASK_ACTUAL_POSTED
,      TASK_ACTUAL_APPROVED
,      TASK_ACTUAL_PENDING
,      TASK_RESULT_CODE
,      RES_GRP_BUDGET_POSTED
,      RES_GRP_BUDGET_APPROVED
,      RES_GRP_BUDGET_PENDING
,      RES_GRP_ENC_POSTED
,      RES_GRP_ENC_APPROVED
,      RES_GRP_ENC_PENDING
,      RES_GRP_ACTUAL_POSTED
,      RES_GRP_ACTUAL_APPROVED
,      RES_GRP_ACTUAL_PENDING
,      RES_GRP_RESULT_CODE
,      RES_BUDGET_POSTED
,      RES_BUDGET_APPROVED
,      RES_BUDGET_PENDING
,      RES_ENC_POSTED
,      RES_ENC_APPROVED
,      RES_ENC_PENDING
,      RES_ACTUAL_POSTED
,      RES_ACTUAL_APPROVED
,      RES_ACTUAL_PENDING
,      RES_RESULT_CODE
,      STATUS_FLAG
,      RES_BUDGET_BAL
,      RES_GRP_BUDGET_BAL
,      TASK_BUDGET_BAL
,      TOP_TASK_BUDGET_BAL
,      AWARD_BUDGET_BAL
,      GL_ROW_NUMBER
,      BC_PACKET_ID
,      PARENT_BC_PACKET_ID
,      BURDENABLE_RAW_COST
,      BUD_RESOURCE_LIST_MEMBER_ID
,      BUD_TASK_ID
,      FUNDING_PATTERN_ID
,      FUNDING_SEQUENCE
,      FP_STATUS
,      R_FUNDS_CONTROL_LEVEL_CODE
,      RG_FUNDS_CONTROL_LEVEL_CODE
,      T_FUNDS_CONTROL_LEVEL_CODE
,      TT_FUNDS_CONTROL_LEVEL_CODE
,      A_FUNDS_CONTROL_LEVEL_CODE
,      TOP_TASK_BUDGET_POSTED
,      TOP_TASK_BUDGET_APPROVED
,      TOP_TASK_BUDGET_PENDING
,      TOP_TASK_ENC_POSTED
,      TOP_TASK_ENC_APPROVED
,      TOP_TASK_ENC_PENDING
,      TOP_TASK_ACTUAL_POSTED
,      TOP_TASK_ACTUAL_APPROVED
,      TOP_TASK_ACTUAL_PENDING
,      TOP_TASK_RESULT_CODE
,      REQUEST_ID
,      BALANCE_POSTED_FLAG
,      BURDEN_POSTED_FLAG
,      BURDENED_COST
,      FUNDS_CHECK_SEQ
,      AMOUNT_TYPE
,      BOUNDARY_CODE
,      BUDGET_PERIOD_START_DATE
,      BUDGET_PERIOD_END_DATE
,      CATEGORIZATION_CODE
,      PARENT_TASK_ID
,      RESOURCE_LIST_ID
,      TIME_PHASED_TYPE_CODE
,      BUDGETED_AT_RESOURCE_LEVEL
,      FC_ERROR_MESSAGE
,      IND_COMPILED_SET_ID
,      PERSON_ID
,      JOB_ID
,      VENDOR_ID
,      EXPENDITURE_CATEGORY
,      REVENUE_CATEGORY
,      ADJUSTED_DOCUMENT_HEADER_ID
,      AWARD_SET_ID
,      TRANSACTION_SOURCE
,      BURDEN_ADJUSTMENT_FLAG
,      BURDEN_ADJ_BC_PACKET_ID
,      BURDEN_CALCULATION_SEQ
,      TXN_INTERFACE_ID
,      SESSION_ID
,      SERIAL_ID
,      SOURCE_EVENT_ID
FROM GMS.GMS_BC_PACKETS;

Dependencies

[top of page]

GMS.GMS_BC_PACKETS does not reference any database object

GMS.GMS_BC_PACKETS is referenced by following:

GMS: GMS_BC_PACKETS#