Granting execute privilege on a package

Hi Experts,

ERP database version 12.1.0.2.0

Issue:

AP_INVOICES_PKG is a standard package and xxobiee is custom user.

We have granted execute privilege on package AP_INVOICES_PKG to xxobiee user.

exec AD_ZD.grant_privs('EXECUTE','AP_INVOICES_PKG','XXOBIEE');

User is unable to call the functions of this package in another package and ended up with below error.

ERROR

ORA-00942: table or view does not exist

ORA-06512: at "APPS.AP_INVOICES_UTILITY_PKG", line 615

ORA-06512: at "APPS.AP_INVOICES_PKG", line 2364

00942. 00000 - "table or view does not exist"

*Cause: *Action:

Do we need to give any additional grants or is this normal behaviour?please advice