My Oracle Support Banner

Transaction Import - Frequently Asked Questions (Doc ID 116581.1)

Last updated on JUNE 21, 2023

Applies to:

Oracle Project Costing - Version to 12.1.3 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.
Report:PAXTRTRX.RDF - PRC: Transaction Import
Form:PAXTRIMP.FMB - Review Rejection Form


This document addresses common questions related to the use of the Transaction Import open interface of the Projects Suite.

Questions and Answers

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Questions and Answers
 1. Is it possible to enter expenditure batches using Web Applications Desktop Integrator (Web ADI)?
 2. Why do I receive a "FRM-40200: Field is protected against update" error when I attempt to update imported transactions via the Pre-Approved Batch Entry form?
 3. Why am I unable to update and correct rejected transaction in the interface table via the Review Transactions form?
 4. What tables are updated during transaction import?
 5. Can the database trigger PA_TRANSACTION_IMPORT_T1 be disabled or altered?
 6. Does Transaction Import purge all rows from the transaction interface tables?
 7. How does the import process create transactions for a selected source when there are no batches for that source in the interface table?
 8. What Value Is Stored In The Orig_Transaction_Reference Field in PA_EXPENDITURE_ITEMS for Items with source AP EXPENSE, Oracle Time and Labor or Time Management?
 9. Is the BILLABLE_FLAG for imported expenditures updated based on transaction controls?
 10. Can auto-reversing expenditure batches be created with transaction import?
 11. Can a seeded transaction source be used to interface data from a legacy system?
 12. How does Transaction Import treat expenditures imported into closed periods?
 13. Does the EXPENDITURE_ENDING_DATE have to be the last day of the expenditure week?
 14. Can you import tranasctions for an employee if they are not assigned to an active expenditure organization?
 15. What are the CDL_SYSTEM_REFERENCE (1-5) fields used for?
 16. What is the purpose of the fields ORIG_EXP_TXN_REFERENCE (1-3)  and ORIG_USER_EXP_TXN_REFERENCE?

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.