PRC: Transaction Import Error ORA-20002: pre_import:ORA-01422
(Doc ID 1359353.1)
Last updated on JUNE 21, 2023
Applies to:
Oracle Project Costing - Version 11.5.10.2 and laterInformation in this document applies to any platform.
Report:PAXTRTRX.RDF - PRC: Transaction Import
Symptoms
PRC: Transaction Import for OTL Timecards
ERROR
-----------------------
MSG-20002: ORA-20002: pre_import:ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "APPS.PA_TRX_IMPORT", line 9215
2011/08/24 08:42:19 > ERRORed BLOCK count > 0
08:42:19:: log_message: Error in pre_import procedure
08:42:19:: log_message: Stage=Pa_Otc_Api ::: ->Upload_Otc_Timecards :: Create new orig trx ref 3. : ORA-01422: exact fetch returns more than requested number of rows
08:42:19:: log_message: ORA-01422: exact fetch returns more than requested number of rows
Cause
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
| Symptoms |
| Cause |
| Solution |
| References |