Skip to main content
Solved

Insufficient Privilege to Access for ftp reader custom method

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!

View original
Did this topic help you find an answer to your question?
This topic has been closed for comments

3 replies

Charith Epitawatta
Ultimate Hero (Employee)
Forum|alt.badge.img+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
1 person likes this
  • durette
    durette
durette
Superhero (Customer)
Forum|alt.badge.img+19
  • durette
  • Superhero (Customer)
  • 525 replies
  • August 13, 2021
Charith Epitawatta wrote:

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 here. -- Kevin Durette - https://www.linkedin.com/in/kevindurette
Charith Epitawatta
1 person likes this
  • Charith Epitawatta
    Charith Epitawatta
N
Sidekick (Partner)
  • nimesh
  • Author
  • 78 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 settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings