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.
- Customer Party Name(combination of first and last name)
- Customer Party Number,id
- Customer Account Number
- Customer Profile
- Party site location(combination of address1,address2,city,state,zip and county)
- Parry site
- Account site
- 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.
