Solved

Insufficient Privilege to Access for ftp reader custom method

  • 13 August 2021
  • 3 replies
  • 479 views
N
Rank

Hi,

I've written a logic to import pdf files to IFS using custom method, IFS CONNECT, routing rules and routing address are correctly configured. When files coping to IN_DIRECTORY location application message status appears as below,

"Failed executing statement (ORA-06550: line 1, column 14:
PLS-00904: insufficient privilege to access object IFSAPP.C_CUSTOMIZATION_UTIL_API
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored)"

process initiated user : IFSCONNECT

any suggestion to fix this issue?

 

Thank You

Regards

Nimesh

icon

Best answer by Charith Epitawatta 13 August 2021, 20:11

View original
This topic has been closed for comments

3 replies

Charith Epitawatta
Rank
Userlevel 7
Badge +31

Hi @nimesh,

Have you tried granting execute privileges on this API to IFSSYS user?

GRANT EXECUTE ON  IFSAPP.C_CUSTOMIZATION_UTIL_API TO IFSSYS

IFSSYS should have SELECT on all views, EXECUTE on all methods, SELECT, UPDATE, INSERT on tables with LOB columns. Since this is a custom package, you should grant it manually.

If you still get the error, try granting it to IFSCONNECT as well. 

Hope this helps!

Charith - https://charith.xyz
durette
Rank
Userlevel 7
Badge +18

If you still get the error, try granting it to IFSCONNECT as well. 

It might be better to grant to the permission set FND_CONNECT instead, to keep it tidy and portable, but the functional result will be the same. Grants directly to the user can’t be exported as an XML from the application.

 

I’m only splitting hairs. My money’s on IFSSYS being the problem. 😊

If you find this forum useful, please consider paying back to the community in your own areas of expertise. -- Kevin Durette - https://www.linkedin.com/in/kevindurette
N
Rank

Thank you very much both @Charith Epitawatta and @durette . IFSSYS is granted and it is working fine now :blush:

Terms & ConditionsCookie settings