EBS Customizations (MOSC)

MOSC Banner

Access denied error when using HZ_CUST_ACCOUNT_SITE_V2PUB.CREATE_CUST_ACCT_SITE

 I'm trying to create a customer ship to address using the APIs outlined in the "Using TCA APIs Including Examples -V2" white paper.

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;

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