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_TRANSACTION_SOURCES

Object Details

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

PA_TRANSACTION_SOURCES stores implementation-defined
classifications for transactions originating in an external system
and imported into Oracle Projects via the Transaction
Import program. The Transaction Import program uses the transaction
source classification to drive certain processing, such as
what validation procedures are applicable for an interface item and
whether the transaction record is purged from
PA_TRANSACTION_INTERFACE_ALL
when successfully imported.
The transaction source classification is stored in the expenditure
items created in Oracle Projects and is used by Oracle
Project's adjustment modules to determine the correct
processing outcome when adjusting imported items.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_TRANSACTION_SOURCES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	TRANSACTION_SOURCE ZD_EDITION_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
TRANSACTION_SOURCE	VARCHAR2	(30)	Yes	Implementation-defined classification of a transaction loaded into PA from an external system
SYSTEM_LINKAGE_FUNCTION	VARCHAR2	(30)	Yes	The system-defined system linkage function that identifies the type of transaction, such as Labor, Expense Reports, or Usages, in order to drive certain processing by the Transaction Import program
COSTED_FLAG	VARCHAR2	(1)	Yes	Flag that indicates whether transactions classified by the transaction source are already costed (raw cost only) when loaded into Oracle Projects
PURGEABLE_FLAG	VARCHAR2	(1)	Yes	Flag that indicates whether transactions classified by the transaction source are automatically purged from the interface table once successfully imported into Oracle Projects
START_DATE_ACTIVE	DATE		Yes	First effective date of the transaction source
END_DATE_ACTIVE	DATE			Last effective date of the transaction source
DESCRIPTION	VARCHAR2	(240)		User-entered comment that describes the transaction source
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who Column
CREATION_DATE	DATE		Yes	Standard Who Column
CREATED_BY	NUMBER	(15)	Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes	Standard Who Column
USER_TRANSACTION_SOURCE	VARCHAR2	(80)	Yes	Displayed name to uniquely identify the transaction source, which may be translated.
PREDEFINED_FLAG	VARCHAR2	(1)	Yes	Flag to identify if the transaction source is predefined or not. For user-defined transaction sources, this value is always set to N. This value is not displayed on any form or report.
ALLOW_ADJUSTMENTS_FLAG	VARCHAR2	(1)	Yes	Flag to specify if you can perform adjustments in Oracle Projects for expenditures imported with this transaction source
GL_ACCOUNTED_FLAG	VARCHAR2	(1)	Yes	Flag to specify if expenditures are already accounted for in an external system. If Y, then Oracle Projects requires the entry of debit and credit code combination ID in the interface table.
ALLOW_DUPLICATE_REFERENCE_FLAG	VARCHAR2	(1)	Yes	Flag to specify whether to allow duplicate values for the original system reference within this transaction source.
SKIP_TC_VALIDATION_FLAG	VARCHAR2	(1)	Yes	Flag to specify if Transaction Import should skip the validation of transaction controls because the expenditure was already validated by another Oracle Applications system. This flag is for internal use only.
COST_BURDENED_FLAG	VARCHAR2	(1)	Yes	This column is obsolete
MC_AMOUNTS_POPULATED	VARCHAR2	(1)		This flag is used in Multiple Reporting currency implementations. A value of "Y" denotes that Oracle Projects currency exchange rates are to be used for transactions imported from external systems.
MODIFY_INTERFACE_FLAG	VARCHAR2	(1)		Flag to allow update on the transactions from this source in Pa_Transaction_Interface table
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield context field
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
ALLOW_EMP_ORG_OVERRIDE_FLAG	VARCHAR2	(1)		Flag that indicates whether an expenditure organization can be imported. This flag is not applicable to non-employee transactions.
ALLOW_BURDEN_FLAG	VARCHAR2	(1)	Yes	Flag that indicates that external system will provide burdened costs.
ALLOW_REVERSAL_FLAG	VARCHAR2	(1)	Yes	Flag that indicates whether reversals are allowed.
CC_PROCESS_FLAG	VARCHAR2	(1)	Yes	Flag that indicates whether cross charging processing is to be performed for transactions from the source within Oracle Projects. Default value is Y
PRE_PROCESSING_EXTENSION	VARCHAR2	(60)		User-defined name of the client extension to be called by Transaction Import prior to importing the items into Oracle Projects The values in this column will be in the format PackageNameProcedureName
POST_PROCESSING_EXTENSION	VARCHAR2	(60)		User-defined name of the client extension to be called by Transaction Import following import of the items into Oracle Projects The values in this column will be in the format PackageNameProcedureName
PROCESS_FUNDS_CHECK	VARCHAR2	(1)		This flag is used to determine if funds check is required for transaction that is being imported .
BATCH_SIZE	NUMBER			Processing Batch Size.
POSTED_FLAG	VARCHAR2	(1)		This column indicates if the transactions imported using this transaction source have been posted to GL.
ACCT_SOURCE_CODE	VARCHAR2	(10)		Acct Source Code
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

Query Text

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


SELECT TRANSACTION_SOURCE
,      SYSTEM_LINKAGE_FUNCTION
,      COSTED_FLAG
,      PURGEABLE_FLAG
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      DESCRIPTION
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      USER_TRANSACTION_SOURCE
,      PREDEFINED_FLAG
,      ALLOW_ADJUSTMENTS_FLAG
,      GL_ACCOUNTED_FLAG
,      ALLOW_DUPLICATE_REFERENCE_FLAG
,      SKIP_TC_VALIDATION_FLAG
,      COST_BURDENED_FLAG
,      MC_AMOUNTS_POPULATED
,      MODIFY_INTERFACE_FLAG
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ALLOW_EMP_ORG_OVERRIDE_FLAG
,      ALLOW_BURDEN_FLAG
,      ALLOW_REVERSAL_FLAG
,      CC_PROCESS_FLAG
,      PRE_PROCESSING_EXTENSION
,      POST_PROCESSING_EXTENSION
,      PROCESS_FUNDS_CHECK
,      BATCH_SIZE
,      POSTED_FLAG
,      ACCT_SOURCE_CODE
,      ZD_EDITION_NAME
FROM PA.PA_TRANSACTION_SOURCES;

Dependencies

[top of page]

PA.PA_TRANSACTION_SOURCES does not reference any database object

PA.PA_TRANSACTION_SOURCES is referenced by following:

PA: PA_TRANSACTION_SOURCES#