Skip to main content
Solved

Insufficient Privilege to Access for ftp reader custom method

  • August 13, 2021
  • 3 replies
  • 712 views
N
Sidekick (Partner)

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

Best answer by Charith Epitawatta

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!

This topic has been closed for replies.

3 replies

Charith Epitawatta
Ultimate Hero (Employee)
Forum|alt.badge.img+31
  • Charith Epitawatta
  • Ultimate Hero (Employee)
  • 1094 replies
  • Answer
  • August 13, 2021

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.pro
durette
Superhero (Customer)
Forum|alt.badge.img+19
  • durette
  • Superhero (Customer)
  • 542 replies
  • August 13, 2021

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. If you ask for help in a private message, please know that I will likely repost it as a forum question (with your personal details redacted) and answer it publicly. -- Kevin Durette - https://www.linkedin.com/in/kevindurette
N
Sidekick (Partner)
  • nimesh
  • Author
  • 82 replies
  • August 14, 2021

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

Terms & ConditionsCookie settingsAccessibility statement