{"id":963,"date":"2011-04-14T11:06:36","date_gmt":"2011-04-14T11:06:36","guid":{"rendered":"http:\/\/sendyoursmiles.com\/articles\/financials\/tca"},"modified":"2015-08-12T22:03:57","modified_gmt":"2015-08-12T22:03:57","slug":"tca","status":"publish","type":"post","link":"https:\/\/erpschools.com\/erps\/api\/ar-api\/tca","title":{"rendered":"Trading Community Architecture (TCA) API"},"content":{"rendered":"

Overview:<\/span><\/p>\n

Trading Community Architecture (TCA) is an architecture concept designed to support complex trading communities. This document provides information about how to create a customer using TCA API. These APIs utilize the new TCA model, inserting directly to the HZ tables.<\/p>\n

Architecture<\/span>
\n\"\"<\/p>\n

Create Organization<\/span>
\nDECLARE
\np_organization_rec\u00a0\u00a0 hz_party_v2pub.organization_rec_type;
\nx_return_status\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0VARCHAR2\u00a0(2000);
\nx_msg_count\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0NUMBER;
\nx_msg_data\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0VARCHAR2\u00a0(2000);
\nx_party_id\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0NUMBER;
\nx_party_number\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0VARCHAR2\u00a0(2000);
\nx_profile_id\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0NUMBER;<\/code><\/p>\n

BEGIN
\np_organization_rec.organization_name\u00a0:=\u00a0‘erpschools’;
\np_organization_rec.created_by_module\u00a0:=\u00a0‘ERPSCHOOLS_DEMO’;
\nhz_party_v2pub.create_organization\u00a0(‘T’,
\np_organization_rec,
\nx_return_status,
\nx_msg_count,
\nx_msg_data,
\nx_party_id,
\nx_party_number,
\nx_profile_id
\n);<\/p>\n

DBMS_OUTPUT.put_line (‘party id ‘\u00a0|| x_party_id);
\nDBMS_OUTPUT.put_line (SUBSTR\u00a0(‘x_return_status = ‘\u00a0|| x_return_status,1,255)
\n);<\/p>\n

DBMS_OUTPUT.put_line (‘x_msg_count = ‘\u00a0|| TO_CHAR\u00a0(x_msg_count));
\nDBMS_OUTPUT.put_line (SUBSTR\u00a0(‘x_msg_data = ‘\u00a0|| x_msg_data,\u00a01,\u00a0255));
\nIF\u00a0x_msg_count >\u00a01
\nTHEN
\nFOR\u00a0i IN\u00a01\u00a0..\u00a0x_msg_count
\nLOOP
\nDBMS_OUTPUT.put_line
\n(i
\n||\u00a0‘. ‘
\n||\u00a0SUBSTR(fnd_msg_pub.get\u00a0(p_encoded\u00a0=>\u00a0fnd_api.g_false),1,255)
\n);<\/p>\n

END\u00a0LOOP;
\nEND\u00a0IF;
\nEND;
\nNote: The above\u00a0API creates a record in hz_parties table and one record in hz_organization_profiles table. Similarly you can call hz_party_v2pub.create_person to create a record in the HZ_PARTIES and one record in HZ_PERSON_PROFILES tables.<\/p>\n

Create a Location<\/span>
\nDECLARE
\np_location_rec HZ_LOCATION_V2PUB.LOCATION_REC_TYPE;
\nx_location_id\u00a0NUMBER;
\nx_return_status\u00a0VARCHAR2(2000);
\nx_msg_count\u00a0NUMBER;
\nx_msg_data\u00a0VARCHAR2(2000);<\/code><\/p>\n

BEGIN
\np_location_rec.country\u00a0:=\u00a0‘US’;
\np_location_rec.address1\u00a0:=\u00a0‘2500 W Higgins Rd’;
\np_location_rec.address2\u00a0:=\u00a0‘Suite 920’;
\np_location_rec.city\u00a0:=\u00a0‘Thumuluru’;
\np_location_rec.postal_code\u00a0:=\u00a0‘60118’;
\np_location_rec.state\u00a0:=\u00a0‘IL’;
\np_location_rec.created_by_module\u00a0:=\u00a0‘ERPSCHOOLS_DEMO’;
\nhz_location_v2pub.create_location(
\n‘T’,
\np_location_rec,
\nx_location_id,
\nx_return_status,
\nx_msg_count,
\nx_msg_data);
\ndbms_output.put_line(‘location id ‘||x_location_id);
\ndbms_output.put_line(SubStr(‘x_return_status = ‘||x_return_status,1,255));
\ndbms_output.put_line(‘x_msg_count = ‘||TO_CHAR(x_msg_count));
\ndbms_output.put_line(SubStr(‘x_msg_data = ‘||x_msg_data,1,255));<\/p>\n

IF\u00a0x_msg_count >1\u00a0THEN
\nFOR\u00a0I IN\u00a01..x_msg_count
\nLOOP
\ndbms_output.put_line(I||’. ‘||SubStr(FND_MSG_PUB.Get(p_encoded\u00a0=>FND_API.G_FALSE\u00a0),\u00a01,\u00a0255));
\nEND\u00a0LOOP;
\nEND\u00a0IF;<\/p>\n

END;
\nNote: The above API shall create an address record in hz_locations table.<\/p>\n

Create a\u00a0Party Site:<\/span><\/p>\n

Use the organization_id and location_id created above and create a party site.
\nDECLARE
\np_party_site_rec\u00a0\u00a0\u00a0\u00a0\u00a0 hz_party_site_v2pub.party_site_rec_type;
\nx_party_site_id\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0NUMBER;
\nx_party_site_number\u00a0\u00a0\u00a0VARCHAR2\u00a0(2000);
\nx_return_status\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0VARCHAR2\u00a0(2000);
\nx_msg_count\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0NUMBER;
\nx_msg_data\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0VARCHAR2\u00a0(2000);<\/code><\/p>\n

BEGIN
\np_party_site_rec.party_id\u00a0:=\u00a01272023;
\np_party_site_rec.location_id\u00a0:=\u00a0359086;
\np_party_site_rec.identifying_address_flag\u00a0:=\u00a0‘Y’;
\np_party_site_rec.created_by_module\u00a0:=\u00a0‘ERPSCHOOLS_DEMO’;<\/p>\n

hz_party_site_v2pub.create_party_site\u00a0(‘T’,
\np_party_site_rec,
\nx_party_site_id,
\nx_party_site_number,
\nx_return_status,
\nx_msg_count,
\nx_msg_data
\n);<\/p>\n

DBMS_OUTPUT.put_line (‘party site id ‘\u00a0|| x_party_site_id);
\nDBMS_OUTPUT.put_line (SUBSTR\u00a0(‘x_return_status = ‘\u00a0|| x_return_status,1,255)
\n);<\/p>\n

DBMS_OUTPUT.put_line (‘x_msg_count = ‘\u00a0|| TO_CHAR\u00a0(x_msg_count));
\nDBMS_OUTPUT.put_line (SUBSTR\u00a0(‘x_msg_data = ‘\u00a0|| x_msg_data,\u00a01,\u00a0255));<\/p>\n

IF\u00a0x_msg_count >\u00a01
\nTHEN
\nFOR\u00a0i IN\u00a01\u00a0..\u00a0x_msg_count
\nLOOP
\nDBMS_OUTPUT.put_line
\n(i
\n||\u00a0‘. ‘
\n||\u00a0SUBSTR
\n(fnd_msg_pub.get\u00a0(p_encoded\u00a0=>\u00a0fnd_api.g_false),1,255)
\n);<\/p>\n

END\u00a0LOOP;
\nEND\u00a0IF;
\nEND;<\/p>\n

Note: The above API creates a record in\u00a0hz_party_sites table.<\/p>\n

Create Party Site Use<\/span><\/p>\n

Use the above party site created
\nDECLARE
\np_party_site_use_rec\u00a0\u00a0 hz_party_site_v2pub.party_site_use_rec_type;
\nx_party_site_use_id\u00a0\u00a0\u00a0\u00a0NUMBER;
\nx_return_status\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0VARCHAR2\u00a0(2000);
\nx_msg_count\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0NUMBER;
\nx_msg_data\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0VARCHAR2\u00a0(2000);<\/code><\/p>\n

BEGIN
\np_party_site_use_rec.site_use_type\u00a0:=\u00a0‘SHIP_TO’;
\np_party_site_use_rec.party_site_id\u00a0:=\u00a0349327;
\np_party_site_use_rec.created_by_module\u00a0:=\u00a0‘ERPSCHOOLS_DEMO’;
\nhz_party_site_v2pub.create_party_site_use\u00a0(‘T’,
\np_party_site_use_rec,
\nx_party_site_use_id,
\nx_return_status,
\nx_msg_count,
\nx_msg_data
\n);<\/p>\n

DBMS_OUTPUT.put_line (SUBSTR\u00a0(‘x_return_status = ‘\u00a0|| x_return_status,1,255)
\n);<\/p>\n

DBMS_OUTPUT.put_line (‘x_msg_count = ‘\u00a0|| TO_CHAR\u00a0(x_msg_count));
\nDBMS_OUTPUT.put_line (SUBSTR\u00a0(‘x_msg_data = ‘\u00a0|| x_msg_data,\u00a01,\u00a0255));
\nIF\u00a0x_msg_count >\u00a01
\nTHEN
\nFOR\u00a0i IN\u00a01\u00a0..\u00a0x_msg_count
\nLOOP<\/p>\n

DBMS_OUTPUT.put_line(i||\u00a0‘. ‘||\u00a0SUBSTR(fnd_msg_pub.get\u00a0(p_encoded\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0=>\u00a0fnd_api.g_false),1,255)<\/p>\n

);<\/p>\n

END\u00a0LOOP;
\nEND\u00a0IF;
\nEND;<\/p>\n

Create a Contact Point<\/span><\/p>\n

DECLARE
\np_contact_point_rec\u00a0\u00a0 hz_contact_point_v2pub.contact_point_rec_type;
\np_edi_rec\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 hz_contact_point_v2pub.edi_rec_type;
\np_email_rec\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 hz_contact_point_v2pub.email_rec_type;
\np_phone_rec\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 hz_contact_point_v2pub.phone_rec_type;
\np_telex_rec\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 hz_contact_point_v2pub.telex_rec_type;
\np_web_rec\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 hz_contact_point_v2pub.web_rec_type;
\nx_return_status\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0VARCHAR2\u00a0(2000);
\nx_msg_count\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0NUMBER;
\nx_msg_data\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0VARCHAR2\u00a0(2000);
\nx_contact_point_id\u00a0\u00a0\u00a0\u00a0NUMBER;<\/code><\/p>\n

BEGIN
\np_contact_point_rec.contact_point_type\u00a0:=\u00a0‘PHONE’;
\np_contact_point_rec.owner_table_name\u00a0:=\u00a0‘HZ_PARTIES’;
\np_contact_point_rec.owner_table_id\u00a0:=\u00a0‘1272023’;
\np_contact_point_rec.primary_flag\u00a0:=\u00a0‘Y’;
\np_contact_point_rec.contact_point_purpose\u00a0:=\u00a0‘BUSINESS’;
\np_phone_rec.phone_area_code\u00a0:=\u00a0‘650’;
\np_phone_rec.phone_country_code\u00a0:=\u00a0‘1’;
\np_phone_rec.phone_number\u00a0:=\u00a0‘506-7000’;
\np_phone_rec.phone_line_type\u00a0:=\u00a0‘GEN’;
\np_contact_point_rec.created_by_module\u00a0:=\u00a0‘ERPSCHOOLS_DEMO’;
\nhz_contact_point_v2pub.create_contact_point\u00a0(‘T’,
\np_contact_point_rec,
\np_edi_rec,
\np_email_rec,
\np_phone_rec,
\np_telex_rec,
\np_web_rec,
\nx_contact_point_id,
\nx_return_status,
\nx_msg_count,
\nx_msg_data
\n);<\/p>\n

DBMS_OUTPUT.put_line (SUBSTR\u00a0(‘x_return_status = ‘\u00a0|| x_return_status,1,255)<\/p>\n

);<\/p>\n

DBMS_OUTPUT.put_line (‘x_msg_count = ‘\u00a0|| TO_CHAR\u00a0(x_msg_count));
\nDBMS_OUTPUT.put_line (SUBSTR\u00a0(‘x_msg_data = ‘\u00a0|| x_msg_data,\u00a01,\u00a0255));<\/p>\n

IF\u00a0x_msg_count >\u00a01
\nTHEN
\nFOR\u00a0i IN\u00a01\u00a0..\u00a0x_msg_count
\nLOOP
\nDBMS_OUTPUT.put_line(i||\u00a0‘. ‘||\u00a0SUBSTR(fnd_msg_pub.get\u00a0(p_encoded\u00a0=> fnd_api.g_false),1,255)<\/p>\n

);<\/p>\n

END\u00a0LOOP;
\nEND\u00a0IF;
\nEND;<\/p>\n

Create an Org Contact:<\/span>
\nDECLARE
\np_org_contact_rec\u00a0\u00a0 hz_party_contact_v2pub.org_contact_rec_type;
\nx_org_contact_id\u00a0\u00a0\u00a0\u00a0NUMBER;
\nx_party_rel_id\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0NUMBER;
\nx_party_id\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0NUMBER;
\nx_party_number\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0VARCHAR2\u00a0(2000);
\nx_return_status\u00a0\u00a0\u00a0\u00a0\u00a0VARCHAR2\u00a0(2000);
\nx_msg_count\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0NUMBER;
\nx_msg_data\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0VARCHAR2\u00a0(2000);<\/code><\/p>\n

BEGIN<\/p>\n

p_org_contact_rec.department_code\u00a0:=\u00a0‘ACCOUNTING’;
\np_org_contact_rec.job_title\u00a0:=\u00a0‘ACCOUNTS OFFICER’;
\np_org_contact_rec.decision_maker_flag\u00a0:=\u00a0‘Y’;
\np_org_contact_rec.job_title_code\u00a0:=\u00a0‘APC’;
\np_org_contact_rec.created_by_module\u00a0:=\u00a0‘ERPSCHOOLS_DEMO’;
\np_org_contact_rec.party_rel_rec.subject_id\u00a0:=\u00a016077;
\np_org_contact_rec.party_rel_rec.subject_type\u00a0:=\u00a0‘PERSON’;
\np_org_contact_rec.party_rel_rec.subject_table_name\u00a0:=\u00a0‘HZ_PARTIES’;
\np_org_contact_rec.party_rel_rec.object_id\u00a0:=\u00a01272023;
\np_org_contact_rec.party_rel_rec.object_type\u00a0:=\u00a0‘ORGANIZATION’;
\np_org_contact_rec.party_rel_rec.object_table_name\u00a0:=\u00a0‘HZ_PARTIES’;
\np_org_contact_rec.party_rel_rec.relationship_code\u00a0:=\u00a0‘CONTACT_OF’;
\np_org_contact_rec.party_rel_rec.relationship_type\u00a0:=\u00a0‘CONTACT’;
\np_org_contact_rec.party_rel_rec.start_date\u00a0:=\u00a0SYSDATE;<\/p>\n

hz_party_contact_v2pub.create_org_contact\u00a0(‘T’,
\np_org_contact_rec,
\nx_org_contact_id,
\nx_party_rel_id,
\nx_party_id,
\nx_party_number,
\nx_return_status,
\nx_msg_count,
\nx_msg_data
\n);<\/p>\n

DBMS_OUTPUT.put_line (SUBSTR\u00a0(‘x_return_status = ‘\u00a0|| x_return_status,1,255)<\/p>\n

);<\/p>\n

DBMS_OUTPUT.put_line (‘x_msg_count = ‘\u00a0|| TO_CHAR\u00a0(x_msg_count));
\nDBMS_OUTPUT.put_line (SUBSTR\u00a0(‘x_msg_data = ‘\u00a0|| x_msg_data,\u00a01,\u00a0255));<\/p>\n

IF\u00a0x_msg_count >\u00a01
\nTHEN
\nFOR\u00a0i IN\u00a01\u00a0..\u00a0x_msg_count
\nLOOP
\nDBMS_OUTPUT.put_line(i||\u00a0‘. ‘||\u00a0SUBSTR(fnd_msg_pub.get\u00a0(p_encoded\u00a0=>\u00a0fnd_api.g_false),1,255)<\/p>\n

);<\/p>\n

END\u00a0LOOP;
\nEND\u00a0IF;
\nEND;<\/p>\n

Note: The above API creates a record in hz_org_contacts table and one record in hz_relationships table. When a contact is created, a record in hz_parties table gets created with party_type as ‘PARTY_RELATIONSHIP’.<\/p>\n

Create a Customer Account:<\/span>
\nDECLARE
\np_cust_account_rec\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 hz_cust_account_v2pub.cust_account_rec_type;
\np_person_rec\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 hz_party_v2pub.person_rec_type;
\np_customer_profile_rec\u00a0\u00a0 hz_customer_profile_v2pub.customer_profilerec_type;
\nx_cust_account_id\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0NUMBER;
\nx_account_number\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0VARCHAR2\u00a0(2000);
\nx_party_id\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0NUMBER;
\nx_party_number\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0VARCHAR2\u00a0(2000);
\nx_profile_id\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0NUMBER;
\nx_return_status\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0VARCHAR2\u00a0(2000);
\nx_msg_count\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0NUMBER;
\nx_msg_data\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0VARCHAR2\u00a0(2000);<\/code><\/p>\n

BEGIN<\/p>\n

p_cust_account_rec.account_name\u00a0:=\u00a0‘John”s A\/c’;
\np_cust_account_rec.created_by_module\u00a0:=\u00a0‘ERPSCHOOLS_DEMO’;
\np_person_rec.person_first_name\u00a0:=\u00a0‘John’;
\np_person_rec.person_last_name\u00a0:=\u00a0‘Smith’;<\/p>\n

hz_cust_account_v2pub.create_cust_account\u00a0(‘T’,
\np_cust_account_rec,
\np_person_rec,
\np_customer_profile_rec,
\n‘F’,
\nx_cust_account_id,
\nx_account_number,
\nx_party_id,
\nx_party_number,
\nx_profile_id,
\nx_return_status,
\nx_msg_count,
\nx_msg_data
\n);<\/p>\n

DBMS_OUTPUT.put_line (SUBSTR\u00a0(‘x_return_status = ‘\u00a0|| x_return_status,1,255)<\/p>\n

);<\/p>\n

DBMS_OUTPUT.put_line (‘x_msg_count = ‘\u00a0|| TO_CHAR\u00a0(x_msg_count));
\nDBMS_OUTPUT.put_line (SUBSTR\u00a0(‘x_msg_data = ‘\u00a0|| x_msg_data,\u00a01,\u00a0255));<\/p>\n

IF\u00a0x_msg_count >\u00a01
\nTHEN
\nFOR\u00a0i IN\u00a01\u00a0..\u00a0x_msg_count
\nLOOP
\nDBMS_OUTPUT.put_line(i||\u00a0‘. ‘||\u00a0SUBSTR(fnd_msg_pub.get\u00a0(p_encoded\u00a0=> fnd_api.g_false),1,255)<\/p>\n

);<\/p>\n

END\u00a0LOOP;
\nEND\u00a0IF;
\nEND;<\/p>\n

Note:
\nThis routine is used to create a Customer Account. The API creates a record in the HZ_CUST_ACCOUNTS table for party type Person or Organization. Account can be created for an existing party by passing party_id of the party. Alternatively, this routine creates a new party and an account for the party.<\/p>\n

Customer profile record in the HZ_CUSTOMER_PROFILES can also be created while calling this routine based on value passed in p_customer_profile_rec. The routine is overloaded for Person and Organization.<\/p>\n

Create a Customer Account Site<\/span><\/p>\n

Use an existing Party Site
\nDECLARE
\np_cust_acct_site_rec\u00a0\u00a0 hz_cust_account_site_v2pub.cust_acct_site_rec_type;
\nx_return_status\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0VARCHAR2\u00a0(2000);
\nx_msg_count\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0NUMBER;
\nx_msg_data\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0VARCHAR2\u00a0(2000);
\nx_cust_acct_site_id\u00a0\u00a0\u00a0\u00a0NUMBER;<\/code><\/p>\n

BEGIN<\/p>\n

p_cust_acct_site_rec.cust_account_id\u00a0:=\u00a03472;
\np_cust_acct_site_rec.party_site_id\u00a0:=\u00a01024;
\np_cust_acct_site_rec.LANGUAGE\u00a0:=\u00a0‘US’;
\np_cust_acct_site_rec.created_by_module\u00a0:=\u00a0‘TCA-EXAMPLE’;
\nhz_cust_account_site_v2pub.create_cust_acct_site\u00a0(‘T’,
\np_cust_acct_site_rec,
\nx_cust_acct_site_id,
\nx_return_status,
\nx_msg_count,
\nx_msg_data
\n);<\/p>\n

DBMS_OUTPUT.put_line (SUBSTR\u00a0(‘x_return_status = ‘\u00a0|| x_return_status,1,255)<\/p>\n

);<\/p>\n

DBMS_OUTPUT.put_line (‘x_msg_count = ‘\u00a0|| TO_CHAR\u00a0(x_msg_count));
\nDBMS_OUTPUT.put_line (SUBSTR\u00a0(‘x_msg_data = ‘\u00a0|| x_msg_data,\u00a01,\u00a0255));<\/p>\n

IF\u00a0x_msg_count >\u00a01
\nTHEN
\nFOR\u00a0i IN\u00a01\u00a0..\u00a0x_msg_count
\nLOOP
\nDBMS_OUTPUT.put_line(i||\u00a0‘. ‘||\u00a0SUBSTR(fnd_msg_pub.get\u00a0(p_encoded\u00a0\u00a0=> fnd_api.g_false),1,255)<\/p>\n

);<\/p>\n

END\u00a0LOOP;
\nEND\u00a0IF;<\/p>\n

END;<\/p>\n

Create Customer Account Site Use Code:<\/span>
\nDECLARE
\np_cust_site_use_rec\u00a0\u00a0\u00a0\u00a0\u00a0 hz_cust_account_site_v2pub.cust_site_use_rec_type;
\np_customer_profile_rec\u00a0\u00a0 hz_customer_profile_v2pub.customer_profile_rec_type;
\nx_site_use_id\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0NUMBER;
\nx_return_status\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0VARCHAR2\u00a0(2000);
\nx_msg_count\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0NUMBER;
\nx_msg_data\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0VARCHAR2\u00a0(2000);<\/code><\/p>\n

BEGIN<\/p>\n

p_cust_site_use_rec.cust_acct_site_id\u00a0:=\u00a03580;
\np_cust_site_use_rec.site_use_code\u00a0:=\u00a0‘INV’;
\np_cust_site_use_rec.LOCATION\u00a0:=\u00a0‘TCA’;
\np_cust_site_use_rec.created_by_module\u00a0:=\u00a0‘ERPSCHOOLS_DEMO’;
\nhz_cust_account_site_v2pub.create_cust_site_use\u00a0(‘T’,
\np_cust_site_use_rec,
\np_customer_profile_rec,”,”,
\nx_site_use_id,
\nx_return_status,
\nx_msg_count,
\nx_msg_data
\n);<\/p>\n

DBMS_OUTPUT.put_line (SUBSTR\u00a0(‘x_return_status = ‘\u00a0|| x_return_status,1,255)<\/p>\n

);<\/p>\n

DBMS_OUTPUT.put_line (‘x_msg_count = ‘\u00a0|| TO_CHAR\u00a0(x_msg_count));
\nDBMS_OUTPUT.put_line (SUBSTR\u00a0(‘x_msg_data = ‘\u00a0|| x_msg_data,\u00a01,\u00a0255));<\/p>\n

IF\u00a0x_msg_count >\u00a01
\nTHEN
\nFOR\u00a0i IN\u00a01\u00a0..\u00a0x_msg_count
\nLOOP
\nDBMS_OUTPUT.put_line(\u00a0i ||\u00a0‘. ‘||\u00a0SUBSTR(fnd_msg_pub.get\u00a0(p_encoded\u00a0\u00a0\u00a0=>\u00a0fnd_api.g_false),1,255)<\/p>\n

);<\/p>\n

END\u00a0LOOP;
\nEND\u00a0IF;
\nEND;<\/p>\n

More Customer API’s:<\/p>\n

\n\n\n\n<\/colgroup>\n\n\n\n\n\n\n\n\n\n\n
Org Contact Role<\/td>\nHz_party_contact_v2pub.Create_Org_Contact_Role<\/td>\n<\/tr>\n
Relationships<\/td>\nHZ_CUST_ACCOUNT_V2PUB.CREATE_CUST_ACCT_RELATE<\/td>\n<\/tr>\n
Customer Profile<\/td>\nHZ_CUSTOMER_PROFILE_V2PUB. create_customer_profile<\/td>\n<\/tr>\n
Customer Profile Amount<\/td>\nHZ_CUSTOMER_PROFILE_V2PUB. create_cust_profile_amt<\/td>\n<\/tr>\n
Customer Credit Rating<\/td>\nHZ_PARTY_INFO_V2PUB.create_credit_rating<\/td>\n<\/tr>\n
Sales Person<\/td>\nJTF_RS_SALESREPS_PUB.CREATE_SALESREP<\/td>\n<\/tr>\n
Sales reps Territories<\/td>\nJTF_RS_SRP_TERRITORIES_PUB.CREATE_RS_SRP_TERRITORIES<\/td>\n<\/tr>\n
Customer contacts<\/td>\nHZ_CUST_ACCOUNT_ROLE_V2PUB.CREATE_CUST_ACCOUNT_ROLE<\/td>\n<\/tr>\n
Customer Contact Role<\/td>\nHZ_CUST_ACCOUNT_ROLE_V2PUB.create_role_responsibility <\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

Overview: Trading Community Architecture (TCA) is an architecture concept designed to support complex trading communities. This document provides information about how to create a customer using TCA API. These APIs utilize the new TCA model, inserting directly to the HZ tables. Architecture Create Organization DECLARE p_organization_rec\u00a0\u00a0 hz_party_v2pub.organization_rec_type; x_return_status\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0VARCHAR2\u00a0(2000); x_msg_count\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0NUMBER; x_msg_data\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0VARCHAR2\u00a0(2000); x_party_id\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0NUMBER; x_party_number\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0VARCHAR2\u00a0(2000); x_profile_id\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0NUMBER; BEGIN p_organization_rec.organization_name\u00a0:=\u00a0‘erpschools’; […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[504],"tags":[47,48],"class_list":["post-963","post","type-post","status-publish","format-standard","hentry","category-ar-api","tag-tca","tag-trading-community-architecture"],"yoast_head":"\nTCA oracle apps<\/title>\n<meta name=\"description\" content=\"Trading Community Architecture (TCA) is a concept designed to support complex trading communities.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/erpschools.com\/erps\/api\/ar-api\/tca\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Prudhvi\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"11 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/erpschools.com\/erps\/api\/ar-api\/tca#article\",\"isPartOf\":{\"@id\":\"https:\/\/erpschools.com\/erps\/api\/ar-api\/tca\"},\"author\":{\"name\":\"Prudhvi\",\"@id\":\"https:\/\/erpschools.com\/erps\/#\/schema\/person\/dbed9bb7fb66aa7a700fc565da024512\"},\"headline\":\"Trading Community Architecture (TCA) API\",\"datePublished\":\"2011-04-14T11:06:36+00:00\",\"dateModified\":\"2015-08-12T22:03:57+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/erpschools.com\/erps\/api\/ar-api\/tca\"},\"wordCount\":1838,\"commentCount\":10,\"publisher\":{\"@id\":\"https:\/\/erpschools.com\/erps\/#organization\"},\"image\":{\"@id\":\"https:\/\/erpschools.com\/erps\/api\/ar-api\/tca#primaryimage\"},\"thumbnailUrl\":\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041411_1106_TCA1.gif\",\"keywords\":[\"tca\",\"trading community architecture\"],\"articleSection\":[\"AR API\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/erpschools.com\/erps\/api\/ar-api\/tca#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/erpschools.com\/erps\/api\/ar-api\/tca\",\"url\":\"https:\/\/erpschools.com\/erps\/api\/ar-api\/tca\",\"name\":\"TCA oracle apps\",\"isPartOf\":{\"@id\":\"https:\/\/erpschools.com\/erps\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/erpschools.com\/erps\/api\/ar-api\/tca#primaryimage\"},\"image\":{\"@id\":\"https:\/\/erpschools.com\/erps\/api\/ar-api\/tca#primaryimage\"},\"thumbnailUrl\":\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041411_1106_TCA1.gif\",\"datePublished\":\"2011-04-14T11:06:36+00:00\",\"dateModified\":\"2015-08-12T22:03:57+00:00\",\"description\":\"Trading Community Architecture (TCA) is a concept designed to support complex trading communities.\",\"breadcrumb\":{\"@id\":\"https:\/\/erpschools.com\/erps\/api\/ar-api\/tca#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/erpschools.com\/erps\/api\/ar-api\/tca\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/erpschools.com\/erps\/api\/ar-api\/tca#primaryimage\",\"url\":\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041411_1106_TCA1.gif\",\"contentUrl\":\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041411_1106_TCA1.gif\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/erpschools.com\/erps\/api\/ar-api\/tca#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/erpschools.com\/erps\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Trading Community Architecture (TCA) API\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/erpschools.com\/erps\/#website\",\"url\":\"https:\/\/erpschools.com\/erps\/\",\"name\":\"erpSchools\",\"description\":\"Oracle Apps\",\"publisher\":{\"@id\":\"https:\/\/erpschools.com\/erps\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/erpschools.com\/erps\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/erpschools.com\/erps\/#organization\",\"name\":\"erpSchools\",\"url\":\"https:\/\/erpschools.com\/erps\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/erpschools.com\/erps\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/erps_logo7.png\",\"contentUrl\":\"https:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/erps_logo7.png\",\"width\":250,\"height\":60,\"caption\":\"erpSchools\"},\"image\":{\"@id\":\"https:\/\/erpschools.com\/erps\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"http:\/\/facebook.com\/erpschools\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/erpschools.com\/erps\/#\/schema\/person\/dbed9bb7fb66aa7a700fc565da024512\",\"name\":\"Prudhvi\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/erpschools.com\/erps\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/488cec3605845b95cb20e60c67a8f5c7e74b65a305525c8006315d524f120db9?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/488cec3605845b95cb20e60c67a8f5c7e74b65a305525c8006315d524f120db9?s=96&d=blank&r=g\",\"caption\":\"Prudhvi\"},\"sameAs\":[\"http:\/\/www.erpschools.com\"],\"url\":\"https:\/\/erpschools.com\/erps\/author\/prudhvi\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"TCA oracle apps","description":"Trading Community Architecture (TCA) is a concept designed to support complex trading communities.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/erpschools.com\/erps\/api\/ar-api\/tca","twitter_misc":{"Written by":"Prudhvi","Est. reading time":"11 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/erpschools.com\/erps\/api\/ar-api\/tca#article","isPartOf":{"@id":"https:\/\/erpschools.com\/erps\/api\/ar-api\/tca"},"author":{"name":"Prudhvi","@id":"https:\/\/erpschools.com\/erps\/#\/schema\/person\/dbed9bb7fb66aa7a700fc565da024512"},"headline":"Trading Community Architecture (TCA) API","datePublished":"2011-04-14T11:06:36+00:00","dateModified":"2015-08-12T22:03:57+00:00","mainEntityOfPage":{"@id":"https:\/\/erpschools.com\/erps\/api\/ar-api\/tca"},"wordCount":1838,"commentCount":10,"publisher":{"@id":"https:\/\/erpschools.com\/erps\/#organization"},"image":{"@id":"https:\/\/erpschools.com\/erps\/api\/ar-api\/tca#primaryimage"},"thumbnailUrl":"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041411_1106_TCA1.gif","keywords":["tca","trading community architecture"],"articleSection":["AR API"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/erpschools.com\/erps\/api\/ar-api\/tca#respond"]}]},{"@type":"WebPage","@id":"https:\/\/erpschools.com\/erps\/api\/ar-api\/tca","url":"https:\/\/erpschools.com\/erps\/api\/ar-api\/tca","name":"TCA oracle apps","isPartOf":{"@id":"https:\/\/erpschools.com\/erps\/#website"},"primaryImageOfPage":{"@id":"https:\/\/erpschools.com\/erps\/api\/ar-api\/tca#primaryimage"},"image":{"@id":"https:\/\/erpschools.com\/erps\/api\/ar-api\/tca#primaryimage"},"thumbnailUrl":"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041411_1106_TCA1.gif","datePublished":"2011-04-14T11:06:36+00:00","dateModified":"2015-08-12T22:03:57+00:00","description":"Trading Community Architecture (TCA) is a concept designed to support complex trading communities.","breadcrumb":{"@id":"https:\/\/erpschools.com\/erps\/api\/ar-api\/tca#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/erpschools.com\/erps\/api\/ar-api\/tca"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/erpschools.com\/erps\/api\/ar-api\/tca#primaryimage","url":"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041411_1106_TCA1.gif","contentUrl":"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041411_1106_TCA1.gif"},{"@type":"BreadcrumbList","@id":"https:\/\/erpschools.com\/erps\/api\/ar-api\/tca#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/erpschools.com\/erps"},{"@type":"ListItem","position":2,"name":"Trading Community Architecture (TCA) API"}]},{"@type":"WebSite","@id":"https:\/\/erpschools.com\/erps\/#website","url":"https:\/\/erpschools.com\/erps\/","name":"erpSchools","description":"Oracle Apps","publisher":{"@id":"https:\/\/erpschools.com\/erps\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/erpschools.com\/erps\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/erpschools.com\/erps\/#organization","name":"erpSchools","url":"https:\/\/erpschools.com\/erps\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/erpschools.com\/erps\/#\/schema\/logo\/image\/","url":"https:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/erps_logo7.png","contentUrl":"https:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/erps_logo7.png","width":250,"height":60,"caption":"erpSchools"},"image":{"@id":"https:\/\/erpschools.com\/erps\/#\/schema\/logo\/image\/"},"sameAs":["http:\/\/facebook.com\/erpschools"]},{"@type":"Person","@id":"https:\/\/erpschools.com\/erps\/#\/schema\/person\/dbed9bb7fb66aa7a700fc565da024512","name":"Prudhvi","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/erpschools.com\/erps\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/488cec3605845b95cb20e60c67a8f5c7e74b65a305525c8006315d524f120db9?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/488cec3605845b95cb20e60c67a8f5c7e74b65a305525c8006315d524f120db9?s=96&d=blank&r=g","caption":"Prudhvi"},"sameAs":["http:\/\/www.erpschools.com"],"url":"https:\/\/erpschools.com\/erps\/author\/prudhvi"}]}},"_links":{"self":[{"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/posts\/963","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/comments?post=963"}],"version-history":[{"count":0,"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/posts\/963\/revisions"}],"wp:attachment":[{"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/media?parent=963"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/categories?post=963"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/tags?post=963"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}