Previous  Next          Contents  Index  Navigation  Glossary  Library

Transaction Import Validation

Transaction Import validates your data for compatibility with Oracle Projects by ensuring that the columns in the interface table reference the appropriate and active values and columns in Oracle Projects.

Validating Expenditure Items

Transaction Import validates all items within an expenditure before it creates an expenditure. If at least one item in an expenditure fails the validation, Oracle Projects rejects all items in the expenditure. The item that failed is marked with a rejection reason; all other items in the expenditure are marked as rejected without a reason.

Transaction Import detects only one error per transaction each time you run the import process. If a single transaction has multiple errors, you will need to run Transaction Import more than once to discover all the errors.

You can correct rejected transactions using the Review Transactions window. After you make your corrections, you can validate the revised information by resubmitting the corrected transactions from the same window. See: Resolving Import Exceptions.

If Transaction Import detects errors during the validation process, you do not need to correct all rejected items to save your transaction information. You need to correct all items, however, before you can successfully import your transactions.

Validating and Loading Transactions

Transaction Import validates the following attributes to ensure that your transactions contain the appropriate data for Oracle Projects. For a list of the validation criteria, see: Expenditure Item Validation.

Note: For detailed information on additional column validation, see: PA_TRANSACTION_INTERFACE_ALL Table Description.

         Previous  Next          Contents  Index  Navigation  Glossary  Library