Change Initiated By user in Outbound Async Message

Hi,

This is way too late but if you need to change the ‘Execute As’ you can do it from Application server tasks window

Hello @dsj 

Trust you are fine :)

Did the above answer from @Ruchira work for you? Because, as I know, application server task administration was later moved into Setup IFS Connect > Task templates.

However, I have a similar situation, so I thought I might get some inputs from you.

I’ve also come across a situation where some queries won’t get results (due to right issues) when they are written in the events against the PDF_REPORT_CREATED event. That’s probably because the FND user (IFSCONNECT)  who executes the application server task has no access.

I know that, even the FND user is IFSCONNECT, the session pool contains IFSSYS users, but how to solve this issue?

The below solutions are available, but I like to hear your comments.

1. Set the EXECUTE_AS to INITIATOR of the PROCESSING_PRINT_JOBS
2. Grant all sites and companies to IFSCONNECT user
   (doesn’t look like a good solution at all to me though)
3. Use impersonations (FND_SESSION_API.Impersonate_Fnd_User) within the PDF_REPORT_CREATED event action code

Thank you in advance.

/Manulak

Hi Bro,

I’m doing good and nice to hear you have the same troubles so I guess you also cooking some good stuff :)

No, the solution by Ruchira didn’t work for me since I couldn’t find an overload of PLSQLAP_Server_API.Post_Outbound_Bizapi with a matching parameter. So I impersonate the user inside the chain link 2 PL/SQL procedure when processing the response. (your option 3)

I had the same trouble for PDF_REPOPRT_CREATED event action and there I used fnd_session_Util_API.Impersonate_Fnd_User_('&USER_IDENTITY');

Hope it helps!
Damith

Oh, you got a strong olfaction my friend ;-) @dsj 

Thanks a lot for the feedback - and I always thought the EXECUTE_AS param should solve the issue, but it doesn’t. So I’ll advise also to stick to the option 3 above as you’ve suggested too.

Cheers …. 🥂

@Manulak The problem here is by default Execute As is set to initiator, but the initiated by is set to IFSCONNECT. If you can find a way to set the initiated by to the end user, maybe it would work? I went with the easiest solution though 😁

Please keep posted if you able to crack this.

Cheers!

Damith