Customer Creation Through Opencart

This document illustrates the functionality to create customers in Oracle EBS R12 though Opencart

magenta website. The customers of type ‘Person’ and ‘Organization’ can be created by calling one

custom PL/SQL API which creates customers in EBS using Oracle’s TCA API’s.

To achieve this, a custom PL/SQL procedure has been developed, which can be called from an opnecart

website by passing the required input parameters to it. The input parameters to the custom procedure

are as below:

• Customer type: Customer of ‘Organization’ or ‘Person’ type
• Organization Name : Organization name to be created when creating customer of
• type ‘Organization’
• First Name: Party/Customer Account first name
• Last Name: Party/Customer last name
• Address1: Party/account site location address1
• Address2: Party/account site location address2
• City: Party/account site location city
• State: Party/account site location state
• Zip: Party/account site location zip
• County: Party/account site location county

This procedure would in turn return following output parameters once completed successfully.

• Bill to site id
• Customer Account Number
• Party Id

Program creates following entities in HZ schema.

1. Customer Party Name(combination of first and last name)
2. Customer Party Number,id
3. Customer Account Number
4. Customer Profile
5. Party site location(combination of address1,address2,city,state,zip and county)
6. Parry site
7. Account site
8. Account site usage(in this case bill to)

This way we can create customers in Oracle EBS R12 using any website by simply calling a custom

procedure. The sample log file for on sample customer created for the successfully called procedure is as

below:

Connecting to the database iBiz_R12_1_1_3.

Calling the API hz_cust_account_v2pub.create_cust_account

***************************

Output information ….

x_cust_account_id: 149774

x_account_number: 6538

x_party_id: 433847

x_party_number: 58330

x_profile_id: 183483

x_return_status: S

x_msg_count: 0

x_msg_data:

***************************

***************************

Output information ….

x_location_id: 27223

x_return_status: S

x_msg_count: 0

x_msg_data:

***************************

***************************

Output information ….

x_party_site_id: 255684

x_party_site_number: 25380

x_return_status: S

x_msg_count: 0

x_msg_data:

***************************

***************************

Output information ….

x_cust_acct_site_id: 11932

x_return_status: S

x_msg_count: 0

x_msg_data:

***************************

***************************

Output information ….

x_site_use_id: 14543

x_return_status: S

x_msg_count: 0

x_msg_data: 0

***************************

x_return_status: S

x_msg_count: 0

x_msg_data:

***************************

Process exited.

Disconnecting from the database iBiz_R12_1_1_3.