EBS Customizations (MOSC)

MOSC Banner

How to set up required privileges to use PL/SQL APIs in custom schema

edited Mar 13, 2019 5:58AM in EBS Customizations (MOSC) 6 commentsAnswered

Hi All,
I'm using a custom schema for connecting via JDBC and calling several APIs (like FND_WEB_SEC.Validate_Login, EGO_ITEM_PUB.Process_Item, ENG_ECO_PUB.Process_ECO, BOM_BO_PUB.Process_BOM) with this user. As APPS schema is like superuser for EBS, I decided to connect to a custom schema instead. But as it turned out to be very difficult to set up all required privileges for mentioned APIs and I would have to provide a general method to do this at customers, I'm no longer sure if this is the right approach. Besides, FND_WEB_SEC.Validate_Login is not valid for non APPS accounts as described in

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center