Skip to main content

Hi

I am trying to create an Excel Migration Job that will delete User’s Sites. I would like to use the method USER_ALLOWED_SITE_API.Remove_User_Allowed_Site. It requires only COMPANY and USERID and removes all Sites associated with the given COMPANY for the given USERID. 

I would like it in Excel so that we can load the specific Users and Companies we need to target.

If I run this PL/SQL, it completes successfully…

begin
USER_ALLOWED_SITE_API.Remove_User_Allowed_Site('USERID','COMPANY');
end;

I have tried various configs in the Excel Migration job and it either errors, says it has processed it (but hasn’t) or churns for a while and returns a blank.

Any pointers?

Hi

I am trying to create an Excel Migration Job that will delete User’s Sites. I would like to use the method USER_ALLOWED_SITE_API.Remove_User_Allowed_Site. It requires only COMPANY and USERID and removes all Sites associated with the given COMPANY for the given USERID. 

I would like it in Excel so that we can load the specific Users and Companies we need to target.

If I run this PL/SQL, it completes successfully…

begin
USER_ALLOWED_SITE_API.Remove_User_Allowed_Site('USERID','COMPANY');
end;

I have tried various configs in the Excel Migration job and it either errors, says it has processed it (but hasn’t) or churns for a while and returns a blank.

Any pointers?

@BABPAULS instead of using the method you mentioned try using the remove method directly as below. 

 

 go to method list attributes in the remove method 

 

 

 

and finally your source mapping should look like below

 

 

this will remove the sites as needed, what happens when you run the job is using the first method system will try to run an update then take the objid and version and pass it to the second method  (remove__). and using the objid and version system will remove the record that you want.

 

in the excel adding you can pass the USER id and contract that you want to remove  🙂.

 

Hope this helps.

 

kind Regards

Niyomal.

Thank you so much Niyomal. This has worked 😀

 

At first I didn’t think it had, but found it to be a cache issue in the app (we are on Apps 9) continuing to show the deleted Site as being granted. 

 

I have to admit, I hadn’t been in the Method List Attributes area before. Good to see how this functionality works.

 

Thanks again

Paul

Reply


Terms & ConditionsCookie settings