Skip to main content

on IFS CLOUD,  23r1

I get this error message after running a Migration task on the view: ACCOUNTING_CODESTR_COMPL

the temporary table was created via CREATE_TABLE_FROM_FILE
but when I run the MIGRATE_SOURCE_DATA job

This message appears "Job ORA-20111: UserFinance.RECNOTEXIST: Access denied. User XXX is not authorized to add/modify/delete users in the company".

What does this have to do with "users in the company"? (all belong to the company)
whatever user I use, I get this message (IFSAPP and others)

What would be the missing setting?

thanks for your help

Mélanie

Could it be that the data is not quite right? I trawled some code and found that it checks for user access before actually checking the company id itself. I get a similar error when I deliberately use a non-existing company id: 

ORA-20111: UserFinance.RECNOTEXIST: Access denied! User ANBL is not connected to Company dum

I have checked and there are some things needed to add users to companies nowadays:

  1. System privilege ADMINISTRATOR
  2. Projection UserHandling granted

Does your user that runs migration have those things?

Thank you for your answers
I have checked the tables and users.
I have all permissions set on all companies and sites.

It must be a particular Administrator right that I don't know about. ;(

ADMINISTRATOR is a system privilige, you can add that to a permission set in the window “Permission Set”, like in the window below:

 

 

Thank you all for your answers.

I added the administrator’s rigth.

I should verify the data of my migration job too.

 

 

Reply


Terms & ConditionsCookie settings