Understanding the Transaction Import Interface Table
You use an import utility to load transaction information into the interface table (PA_TRANSACTION_INTERFACE_ALL) for each transaction you want to create. When you initiate importing transactions, Transaction Import validates all required transaction data in this table. After it validates the information, Transaction Import creates transactions (expenditure items) from the information in the interface table and places the transaction information in the following expenditure tables:
- PA_EXPENDITURE_GROUPS_ALL
- PA_COST_DISTRIBUTION_LINES_ALL
The interface table is organized by columns which Oracle Projects uses to categorize and store specific transaction information. For example, the column called TRANSACTION_SOURCE in PA_TRANSACTION_INTERFACE_ALL stores transaction source information.
NOT NULL Columns
You must enter values for all NOT NULL columns in the interface table to successfully create expenditures from your imported transaction data.
NULL Columns
A NULL column is a column in the interface table that does not require a value for Transaction Import to successfully create transactions from the records in the table. There are two types of NULL columns:
- Some NULL columns are NULL only because they are not required for all transactions. They are required, however, depending on the type of transaction. For example, for usage items, the NON_LABOR_RESOURCE column must be populated. We mark these columns as Conditionally Required.
- Some NULL columns should never be populated because they are used by the Transaction Import program. We list these columns in the System Assigned Columns section.
Conditionally Required Columns
Oracle Projects requires you to enter values in conditionally required columns only if you have entered a value in another column on which the columns are dependent. For example, if you are importing usage expenditure items, you must supply a value for the NON_LABOR_RESOURCE and NON_LABOR_RESOURCE_ORGANIZATION columns; these columns are not required for labor expenditure items. See: PA_TRANSACTION_INTERFACE_ALL Table Description.
Optional Columns
You can use some columns in the interface table to import additional information for the transactions that Transaction Import creates. Transaction Import imports the data that you load into these optional columns, provided that the information passes the validation checks that Transaction Import requires.
System Assigned Columns
Oracle Projects assigns values to the columns listed below during the import process. Your import file must leave these columns blank.
- TRANSACTION_REJECTION_CODE
- TRANSACTION_REJECTION_REASON
Defaulted Column
If a transaction does not have an expenditure type class assigned to it, Oracle Projects uses the expenditure type class assigned to the item's transaction source as the default value.
Additional Transaction Interface Tables
Oracle Projects uses the PA_TRANSACTION_ XFACE_CTRL_ALL table to control processing of transactions by the Transaction Import program. You must not insert or update records in this table directly. This table is populated by database triggers when you load or update the PA_TRANSACTION_INTERFACE table.
See Also
PA_TRANSACTION_INTERFACE_ALL Table Description
