Skip to main content

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.

 

 

Be the first to reply!

Reply