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: GL.GL_BC_PACKETS

Object Details

Object Name:	GL_BC_PACKETS
Object Type:	TABLE
Owner:	GL
FND Design Data:	SQLGL.GL_BC_PACKETS
Subobject Name:
Status:	VALID

GL_BC_PACKETS is Oracle General Ledger'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 transaction(s) you want to approve before entering it into the system. The Funds Checker program evaluates these packets and updates the RESULT_CODE column in GL_BC_PACKETS with a lookup code signifying the result of the funds check. Once a packet passes its funds check and a journal entry batch is created, the packet is removed from GL_BC_PACKETS.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	30
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GL_BC_PACKETS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CODE_COMBINATION_ID PACKET_ID
GL_BC_PACKETS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	JE_BATCH_ID
GL_BC_PACKETS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PACKET_ID JE_BATCH_ID REFERENCE2
GL_BC_PACKETS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	EVENT_ID APPLICATION_ID
GL_BC_PACKETS_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GROUP_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PACKET_ID	NUMBER	(15)	Yes	Budgetary control packet defining column
LEDGER_ID	NUMBER	(15)	Yes	Ledger defining column
JE_SOURCE_NAME	VARCHAR2	(25)	Yes	Journal entry source name
JE_CATEGORY_NAME	VARCHAR2	(25)	Yes	Journal entry category name
CODE_COMBINATION_ID	NUMBER	(15)	Yes	Key flexfield combination defining column
ACTUAL_FLAG	VARCHAR2	(1)	Yes	Balance type (Actual, Budget, or Encumbrance)
PERIOD_NAME	VARCHAR2	(15)	Yes	Accounting period
PERIOD_YEAR	NUMBER	(15)	Yes	Accounting period year
PERIOD_NUM	NUMBER	(15)	Yes	Accounting period number
QUARTER_NUM	NUMBER	(15)	Yes	Accounting period quarter
CURRENCY_CODE	VARCHAR2	(15)	Yes	Currency
STATUS_CODE	VARCHAR2	(1)	Yes	Funds check/reservation status
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
BUDGET_VERSION_ID	NUMBER	(15)		Budget version defining column
ENCUMBRANCE_TYPE_ID	NUMBER	(15)		Encumbrance type defining column
TEMPLATE_ID	NUMBER	(15)		Summary template defining column
ENTERED_DR	NUMBER			Transaction debit amount in entered currency
ENTERED_CR	NUMBER			Transaction credit amount in entered currency
ACCOUNTED_DR	NUMBER			Transaction debit amount in functional currency
ACCOUNTED_CR	NUMBER			Transaction credit amount in functional currency
USSGL_TRANSACTION_CODE	VARCHAR2	(30)		Government transaction code
ORIGINATING_ROWID	ROWID	(10)		Row id of originating budgetary or proprietary transaction for a USSGL generated budgetary or proprietary transaction
ACCOUNT_SEGMENT_VALUE	VARCHAR2	(25)		Value of key flexfield account segment
AUTOMATIC_ENCUMBRANCE_FLAG	VARCHAR2	(1)		Automatically create encumbrance batch
FUNDING_BUDGET_VERSION_ID	NUMBER	(15)		Budget version defining column of funding budget
FUNDS_CHECK_LEVEL_CODE	VARCHAR2	(1)		Funds checking severity level
AMOUNT_TYPE	VARCHAR2	(4)		Amount type (Period to date, year to date, etc.)
BOUNDARY_CODE	VARCHAR2	(1)		Budgetary control time interval end point
TOLERANCE_PERCENTAGE	NUMBER			Percentage of funding budget that can be exceeded
TOLERANCE_AMOUNT	NUMBER			Allowable amount to exceed funding budget
OVERRIDE_AMOUNT	NUMBER			Maximum transaction amount that can be used to override a funds check failure
DR_CR_CODE	VARCHAR2	(1)		Debit or credit transaction
ACCOUNT_TYPE	VARCHAR2	(1)		Key flexfield combination type (Asset, liability, ..., Budgetary Dr/Cr)
ACCOUNT_CATEGORY_CODE	VARCHAR2	(1)		Key flexfield category (Proprietary or budgetary)
EFFECT_ON_FUNDS_CODE	VARCHAR2	(1)		Effect of transaction on funds available, increasing or decreasing
RESULT_CODE	VARCHAR2	(3)		Result of funds check/reservation
BUDGET_POSTED_BALANCE	NUMBER			Posted balance used in funds available calculation
ACTUAL_POSTED_BALANCE	NUMBER			Posted balance used in funds available calculation
ENCUMBRANCE_POSTED_BALANCE	NUMBER			Posted balance used in funds available calculation
BUDGET_APPROVED_BALANCE	NUMBER			Balance approved, but not posted
ACTUAL_APPROVED_BALANCE	NUMBER			Balance approved, but not posted
ENCUMBRANCE_APPROVED_BALANCE	NUMBER			Balance approved, but not posted
BUDGET_PENDING_BALANCE	NUMBER			Balance pending funds check
ACTUAL_PENDING_BALANCE	NUMBER			Balance pending funds check
ENCUMBRANCE_PENDING_BALANCE	NUMBER			Balance pending funds check
REFERENCE1	VARCHAR2	(100)		Journal entry line reference column
REFERENCE2	VARCHAR2	(100)		Journal entry line reference column
REFERENCE3	VARCHAR2	(100)		Journal entry line reference column
REFERENCE4	VARCHAR2	(100)		Journal entry line reference column
REFERENCE5	VARCHAR2	(100)		Journal entry line reference column
JE_BATCH_NAME	VARCHAR2	(100)		Journal entry batch name
JE_BATCH_ID	NUMBER	(15)		Journal entry batch defining column
JE_HEADER_ID	NUMBER	(15)		Journal entry header defining column
JE_LINE_NUM	NUMBER	(15)		Journal entry line number
JE_LINE_DESCRIPTION	VARCHAR2	(240)		Journal entry line description
REFERENCE6	VARCHAR2	(100)		Journal entry line reference column
REFERENCE7	VARCHAR2	(100)		Journal entry line reference column
REFERENCE8	VARCHAR2	(100)		Journal entry line reference column
REFERENCE9	VARCHAR2	(100)		Journal entry line reference column
REFERENCE10	VARCHAR2	(100)		Journal entry line reference column
REFERENCE11	VARCHAR2	(100)		Journal entry line reference column
REFERENCE12	VARCHAR2	(100)		Journal entry line reference column
REFERENCE13	VARCHAR2	(100)		Journal entry line reference column
REFERENCE14	VARCHAR2	(100)		Journal entry line reference column
REFERENCE15	VARCHAR2	(100)		Journal entry line reference column
REQUEST_ID	NUMBER	(15)		Concurrent request defining column
USSGL_PARENT_ID	NUMBER	(15)		Identifier for a budgetary transaction containing a
USSGL_LINK_TO_PARENT_ID	NUMBER	(15)		Identifier of the originating budgetary transaction
EVENT_ID	NUMBER	(15)		Business Event identifier
AE_HEADER_ID	NUMBER	(15)		XLA journal entry header defining column
AE_LINE_NUM	NUMBER	(15)		XLA journal entry line defining column
BC_DATE	DATE			Validation Date used for flexfield validations (added for ER 2073811)
SOURCE_DISTRIBUTION_TYPE	VARCHAR2	(30)		Source Distribution Type
SOURCE_DISTRIBUTION_ID_CHAR_1	VARCHAR2	(240)		Source Reference Column
SOURCE_DISTRIBUTION_ID_CHAR_2	VARCHAR2	(240)		Source Reference Column
SOURCE_DISTRIBUTION_ID_CHAR_3	VARCHAR2	(240)		Source Reference Column
SOURCE_DISTRIBUTION_ID_CHAR_4	VARCHAR2	(240)		Source Reference Column
SOURCE_DISTRIBUTION_ID_CHAR_5	VARCHAR2	(240)		Source Reference Column
SOURCE_DISTRIBUTION_ID_NUM_1	NUMBER	(38)		Source Reference Column
SOURCE_DISTRIBUTION_ID_NUM_2	NUMBER	(38)		Source Reference Column
SOURCE_DISTRIBUTION_ID_NUM_3	NUMBER	(38)		Source Reference Column
SOURCE_DISTRIBUTION_ID_NUM_4	NUMBER	(38)		Source Reference Column
SOURCE_DISTRIBUTION_ID_NUM_5	NUMBER	(38)		Source Reference Column
SESSION_ID	NUMBER	(38)		Session Id of the calling session
SERIAL_ID	NUMBER	(38)		Serial# of the calling session
APPLICATION_ID	NUMBER	(15)		Source Application Id
ENTITY_ID	NUMBER	(15)		Entity Identifier
GROUP_ID	NUMBER	(15)		Interface group identifying column

Query Text

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


SELECT PACKET_ID
,      LEDGER_ID
,      JE_SOURCE_NAME
,      JE_CATEGORY_NAME
,      CODE_COMBINATION_ID
,      ACTUAL_FLAG
,      PERIOD_NAME
,      PERIOD_YEAR
,      PERIOD_NUM
,      QUARTER_NUM
,      CURRENCY_CODE
,      STATUS_CODE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      BUDGET_VERSION_ID
,      ENCUMBRANCE_TYPE_ID
,      TEMPLATE_ID
,      ENTERED_DR
,      ENTERED_CR
,      ACCOUNTED_DR
,      ACCOUNTED_CR
,      USSGL_TRANSACTION_CODE
,      ORIGINATING_ROWID
,      ACCOUNT_SEGMENT_VALUE
,      AUTOMATIC_ENCUMBRANCE_FLAG
,      FUNDING_BUDGET_VERSION_ID
,      FUNDS_CHECK_LEVEL_CODE
,      AMOUNT_TYPE
,      BOUNDARY_CODE
,      TOLERANCE_PERCENTAGE
,      TOLERANCE_AMOUNT
,      OVERRIDE_AMOUNT
,      DR_CR_CODE
,      ACCOUNT_TYPE
,      ACCOUNT_CATEGORY_CODE
,      EFFECT_ON_FUNDS_CODE
,      RESULT_CODE
,      BUDGET_POSTED_BALANCE
,      ACTUAL_POSTED_BALANCE
,      ENCUMBRANCE_POSTED_BALANCE
,      BUDGET_APPROVED_BALANCE
,      ACTUAL_APPROVED_BALANCE
,      ENCUMBRANCE_APPROVED_BALANCE
,      BUDGET_PENDING_BALANCE
,      ACTUAL_PENDING_BALANCE
,      ENCUMBRANCE_PENDING_BALANCE
,      REFERENCE1
,      REFERENCE2
,      REFERENCE3
,      REFERENCE4
,      REFERENCE5
,      JE_BATCH_NAME
,      JE_BATCH_ID
,      JE_HEADER_ID
,      JE_LINE_NUM
,      JE_LINE_DESCRIPTION
,      REFERENCE6
,      REFERENCE7
,      REFERENCE8
,      REFERENCE9
,      REFERENCE10
,      REFERENCE11
,      REFERENCE12
,      REFERENCE13
,      REFERENCE14
,      REFERENCE15
,      REQUEST_ID
,      USSGL_PARENT_ID
,      USSGL_LINK_TO_PARENT_ID
,      EVENT_ID
,      AE_HEADER_ID
,      AE_LINE_NUM
,      BC_DATE
,      SOURCE_DISTRIBUTION_TYPE
,      SOURCE_DISTRIBUTION_ID_CHAR_1
,      SOURCE_DISTRIBUTION_ID_CHAR_2
,      SOURCE_DISTRIBUTION_ID_CHAR_3
,      SOURCE_DISTRIBUTION_ID_CHAR_4
,      SOURCE_DISTRIBUTION_ID_CHAR_5
,      SOURCE_DISTRIBUTION_ID_NUM_1
,      SOURCE_DISTRIBUTION_ID_NUM_2
,      SOURCE_DISTRIBUTION_ID_NUM_3
,      SOURCE_DISTRIBUTION_ID_NUM_4
,      SOURCE_DISTRIBUTION_ID_NUM_5
,      SESSION_ID
,      SERIAL_ID
,      APPLICATION_ID
,      ENTITY_ID
,      GROUP_ID
FROM GL.GL_BC_PACKETS;

Dependencies

[top of page]

GL.GL_BC_PACKETS does not reference any database object

GL.GL_BC_PACKETS is referenced by following:

APPS: GL_BC_PACKETS