Customer Conversion API's in Oracle Apps R12

Customer Creation

Customer Creation can be categorized in two Entities.

1. Party Creation Entity

2. Account Creation Entity

 These are the main Entities that are used in Oracle Receivables Customer Information. PARTY must be exist before creating the Customer Account.Party can be created using the PARTY API given below.

However we can also create the Party along with Account using Account API.

Party Creation API's:

Entity	API	Tables
Party – Organization	HZ_PARTY_V2PUB.create_organization	HZ_PARTIES HZ_ORGANIZATION_PROFILES
Party - Person	HZ_PARTY_V2PUB.create_person	HZ_PARTIES HZ_PERSON_PROFILES
Location	HZ_LOCATION_V2PUB.create_location	HZ_LOCATIONS HZ_LOCATIONS_PROFILES
Party Site	HZ_PARTY_SITE_V2PUB.create_party_site	HZ_PARTY_SITES
Party Site Use	HZ_PARTY_SITE_V2PUB.create_party_site_use	HZ_PARTY_SITE_USES
Party Contact (Organization Contact)	HZ_PARTY_CONTACT_V2PUB.create_org_contact	HZ_ORG_CONTACTS HZ_RELATIONSHIPS (Subject: Contact person Object: Organization/Person) HZ_PARTIES (party_type=PARTY_RELATIONSHIP)
Contact Role	HZ_PARTY_CONTACT_V2PUB.create_org_contact_role	HZ_ORG_CONTACT_ROLES
Contact Point	HZ_CONTACT_POINT_V2PUB.create_contact_point HZ_CONTACT_POINT_V2PUB.create_phone_contact_point HZ_CONTACT_POINT_V2PUB.create_email_contact_point HZ_CONTACT_POINT_V2PUB.create_web_contact_point HZ_CONTACT_POINT_V2PUB.create_telex_contact_point HZ_CONTACT_POINT_V2PUB.create_edi_contact_point HZ_CONTACT_POINT_V2PUB.create_eft_contact_point	HZ_CONTACT_POINTS Owner_table_name=HZ_PARTIES and owner_table_id=party_id Or Owner_table_name=HZ_PARTY_SITES and owner_table_id=party_site_id

 

 Account Creation API's:

Entity	API	Tables
Customer Account	HZ_CUST_ACCOUNT_V2PUB.create_cust_account	HZ_CUST_ACCOUNTS HZ_PARTIES HZ_CUSTOMER_PROFILES HZ_CUST_PROFILE_AMTS
Account Site	HZ_CUST_ACCOUNT_SITE_V2PUB.create_cust_acct_site	HZ_CUST_ACCT_SITES_ALL
Account Site Use	HZ_CUST_ACCOUNT_SITE_V2PUB.create_cust_site_use	HZ_CUST_SITE_USES_ALL HZ_CUSTOMER_PROFILES HZ_CUST_PROFILE_AMTS
Account Relationship	HZ_CUST_ACCOUNT_V2PUB. create_cust_acct_relate	HZ_CUST_ACCT_RELATE_ALL
Account / Account Site Use Profile	HZ_CUSTOMER_PROFILE_V2PUB.create_customer_profile	HZ_CUSTOMER_PROFILESHZ_CUST_PROFILE_AMTS
Account / Account Site Use Profile Amount	HZ_CUSTOMER_PROFILE_V2PUB.create_cust_profile_amt	HZ_CUST_PROFILE_AMTS
Account / Account Site Role (Contact)	HZ_CUST_ACCOUNT_ROLE_V2PUB.create_cust_account_role	HZ_CUST_ACCOUNT_ROLES

Here we have listed the API's that are used to create customer.

In the next post we provide how to use the above API's for Customer Creation.