Transaction Import Interface Troubleshooting Guide
(Doc ID 117395.1)
Last updated on APRIL 10, 2023
Applies to:
Oracle Project Costing - Version 11.5.10.2 to 12.2.4 [Release 11.5.10 to 12.2]Information in this document applies to any platform.
Purpose
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
| Purpose |
| 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 |
| References |