Question

Migration Job Error

  • 17 February 2021
  • 2 replies
  • 372 views

Userlevel 2
Badge +6
  • Sidekick
  • 10 replies

Hi everybody

I’m trying to load a file under Risk Analysis>Potential Problem list. But I’m getting this error

“Error ORA-01422: exact fetch returns more than requested number of rows when executing BEGIN SELECT objid, objversion INTO :objid, :objversion from RISK_PROBLEM; End; “

Do you have any idea why i’m getting this error?

PS:There is no duplicate data


This topic has been closed for comments

2 replies

Userlevel 5
Badge +6

Hi Amy,

 

You may check the values in your file and make sure all lines contain correct data accordingly to the

fields in migration job file mapping tab.

This type of error can be occurred due to incorrect column mappings in the file.

 

Cheers,

Thilini

Userlevel 3
Badge +10

I get this same error when trying to log onto the IFS application. My system is APPS8 SP1.

 

I just refreshed my QA database with an export of my prod system. After doing a reconfigure and F1MAGE, with no errors, I cannot log onto the application due to this error.

Any suggestions are welcome.