PJF_TXN_SOURCES_B
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.
Details
-
Schema: FUSION
-
Object owner: PJF
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
PJF_TXN_SOURCES_B_PK |
TRANSACTION_SOURCE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping |
|---|---|---|---|---|---|---|
| TRANSACTION_SOURCE_ID | NUMBER | 18 | Yes | Uniquely identifies the transaction source row. | ||
| 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 | |||
| BATCH_SIZE | NUMBER | 18 | Yes | Indicates the number of records to be processed in each set for this transaction source. | ||
| TRANSACTION_SOURCE | VARCHAR2 | 30 | Yes | Implementation-defined classification of a transaction loaded into PA from an external system. This is defaulted to TRANSACTION_SOURCE_ID for user-defined sources. | ||
| 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. | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | |||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | |||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | |||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Transaction Source Descriptive Flexfield (PJF_TXN_SOURCE_DESC_FLEX) | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transaction Source Descriptive Flexfield (PJF_TXN_SOURCE_DESC_FLEX) | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transaction Source Descriptive Flexfield (PJF_TXN_SOURCE_DESC_FLEX) | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transaction Source Descriptive Flexfield (PJF_TXN_SOURCE_DESC_FLEX) | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transaction Source Descriptive Flexfield (PJF_TXN_SOURCE_DESC_FLEX) | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transaction Source Descriptive Flexfield (PJF_TXN_SOURCE_DESC_FLEX) | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transaction Source Descriptive Flexfield (PJF_TXN_SOURCE_DESC_FLEX) | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transaction Source Descriptive Flexfield (PJF_TXN_SOURCE_DESC_FLEX) | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transaction Source Descriptive Flexfield (PJF_TXN_SOURCE_DESC_FLEX) | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transaction Source Descriptive Flexfield (PJF_TXN_SOURCE_DESC_FLEX) | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transaction Source Descriptive Flexfield (PJF_TXN_SOURCE_DESC_FLEX) | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transaction Source Descriptive Flexfield (PJF_TXN_SOURCE_DESC_FLEX) | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transaction Source Descriptive Flexfield (PJF_TXN_SOURCE_DESC_FLEX) | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transaction Source Descriptive Flexfield (PJF_TXN_SOURCE_DESC_FLEX) | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transaction Source Descriptive Flexfield (PJF_TXN_SOURCE_DESC_FLEX) | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transaction Source Descriptive Flexfield (PJF_TXN_SOURCE_DESC_FLEX) | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | ||
| SEED_DATA_SOURCE | VARCHAR2 | 512 | Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file. | |||
| ORA_SEED_SET1 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N. | ||
| ORA_SEED_SET2 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| pjc_txn_xface_ctrl_all | pjf_txn_sources_b | TRANSACTION_SOURCE_ID |
| pjf_txn_document_b | pjf_txn_sources_b | TRANSACTION_SOURCE_ID |
| pjc_exp_items_all | pjf_txn_sources_b | TRANSACTION_SOURCE_ID |
| pjf_txn_sources_tl | pjf_txn_sources_b | TRANSACTION_SOURCE_ID |
| pjc_exp_groups_all | pjf_txn_sources_b | TRANSACTION_SOURCE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PJF_TXN_SOURCES_B_U1 | Unique | Default | TRANSACTION_SOURCE_ID, ORA_SEED_SET1 |
| PJF_TXN_SOURCES_B_U11 | Unique | Default | TRANSACTION_SOURCE_ID, ORA_SEED_SET2 |
| PJF_TXN_SOURCES_B_U2 | Unique | Default | TRANSACTION_SOURCE, TRANSACTION_SOURCE_ID, ORA_SEED_SET1 |
| PJF_TXN_SOURCES_B_U21 | Unique | Default | TRANSACTION_SOURCE, TRANSACTION_SOURCE_ID, ORA_SEED_SET2 |