TCA (Trading Community Architecture)
TCA (Trading Community
Architecture) is designed to support complex trading communities.
It works as central repository
for customers, suppliers, bank across the Oracle e-businesses suite R11
There are two to add the
data in the system
- RACUST: Customer Interface
- API: Application Programming Interface
RACUST:
In this we insert the data in RA_Customers_interface_all
table and imported in system using standard interface import program with
validation. We can view the output by selecting the request and view output. Also
we can see the detailed log in view log file. This provides basic data
insertion and validations.
API:
This Provide extensive error handing and
reporting mechanism at every stage and errors get inserted in error stack.
Status Error for API
x_return_status informs the
caller about the operation result.
- Success (FND_API.G_RET_STS_SUCCESS)
- Error (FND_API.G_RET_STS_ERROR)
Unexpected error (FND_API.G_RET_STS_UNEXP_ERROR)
API Example:
Before running the API we
need to set the organization id
EXEC
fnd_client_info.set_org_context('<orgid>');
Organization Creation API
API Package: HZ_PARTY_V2PUB
API procedure: CREATE_ORGANIZATION
Tables: HZ_PARTIES
HZ_ORGANIZATION_PROFILES
Create Person API
API Package: HZ_PARTY_V2PUB
API procedure: CREATE_PERSON
Tables: HZ_PARTIES
HZ_PERSON_PROFILES
Create Group
API
API Package: HZ_PARTY_V2PUB
API procedure: CREATE_GROUP
Tables: HZ_PARTIES
Create Org
Contact API
API Package: HZ_PARTY_CONTACT_V2PUB
API procedure: CREATE_ORG_CONTACT
Tables: HZ_ORG_CONTACTS
HZ_RELATIONSHIPS
Create
Location API
API Package: HZ_LOCATION_V2PUB
API procedure: CREATE_LOCATION
Tables:
HZ_LOCATIONS
Create Party
Site API
API Package: HZ_PARTY_SITE_V2PUB
API procedure: CREATE_PARTY_SITE
Tables:
HZ_PARTY_SITES
Create Party
Site Use API
API Package: HZ_PARTY_SITE_V2PUB
API procedure: CREATE_PARTY_SITE_USE
Tables:
HZ_PARTY_SITE_USES
Create
Customer Account API
API Package: HZ_CUST_ACCOUNT_V2PUB
API procedure: CREATE_CUST_ACCOUNT
Tables:
HZ_CUST_ACCOUNTS
HZ_CUSTOMER_PROFILES
Create
Customer Account Site API
API Package: HZ_CUST_ACCOUNT_SITE_V2PUB
API procedure: CREATE_CUST_ACCT_SITE
Tables:
HZ_CUST_ACCT_SITES
Create
Customer Account Site Use API
API Package: HZ_CUST_ACCOUNT_SITE_V2PUB
API procedure: CREATE_CUST_SITE_USE
Tables:
HZ_CUST_SITE_USES
