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: PA.PA_BC_PACKETS

Object Details

Object Name:	PA_BC_PACKETS
Object Type:	TABLE
Owner:	PA
FND Design Data:	PA.PA_BC_PACKETS
Subobject Name:
Status:	VALID

PA_BC_PACKETS holds all the transactions that copied from GL_BC_PACKETS. This a type of temporary table which holds all the relevant attributes of a transaction in addition to some other attribute values which are derived before they are populated into the project balances tables. Every time funds checking routine is invoked it purges all the records that were created before a specific period of time which is specified by a profile option and provided update budgetary control balances program is run on those records to transfer them to project balances.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_BC_PACKETS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PACKET_ID BC_PACKET_ID
PA_BC_PACKETS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PROJECT_ID TASK_ID EXPENDITURE_ITEM_DATE TOP_TASK_ID PARENT_RESOURCE_ID
PA_BC_PACKETS_N10	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REQUEST_ID
PA_BC_PACKETS_N11	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BC_EVENT_ID
PA_BC_PACKETS_N12	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SOURCE_EVENT_ID
PA_BC_PACKETS_N13	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BUDGET_VERSION_ID BUD_RESOURCE_LIST_MEMBER_ID PERIOD_NAME STATUS_CODE
PA_BC_PACKETS_N14	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BUDGET_VERSION_ID BUD_TASK_ID BUD_RESOURCE_LIST_MEMBER_ID PERIOD_NAME STATUS_CODE
PA_BC_PACKETS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RESULT_CODE
PA_BC_PACKETS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	STATUS_CODE
PA_BC_PACKETS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DOCUMENT_HEADER_ID DOCUMENT_DISTRIBUTION_ID
PA_BC_PACKETS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DOCUMENT_TYPE
PA_BC_PACKETS_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RESOURCE_LIST_MEMBER_ID
PA_BC_PACKETS_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PARENT_BC_PACKET_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PACKET_ID	NUMBER	(15)	Yes	Budgetary control packet identifier
PROJECT_ID	NUMBER	(15)	Yes	Project identifier
TASK_ID	NUMBER	(15)	Yes	Task identifier
EXPENDITURE_TYPE	VARCHAR2	(30)	Yes	Expenditure type for which this transaction was created
EXPENDITURE_ITEM_DATE	DATE		Yes	Date for which the transaction was charged
SET_OF_BOOKS_ID	NUMBER	(15)	Yes	Ledger identifier in General Ledger.
JE_CATEGORY_NAME	VARCHAR2	(30)	Yes	Journal entry category name
JE_SOURCE_NAME	VARCHAR2	(30)	Yes	Journal entry source name
STATUS_CODE	VARCHAR2	(1)	Yes	Funds check or reservation status. The valid values are based on lookup type
DOCUMENT_TYPE	VARCHAR2	(10)	Yes	Indicates the amount type for any of these categories
FUNDS_PROCESS_MODE	VARCHAR2	(1)	Yes	Indicates what type of processing the record is created for: T => Transaction Processing B => Budget Baselining
EXPENDITURE_ORGANIZATION_ID	NUMBER	(15)	Yes	Expenditure organization identifier
DOCUMENT_HEADER_ID	NUMBER	(15)	Yes	Document header identifier.
DOCUMENT_DISTRIBUTION_ID	NUMBER	(15)	Yes	Document distribution identifier
BUDGET_VERSION_ID	NUMBER	(15)	Yes	The budget version to which this transaction maps.
BURDEN_COST_FLAG	VARCHAR2	(1)	Yes	Temporary flag used during processing to identify burden lines. Valid values are "O", "R" and "N"
BC_PACKET_ID	NUMBER	(15)	Yes	Budget control record identifier
BALANCE_POSTED_FLAG	VARCHAR2	(1)	Yes	Flag indicating whether the transaction posted to the project balances
ACTUAL_FLAG	VARCHAR2	(1)	Yes	Indicates the balance type: A => Actual E => Encumbrance
GL_DATE	DATE			The end date of the GL period in which the costs were posted.
PA_DATE	DATE			The end date of the PA period in which the costs were posted.
PERIOD_NAME	VARCHAR2	(15)		The name of the accounting period in which the transaction was created
PERIOD_YEAR	NUMBER			The year in the accounting period when the transaction was created
PERIOD_NUM	NUMBER			The number of the accounting period in which the transaction was created
BC_COMMITMENT_ID	NUMBER	(15)		The unique identifier of the commitment when it was copied into this table.
ENCUMBRANCE_TYPE_ID	NUMBER	(15)		Commitment encumbrance type identifier used during processing
PROJ_ENCUMBRANCE_TYPE_ID	NUMBER	(15)		Project encumbrance type identifier used during processing.
TOP_TASK_ID	NUMBER	(15)		Top task identifier
PARENT_RESOURCE_ID	NUMBER	(15)		Resource group identifier
RESOURCE_LIST_MEMBER_ID	NUMBER	(15)		Resource list member identifier
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 accounting currency
ACCOUNTED_CR	NUMBER			Transaction credit amount in accounting currency
EFFECT_ON_FUNDS_CODE	VARCHAR2	(1)		Increasing or decreasing effect of the transaction on the funds available.
RESULT_CODE	VARCHAR2	(5)		Result of the funds check or reservation.
TASK_BUDGET_POSTED	NUMBER			Budget amount for the task posted to the project balances.
TASK_ENC_POSTED	NUMBER			Encumbrance amount for the task posted to the project balances
TASK_ENC_APPROVED	NUMBER			Encumbrance amount approved for the task.
TASK_ACTUAL_POSTED	NUMBER			Actual amount for the task posted to the project balances.
TASK_ACTUAL_APPROVED	NUMBER			Actual amount approved for the task.
TASK_RESULT_CODE	VARCHAR2	(5)		The result code of the funds check at the task level.
RES_GRP_BUDGET_POSTED	NUMBER			Budget amount for the resource group posted to the project balances
RES_GRP_ENC_POSTED	NUMBER			Encumbrance amount for the resource group posted to the project balances
RES_GRP_ENC_APPROVED	NUMBER			Encumbrance amount approved for the resource group.
RES_GRP_ACTUAL_POSTED	NUMBER			Actual amount for the resource group posted to the project balances
RES_GRP_ACTUAL_APPROVED	NUMBER			Actual amount approved for the resource group.
RES_GRP_RESULT_CODE	VARCHAR2	(5)		The result code of the funds check at the resource group level.
RES_BUDGET_POSTED	NUMBER			Budget amount at the resource level posted to the project balances.
RES_ENC_POSTED	NUMBER			Encumbrance amount for the resource posted to the project balances.
RES_ENC_APPROVED	NUMBER			Encumbrance amount approved at the resource level.
RES_ACTUAL_POSTED	NUMBER			Actual amount at the resource level posted to the project balances
RES_ACTUAL_APPROVED	NUMBER			Actual amount approved at the resource level.
RES_RESULT_CODE	VARCHAR2	(5)		The result code of the funds check at the resource level.
RES_BUDGET_BAL	NUMBER			Budget balance at the resource level after funds check
RES_GRP_BUDGET_BAL	NUMBER			Budget balance at the resource group level after funds check.
TASK_BUDGET_BAL	NUMBER			Budget balance at the task level after funds check.
TOP_TASK_BUDGET_BAL	NUMBER			Budget balance at the top task level after funds check.
PROJECT_BUDGET_BAL	NUMBER			Project level budget balance after funds check
GL_ROW_NUMBER	VARCHAR2	(30)		Value of the row id in GL_BC_PACKETS when the record is copied from GL_BC_PACKETS.
PARENT_BC_PACKET_ID	NUMBER	(15)		This column is populated if the transaction is a burden cost. It is populated with the bc packet id of the source.
BUD_RESOURCE_LIST_MEMBER_ID	NUMBER	(15)		Budgeted resource list member identifier
BUD_TASK_ID	NUMBER	(15)		Budgeted task identifier
R_FUNDS_CONTROL_LEVEL_CODE	VARCHAR2	(1)		Funds control level at resource level.
RG_FUNDS_CONTROL_LEVEL_CODE	VARCHAR2	(1)		Funds control level at resource group level.
T_FUNDS_CONTROL_LEVEL_CODE	VARCHAR2	(1)		Funds control level at task level.
TT_FUNDS_CONTROL_LEVEL_CODE	VARCHAR2	(1)		Funds control level at top task level. This value is based on lookup type
P_FUNDS_CONTROL_LEVEL_CODE	VARCHAR2	(1)		Funds control level at project level. This value is based on lookup type
TOP_TASK_BUDGET_POSTED	NUMBER			Budget amount for the top task posted to the project balances
TOP_TASK_ENC_POSTED	NUMBER			The amount of the task encumbrance posted to the project balances
TOP_TASK_ENC_APPROVED	NUMBER			Encumbrance amount approved for the top task.
TOP_TASK_ACTUAL_POSTED	NUMBER			Actual amount for the top task posted to the project balances
TOP_TASK_ACTUAL_APPROVED	NUMBER			Actual amount approved for the top task.
TOP_TASK_RESULT_CODE	VARCHAR2	(5)		The result code of the funds check at the top task level.
PROJECT_BUDGET_POSTED	NUMBER			Budget amount for the project posted to the project balances
PROJECT_ENC_POSTED	NUMBER			Encumbrance amount for the project posted to the project balances
PROJECT_ENC_APPROVED	NUMBER			Encumbrance amount approved for the project.
PROJECT_ACTUAL_POSTED	NUMBER			Actual amount for the project posted to the project balances.
PROJECT_ACTUAL_APPROVED	NUMBER			Actual amount approved for the project.
PROJECT_RESULT_CODE	VARCHAR2	(5)		The result code of the funds check at the project level.
PROJECT_ACCT_RESULT_CODE	VARCHAR2	(5)		The result code of the funds check at the project level for each account if the Projects budget is integrated to an external budget.
REQUEST_ID	NUMBER	(15)		Request identifier for a concurrent program
BUDGET_CCID	NUMBER	(15)		The account of the budget line to which the commitment was mapped.
OLD_BUDGET_CCID	NUMBER	(15)		The account of the budget line to which the commitment was mapped.
TXN_CCID	NUMBER	(15)		The account in which the actual / commitment transaction was posted.
ORG_ID	NUMBER	(15)		The operating unit in which this transaction was created.
ENCUMBRANCE_AMOUNT	NUMBER			The encumbrance amount
PROGRAM_ID	NUMBER	(15)		Standard Who Column
PROGRAM_APPLICATION_ID	NUMBER	(15)		Standard Who Column
PROGRAM_UPDATE_DATE	DATE			Standard Who Column
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)		Standard Who Column
DOCUMENT_LINE_ID	NUMBER	(15)		Document line identifier
COMPILED_MULTIPLIER	NUMBER			Compiled Burden multiplier
FC_START_DATE	DATE			Funds Check Start Date
FC_END_DATE	DATE			Funds Check End Date
EXT_BDGT_FLAG	VARCHAR2	(1)		Flag that indicates whether the project budget is linked to an external budget
COMM_TOT_RAW_AMT	NUMBER			Total raw cost for the commitment
COMM_TOT_BD_AMT	NUMBER			Total burden cost for the commitment
COMM_RAW_AMT_RELIEVED	NUMBER			Sum of the commitment raw cost relieved
COMM_BD_AMT_RELIEVED	NUMBER			Sum of the commitment burden cost relieved
SUMMARY_RECORD_FLAG	VARCHAR2	(1)		Flag to indicate that the record is summarized by purchase order line, project, task, and expenditure type
EXP_ITEM_ID	NUMBER	(15)		Expenditure item identifier
REFERENCE1	VARCHAR2	(100)		Funds check transaction Reference column
REFERENCE2	VARCHAR2	(100)		Funds check transaction Reference column
REFERENCE3	VARCHAR2	(100)		Funds check transaction Reference column
FUNDS_PROCESSING_SEQ	NUMBER	(15)		Funds processing sequence
TXN_INTERFACE_ID	NUMBER	(15)		Transaction Interfaced Identifier
BC_EVENT_ID	NUMBER	(15)		Identifier of the budgetary control event
SESSION_ID	NUMBER	(38)		Identifier of user session
SERIAL_ID	NUMBER	(38)		Identifier of the serial number of the session
BUDGET_LINE_ID	NUMBER	(15)		Identifier of the budget line of the transaction
VENDOR_ID	NUMBER	(15)		Identifier of the supplier
BURDEN_METHOD_CODE	VARCHAR2	(30)		Indicates the burden method of the project
MAIN_OR_BACKING_CODE	VARCHAR2	(30)		Identifies whether the transaction is a main transaction or a reversal
SOURCE_EVENT_ID	NUMBER	(15)		Identifier of the source event
DOCUMENT_HEADER_ID_2	NUMBER	(15)		Second document header identifieR
DOCUMENT_DISTRIBUTION_TYPE	VARCHAR2	(30)		Document distribution type

Query Text

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


SELECT PACKET_ID
,      PROJECT_ID
,      TASK_ID
,      EXPENDITURE_TYPE
,      EXPENDITURE_ITEM_DATE
,      SET_OF_BOOKS_ID
,      JE_CATEGORY_NAME
,      JE_SOURCE_NAME
,      STATUS_CODE
,      DOCUMENT_TYPE
,      FUNDS_PROCESS_MODE
,      EXPENDITURE_ORGANIZATION_ID
,      DOCUMENT_HEADER_ID
,      DOCUMENT_DISTRIBUTION_ID
,      BUDGET_VERSION_ID
,      BURDEN_COST_FLAG
,      BC_PACKET_ID
,      BALANCE_POSTED_FLAG
,      ACTUAL_FLAG
,      GL_DATE
,      PA_DATE
,      PERIOD_NAME
,      PERIOD_YEAR
,      PERIOD_NUM
,      BC_COMMITMENT_ID
,      ENCUMBRANCE_TYPE_ID
,      PROJ_ENCUMBRANCE_TYPE_ID
,      TOP_TASK_ID
,      PARENT_RESOURCE_ID
,      RESOURCE_LIST_MEMBER_ID
,      ENTERED_DR
,      ENTERED_CR
,      ACCOUNTED_DR
,      ACCOUNTED_CR
,      EFFECT_ON_FUNDS_CODE
,      RESULT_CODE
,      TASK_BUDGET_POSTED
,      TASK_ENC_POSTED
,      TASK_ENC_APPROVED
,      TASK_ACTUAL_POSTED
,      TASK_ACTUAL_APPROVED
,      TASK_RESULT_CODE
,      RES_GRP_BUDGET_POSTED
,      RES_GRP_ENC_POSTED
,      RES_GRP_ENC_APPROVED
,      RES_GRP_ACTUAL_POSTED
,      RES_GRP_ACTUAL_APPROVED
,      RES_GRP_RESULT_CODE
,      RES_BUDGET_POSTED
,      RES_ENC_POSTED
,      RES_ENC_APPROVED
,      RES_ACTUAL_POSTED
,      RES_ACTUAL_APPROVED
,      RES_RESULT_CODE
,      RES_BUDGET_BAL
,      RES_GRP_BUDGET_BAL
,      TASK_BUDGET_BAL
,      TOP_TASK_BUDGET_BAL
,      PROJECT_BUDGET_BAL
,      GL_ROW_NUMBER
,      PARENT_BC_PACKET_ID
,      BUD_RESOURCE_LIST_MEMBER_ID
,      BUD_TASK_ID
,      R_FUNDS_CONTROL_LEVEL_CODE
,      RG_FUNDS_CONTROL_LEVEL_CODE
,      T_FUNDS_CONTROL_LEVEL_CODE
,      TT_FUNDS_CONTROL_LEVEL_CODE
,      P_FUNDS_CONTROL_LEVEL_CODE
,      TOP_TASK_BUDGET_POSTED
,      TOP_TASK_ENC_POSTED
,      TOP_TASK_ENC_APPROVED
,      TOP_TASK_ACTUAL_POSTED
,      TOP_TASK_ACTUAL_APPROVED
,      TOP_TASK_RESULT_CODE
,      PROJECT_BUDGET_POSTED
,      PROJECT_ENC_POSTED
,      PROJECT_ENC_APPROVED
,      PROJECT_ACTUAL_POSTED
,      PROJECT_ACTUAL_APPROVED
,      PROJECT_RESULT_CODE
,      PROJECT_ACCT_RESULT_CODE
,      REQUEST_ID
,      BUDGET_CCID
,      OLD_BUDGET_CCID
,      TXN_CCID
,      ORG_ID
,      ENCUMBRANCE_AMOUNT
,      PROGRAM_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      DOCUMENT_LINE_ID
,      COMPILED_MULTIPLIER
,      FC_START_DATE
,      FC_END_DATE
,      EXT_BDGT_FLAG
,      COMM_TOT_RAW_AMT
,      COMM_TOT_BD_AMT
,      COMM_RAW_AMT_RELIEVED
,      COMM_BD_AMT_RELIEVED
,      SUMMARY_RECORD_FLAG
,      EXP_ITEM_ID
,      REFERENCE1
,      REFERENCE2
,      REFERENCE3
,      FUNDS_PROCESSING_SEQ
,      TXN_INTERFACE_ID
,      BC_EVENT_ID
,      SESSION_ID
,      SERIAL_ID
,      BUDGET_LINE_ID
,      VENDOR_ID
,      BURDEN_METHOD_CODE
,      MAIN_OR_BACKING_CODE
,      SOURCE_EVENT_ID
,      DOCUMENT_HEADER_ID_2
,      DOCUMENT_DISTRIBUTION_TYPE
FROM PA.PA_BC_PACKETS;

Dependencies

[top of page]

PA.PA_BC_PACKETS does not reference any database object

PA.PA_BC_PACKETS is referenced by following:

PA: PA_BC_PACKETS#