Previous  Next          Contents  Index  Navigation  Glossary  Library

Transaction Import

The Transaction Import process selects all eligible pending transactions in the PA_TRANSACTION_INTERFACE_ALL table that satisfy the selection criteria of the process request and determines the validity of each transaction.

For each valid transaction, Transaction Import imports the transactions and creates corresponding expenditure records in the Oracle Projects expenditure tables; expenditure records include expenditure batches, expenditures, and expenditure items. For each invalid transaction, Transaction Import rejects the transaction and updates the transaction in the interface table with a status of Rejected and the rejection reason. You should update rejected items in the interface tables or your external system and import the transactions again.

If the transaction source for the Transaction Import is purgeable, Transaction Import deletes the corresponding transactions from the interface table. If the transaction source is not purgeable, Transaction Import updates the status of the corresponding transaction in the interface table with a status of Accepted.

For detailed information on importing data into Oracle Projects using Transaction Import, including interface table descriptions, refer to the following essay: Overview of Transaction Import.

Process Submission

You submit the PRC: Transaction Import process from the Submit Request window. See: Submitting Requests.

Process Parameters

Transaction Source. Enter the transaction source for the transactions that you want to import into Oracle Projects.

Batch Name. Enter the name of a specific batch of transaction that you want to import into Oracle Projects. You can choose only batches having the transaction source specified for the Transaction Source parameter.

Suggestion: For increased performance, submit several concurrent Transaction Import requests specifying different batch names rather than submitting one request for a particular transaction source.

Output Reports

Two output reports show you the results of this process:

Attention: If any one expenditure item in an expenditure fails validation, Oracle Projects rejects the entire expenditure and updates each expenditure item in the expenditure with a status of R (Rejected). You can locate all of the related rejected transactions within an expenditure batch by using a SQL*Plus select statement on the EXPENDITURE_ID column using the expenditure id of the rejected item; then update the TRANSACTION_ STATUS_CODE column to remove the R status. Or you can re-import the corrected items, Oracle Projects creates a new record for the expenditure items instead of updating the existing records that were rejected.

Suggestion: If you want to view more detailed information about the expenditures created in Oracle Projects, submit the AUD: Pre-Approved Expenditures Entry Audit report.

         Previous  Next          Contents  Index  Navigation  Glossary  Library