Issues to execute execute ap_vendor_pub_pkg.Update_Vendor_public in custom schema
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.