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: TableSQLGL.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: TablespaceAPPS_TS_TX_DATA
PCT Free: 30
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
GL_BC_PACKETS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCODE_COMBINATION_ID
ColumnPACKET_ID
GL_BC_PACKETS_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnJE_BATCH_ID
GL_BC_PACKETS_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPACKET_ID
ColumnJE_BATCH_ID
ColumnREFERENCE2
GL_BC_PACKETS_N5 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnEVENT_ID
ColumnAPPLICATION_ID
GL_BC_PACKETS_N6 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnGROUP_ID
GL_BC_PACKETS_N7 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnRESULT_CODE
ColumnSERIAL_ID
ColumnSESSION_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) Yes Session Id of the calling session
SERIAL_ID NUMBER (38) Yes Serial# of the calling session
APPLICATION_ID NUMBER (15) Yes 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:

SchemaGL
ViewGL_BC_PACKETS#