API to create Customers

Customer API, AskHareesh.blogspot.com

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.

*/