Will it hurt Oracle developers to put Function Id too in the error message? How do i know which function i don't have access?
So queried fnd_new_message to get message code (select * from fnd_new_messages where message_text like 'Your current resp%';).
Message code was "PA_FUNCTION_SECURITY_ENFORCED".
Searched source code of PA_PROJECT_PUB.create_project for the message code. it was function "PA_PM_CREATE_PROJECT" that my responsibility did not have access to.
I could create projects using API via some other custom responsibility. So I used THIS QUERY replaced "%" for user_menu_name with menu_name for responsibility that does not give error. I found the following sub menu has all the functions that may be needed for creating/updating projects/task using projects APIs
Open Integration Toolkit Funtions Menu
You may have noticed that Function is spelled incorrectly. I think it has come from Oracle itself.
Added Open Integration Toolkit Funtions Menu as sub-menu to custom responsibility's menu and I was able to create project using API.
Tuesday, July 17, 2018
Oracle Project API "PA_PROJECT_PUB" Error: "Your current responsibility does not have access to this function."
Subscribe to:
Post Comments (Atom)
PA�PA_FUNCTION_SECURITY_ENFORCED
ReplyDelete