Hi All,
I am trying to do export of IFS database from oracle source server to destination server using oracle user ‘SYSTEM’. I see the export import completed fine. But while starting the application the background_jobs is not running and looks like it is trying to run these jobs with ‘SYSTEM’ user which was used for importing the database.
I am getting below error can you please suggest anyone faced this? do I need to impersonate ‘SYSTEM’ user? If yes how can I do it these are all background jobs triggered by application during configuration automatically.
Below is the error I am getting.
Fnd_Session_Util_API.Impersonate_Fnd_User_ Could not impersonate Foundation User .
==========================================
Could not impersonate Foundation User .
==========================================
Fnd_Session_Util_API.Reset_Fnd_User_
==========================================
Foundation User is not reset. Foundation user is .
Fnd_Session_Util_API.Impersonate_Fnd_User_
ORA-20111: FndUser.NOTEXIST: The Foundation1 user "SYSTEM" does not exist.
ORA-06512: at "IFSAPP.BATCH_SYS", line 817
ORA-06512: at "IFSAPP.FND_SESSION_UTIL_API", line 286
ORA-06512: at "IFSAPP.ERROR_SYS", line 145
ORA-06512: at "IFSAPP.FND_USER_API", line 825
ORA-06512: at "IFSAPP.FND_SESSION_UTIL_API", line 253
ORA-06512: at "IFSAPP.FND_SESSION_API", line 407
ORA-06512: at "IFSAPP.BATCH_SYS", line 786
ORA-06512: at line 1
Please suggest.