Access denied error when using HZ_CUST_ACCOUNT_SITE_V2PUB.CREATE_CUST_ACCT_SITE
I'm able to load the location and party site but when I try to create the customer account site using HZ_CUST_ACCOUNT_SITE_V2PUB.CREATE_CUST_ACCT_SITE I'm getting a DBMS_SQL access denied error.
-------------------------------------------------------------------------------------
PROCEDURE CREATE_CUSTOMER_ACCOUNT_SITE (P_CUST_ACCOUNT_ID IN NUMBER, P_PARTY_SITE_ID IN NUMBER, X_CUST_ACCT_SITE_ID OUT NUMBER, X_RETURN_STATUS OUT VARCHAR2)
AS
P_CUST_ACCT_SITE_REC HZ_CUST_ACCOUNT_SITE_V2PUB.CUST_ACCT_SITE_REC_TYPE;