Can I call an Oracle API from a custom schema?
I created a procedure in a custom schema which calls Oracle APIs to load and update vendors (AP_VENDOR_PUB_PKG).
I granted access on APPS.AP_VENDOR_PUB_PKG to my custom schema. When I run it in my custom schema, I am receiving the following error:
ORA-00942: table or view does not exist occurred in AP_APXVDMVD_PKG.Initialize_Supplier_Attr.
Is it possible to call an Oracle API from a custom schema?
Regards,
Paulette