API to create Customers

We can create or insert a new customer data usingthis API.

API Details:

1. Set the organization id

• Exec dbms_application_info.set_client_info(‘204’);

2. Create a party and an account

• HZ_CUST_ACCOUNT_V2PUB.CREATE_CUST_ACCOUNT()
• HZ_CUST_ACCOUNT_V2PUB.CUST_ACCOUNT_REC_TYPE
• HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE
• HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE

3. Create a  location

• HZ_LOCATION_V2PUB.CREATE_LOCATION()
• HZ_LOCATION_V2PUB.LOCATION_REC_TYPE

4. Create a party site using party_id you get from step 2 and location_id from step 3.

• HZ_PARTY_SITE_V2PUB.CREATE_PARTY_SITE()
• HZ_PARTY_SITE_V2PUB.PARTY_SITE_REC_TYPE

5. Create an account site using account_id  from step 2 and party_site_id from step 4.

• HZ_CUST_ACCOUNT_SITE_V2PUB.CREATE_CUST_ACCT_SITE()
• HZ_CUST_ACCOUNT_SITE_V2PUB.CUST_ACCT_SITE_REC_TYPE

6. Create an account site use using cust_acct_site_id from step 5 and site_use_code = ‘BILL_TO’.

• HZ_CUST_ACCOUNT_SITE_V2PUB.CREATE_CUST_SITE_USE()
• HZ_CUST_ACCOUNT_SITE_V2PUB.CUST_SITE_USE_REC_TYPE
• HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE

Base table:

• HZ_PARTIES
• HZ_PARTY_SITES
• HZ_LOCATIONS
• HZ_CUST_ACCOUNTS
• HZ_CUST_SITE_USES_ALL
• HZ_CUST_ACCT_SITES_ALL
• HZ_PARTY_SITE_USES

Check Validations:

• legacy values fetched are valid.
• customer address site is already created.
• customer site use is already created.
• customer header is already created.
• whether the ship_to_site has associated bill_to_site
• whether associated bill_to_site is created or not.

Profile amounts validation:

• Validate cust_account_id, validate customer status.
• Check if the location already exists in HZ_LOCATIONS. If does not exist, create new location.