Skip to main content

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

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!

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. 😊

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

Terms & ConditionsCookie settings