My Oracle Support Banner

Transaction Import Interface Troubleshooting Guide (Doc ID 117395.1)

Last updated on APRIL 10, 2023

Applies to:

Oracle Project Costing - Version to 12.2.4 [Release 11.5.10 to 12.2]
Information in this document applies to any platform.


The purpose of this document is to provide troubleshooting tips to anyone debugging issues with the Transaction Import Interface in Oracle Projects.

Troubleshooting Steps

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
Troubleshooting Steps
 I. Introduction
 II. Transaction Import Validation
 III. Understanding the Transaction Import Interface Table
 IV. Populating the Interface Table
 V. Import Exceptions & Errors
 Transaction Import Reports INVALID_EMPLOYEE Exceptions.
 Transaction Import Reports PA_TOO_MANY_EMPLOYEES Exceptions
 Transaction Import Reports NO_ASSIGNMENT Exceptions
 Transaction Import Reports PA_EXP_NOT_ACTIVE Exceptions
 Transaction Import Reports NO_RAW_COST Exceptions
 Transaction Import Reports CROSS_CHARGE_PROJECT_INVALID Exceptions
 When Selecting a Batch to Import from the List of Values (LOV), you get error APP-01436
 Transaction Import Errors with ORA-01422: Exact fetch returns more than requested number of rows
 Importing Timecards Via Transaction Import Errors With ORA-01400
 Transaction Import or PRC: Interface Supplier Invoices errors with "File xxx.tmp creation for FND_FILE failed"
 Rejected Transactions Not Processed After Deleting Problem Items
 Transaction Import Reports NO_MATCHING_ITEM Exceptions
 Transaction Import Reports PA_TOO_MANY_ORGN or PA_TOO_MANY_EMPLOYEES Exceptions
 When importing transactions from WebADI the process errors with ORA-06502 : PL/SQL: numeric or value error
 VI. Additional Troubleshooting Tips
 The transactions in the interface table are not getting purged after Import.
 Ensure that you have the most current version of the following files for your release and patchset level:
 Take advantage of the Oracle Communities
 V. References

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