In this blog I will try to share my experience, which I believe will help others and shorten the learning curve.
The posts will generally talk about lessons from my professional work, however it can contain content from life outside work also.

Sunday, August 28, 2011

Oracle Apps: Create Customer (Organization/Person) using API

Download the sample code (pls files) referred to in the below description from the following link

3) Create Party Site. (Link the Location (step 2) to Party created in (Step1))

create_party_site.pls

4) Create Customer Account Site (Using the Party Site (Step 3) and Customer Account (Step 1))

create_customer_account_sites.pls

5) Create Customer Account Site Use - Bill To (Identify the Customer Account Site created in Step 4 for use as BILL_TO)

create_customer_account_site_use.pls

6) Create Customer Account Site Use - Ship To (Identify the Customer Account Site created in Step 4 for use as SHIP_TO)

create_customer_account_site_use.pls

7) Create Org Contact Point for Phone details at Party Site level (Using the Party Site ID created in Step 3)

create_org_contact_point_phone.pls

8) Create Org Contact Point for Email details at Party Site level (Using the Party Site ID created in Step 3)

create_org_contact_point_email.pls

9) Create Org Contacts (Using the Object ID = Party ID created in Step 1. For Subject ID, it should be Party ID of a person, in our case we will create a common person who will be contact for all the organisations. So this Subject ID will be hardcoded.)

create_org_contact.pls

10) Create Cust Account Role (Using the Party ID of Relationship that gets created in Step 9 and Cust Account ID created in Step 1 and Cust Account Site ID created in Step 4)

create_cust_account_role.pls

11) Create Role Responsibility for the Cust Account Role - Bill To (Using the Cust Account Role ID created in step 10)

create_role_responsibility.pls

12) Create Role Responsibility for the Cust Account Role - Ship To (Using the Cust Account Role ID created in step 10)

create_role_responsibility.pls

A good document (Note: 230753.1) on metalink for different TCA API uses is available at