Payables and Cash Management - EBS (MOSC)

MOSC Banner

Issues to execute execute ap_vendor_pub_pkg.Update_Vendor_public in custom schema

edited Jul 13, 2016 9:15AM in Payables and Cash Management - EBS (MOSC) 4 commentsAnswered

Hi,

I'm trying to use AP_VENDOR_PUB_PKG.UPDATE_VENDOR_PUBLIC in my procedure (create in a custom schema), but I've had somme issues. When I compile my procedure using a standard schema like APPS, all works fine, but when I use with a CUSTOM schema my AP_VENDOR_PUB_PKG.UPDATE_VENDOR_PUBLIC doesn't work and I have no error message. My STATUS return is "U" (Unexpected error). For execute this API from my CUSTOM schema, need I grant ALL OBJECTS IN AP_VENDOR_PUB_PKG.UPDATE_VENDOR_PUBLIC to my CUSTOM schema?

My apps DBA said Oracle doesn't recommends use APPS to CUSTOM objects, so, I need use a CUSTOM schema for all my objects.

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