Join the OracleApps88 Telegram group @OracleApps88to get more information on Oracle EBS R12/Oracle Fusion applications.

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.

Tuesday, September 15, 2015

Oracle Trading Community Architecture (TCA) API list and Metalink Note IDs


Entity
File Name
Package Defined
Description
Party - Organization
ARH2PASB.pls ARH2PASS.pls
HZ_PARTY_V2PUB
Package contains public API for person, organization and group.
Party Site/Party Site Use
ARH2PSSB.pls ARH2PSSS.pls
HZ_PARTY_SITE_V2PUB
Package has create and update procedures for all party site related tables.
Location
ARH2LOSB.pls ARH2LOSS.pls
HZ_LOCATION_V2PUB
Package contains public API for locations.
Party Contact(Organization Contact) and Contact Role
ARH2PCSS.pls ARH2PCSB.pls
HZ_PARTY_CONTACT_V2PUB
Package has create and update procedures for contact and contact role.
Credit Ratings
ARH2PRSS.pls ARH2PRSB.pls
HZ_PARTY_INFO_V2PUB
This package contains public API for credit ratings.
Contact Point
ARH2CPSB.pls ARH2CPSB.pls
HZ_CONTACT_POINT_V2PUB

This package contains public API for contact points.
Customer Account/Customer Account Relationship
ARH2CASB.pls ARH2CASS.pls
HZ_CUST_ACCOUNT_V2PUB
Package for creating/updating customer accounts and related entities e.g. customer account relationship.
Customer Account Site/Customer Account Site Use
ARH2CSSB.pls ARH2CSSS.pls
HZ_CUST_ACCOUNT_SITE_V2PUB
Package contains public API for customer account sites and site uses.
Customer Profiles /
Customer Account Site Use Profile / Customer Account Site use Profile Amount
ARH2CFSB.pls ARH2CFSS.pls
HZ_CUSTOMER_PROFILE_V2PUB
Package contains public API for customer profiles and customer profile amounts.
Customer Account Site Role (Contact) /
Customer Account Site Role Responsibility
ARH2CRSS.pls ARH2CRSB.pls
HZ_CUST_ACCOUNT_ROLE_V2PUB
This package contains public API for customer account roles and role * responsibilities.
Relationship between two parties
ARH2RESS.pls / ARH2RESB.pls
HZ_RELATIONSHIP_V2PUB
This Package has create and update procedures for relationships
Parties and Customer Accounts
ARH2RTSS.pls / ARH2RTSB.pls
HZ_RELATIONSHIP_TYPE_V2PUB
This Package has create and update procedures for relationship types
Parties and Customer Accounts
ARH2CLSS.pls / ARH2CLSB.pls
HZ_CLASSIFICATION_V2PUB
This package contains public API for class categories, class code relationships, class code assignments and class category uses.

Process
API
Table
Create/Update Organization TCA API
HZ_PARTY_V2PUB.create_organization
HZ_PARTY_V2PUB.update_organization
HZ_PARTY_V2PUB.get_organization_rec
HZ_PARTY_V2PUB.get_party_rec
HZ_PARTIES, HZ_ORGANIZATION_PROFILES, HZ_ORIG_SYS_REFERENCES
Create/Update Person TCA API
HZ_PARTY_V2PUB.create_person
HZ_PARTY_V2PUB.update_person
HZ_PARTIES, HZ_ORGANIZATION_PROFILES, HZ_ORIG_SYS_REFERENCES
Create Group TCA API
HZ_PARTY_V2PUB.create_group
HZ_PARTY_V2PUB.update_group
HZ_PARTY_V2PUB.get_group_rec
HZ_PARTIES, HZ_ORIG_SYS_REFERENCES
Create Credit Ratings TCA API
HZ_PARTY_INFO_V2PUB.create_credit_rating
HZ_PARTY_INFO_V2PUB.update_credit_rating
HZ_PARTY_INFO_V2PUB.get_credit_rating_rec
HZ_CREDIT_RATINGS
Create Org Contact TCA API
HZ_PARTY_CONTACT_V2PUB.create_org_contact
HZ_ORG_CONTACTS HZ_ORIG_SYS_REFERENCES (Optional - HZ_RELATIONSHIPS HZ_PARTIES)
Create Org Contact Role TCA API
HZ_PARTY_CONTACT_V2PUB.create_org_contact_role
HZ_ORG_CONTACT_ROLES, HZ_ORIG_SYS_REFERENCES
Create Location TCA API
HZ_LOCATION_V2PUB.create_location
HZ_LOCATION_V2PUB.update_location
HZ_LOCATION_V2PUB.get_location_rec
HZ_LOCATIONS, HZ_ORIG_SYS_REFERENCES
Create Location Assignment TCA API
HZ_TAX_ASSIGNMENT_V2PUB.create_loc_assignment
HZ_TAX_ASSIGNMENT_V2PUB.update_loc_assignment 
HZ_LOC_ASSIGNMENTS
Create Party Site TCA API
HZ_PARTY_SITE_V2PUB.create_party_site
HZ_PARTY_SITE_V2PUB.update_party_site
HZ_PARTY_SITES, HZ_ORIG_SYS_REFERENCES
Create Party Site Use TCA API
HZ_PARTY_SITE_V2PUB.create_party_site_use
HZ_PARTY_SITE_V2PUB.update_party_site_use
HZ_PARTY_SITE_V2PUB.get_party_site_rec
HZ_PARTY_SITE_USES
Create Contact Point TCA API
HZ_CONTACT_POINT_V2PUB 
HZ_CONTACT_POINTS, HZ_ORIG_SYS_REFERENCES
Create Relationship Type TCA API
HZ_RELATIONSHIP_TYPE_V2PUB.create_relationship_type
HZ_RELATIONSHIP_TYPE_V2PUB.update_relationship_type
HZ_RELATIONSHIP_TYPES
Create Relationship TCA API
HZ_RELATIONSHIP_V2PUB.create_relationship
HZ_RELATIONSHIP_V2PUB.update
_relationship
HZ_RELATIONSHIPS
Create Class Category TCA API
HZ_CLASSIFICATION_V2PUB.create_class_category    
HZ_CLASSIFICATION_V2PUB.update_class_category   
HZ_CLASSIFICATION_V2PUB.get_class_category_rec
HZ_CLASS_CATEGORIES
Create Class Category Use TCA API
HZ_CLASSIFICATION_V2PUB.create_class_category_use
HZ_CLASSIFICATION_V2PUB.update_class_category_use    
HZ_CLASSIFICATION_V2PUB.get_class_category_use_rec
HZ_CLASS_CATEGORY_USES
Create Class Code Relation TCA API
HZ_CLASSIFICATION_V2PUB.create_class_code_relation
HZ_CLASSIFICATION_V2PUB.update_class_code_relation
HZ_CLASSIFICATION_V2PUB.get_class_code_relation_rec
HZ_CLASS_CODE_RELATIONS
Create Code Assignment TCA API
HZ_CLASSIFICATION_V2PUB.create_code_assignment
HZ_CLASSIFICATION_V2PUB. update_code_assignment
HZ_CLASSIFICATION_V2PUB.get_code_assignment_rec
HZ_CODE_ASSIGNMENTS
Create Customer Account Relationship TCA API
HZ_CUST_ACCOUNT_V2PUB.create_cust_acct_relate
HZ_CUST_ACCOUNT_V2PUB.update_cust_acct_relate
HZ_CUST_ACCOUNT_V2PUB.get_cust_acct_relate_rec
HZ_CUST_ACCT_RELATE
Create Customer Account Site Use TCA API
HZ_CUST_ACCOUNT_SITE_V2PUB.create_cust_site_use
HZ_CUST_ACCOUNT_SITE_V2PUB.update_cust_site_use
HZ_CUST_ACCOUNT_SITE_V2PUB.get_cust_site_use_rec
HZ_CUST_SITE_USES, HZ_ORIG_SYS_REFERENCES
Create Customer Profile TCA API
HZ_CUSTOMER_PROFILE_V2PUB.create_customer_profile
HZ_CUSTOMER_PROFILE_V2PUB.update_customer_profile
HZ_CUSTOMER_PROFILE_V2PUB.get_customer_profile_rec
HZ_CUSTOMER_PROFILES
Create Customer Profile Amount TCA API
HZ_CUSTOMER_PROFILE_V2PUB.create_cust_profile_amt
HZ_CUSTOMER_PROFILE_V2PUB.update_cust_profile_amt
HZ_CUSTOMER_PROFILE_V2PUB.get_cust_profile_amt_rec
HZ_CUST_PROFILE_AMTS
Create Customer Account Role TCA API
HZ_CUST_ACCOUNT_ROLE_V2PUB.create_cust_account_role
HZ_CUST_ACCOUNT_ROLE_V2PUB.update_cust_account_role
HZ_CUST_ACCOUNT_ROLE_V2PUB.get_cust_account_role_rec
HZ_CUST_ACCOUNT_ROLES, HZ_ORIG_SYS_REFERENCES
Create Role Responsibility TCA API
HZ_CUST_ACCOUNT_ROLE_V2PUB.create_role_responsibility
HZ_CUST_ACCOUNT_ROLE_V2PUB.update_role_responsibility
HZ_CUST_ACCOUNT_ROLE_V2PUB.get_role_responsibility_rec
HZ_ROLE_RESPONSIBILITY
Create Source System Reference TCA API
HZ_ORIG_SYSTEM_REF_PUB.create_orig_system_reference
HZ_ORIG_SYSTEM_REF_PUB.update_orig_system_reference
HZ_ORIG_SYSTEM_REF_PUB.get_orig_sys_reference_rec
HZ_ORIG_SYS_MAPPING

Metalink IDs for TCA APIs
--> Create/Update Organization (Party) Level
How to Update a Customer Organization (Party) Using TCA API? [Document 1644668.1]
Oracle Trading Community:How to Create a Customer Account Type : Organization Using TCA API? [Document 1639526.1]
How To Create A Contact Role At Customer(Org) Level Via TCA API ? [Document 269087.1]
How to update the category_code to a customer (ORGANIZATION) using TCA-API? [Document 243018.1]
How to Update the Last Name to Customer (PERSON) via TCA-API? [Document 233276.1]
TCA API Usage: How To Inactive A Party Of Type Person Using Standard TCA-API [Document 551655.1]
How to run Api Hz_party_search.Find_parties Example [Document 804145.1]

--> Create/Update Party Site Level
How To Create An Organization Customer With Profile Information At Site Level Using TCA-API? [Document 313094.1]
How To Create A Contact Role At Customer(Org) Level Via TCA API ? [Document 269087.1]

--> Create/Update Customer Account Level
How To Create An Organization Customer With Profile Information At How To Create A Customer Profile Amount At Customer Level Using TCA API? [Document 245695.1]
How To Create A Customer Profile For A Specific Account Using TCA API? [Document 294978.1]
TCA API: How to create a Customer Account for an existing PARTY? [Document 204545.1]
How to Create an (ORGANIZATION) Customer Inserting Descriptive Flexfield on HZ_PARTIES via TCA API? [Document 261258.1]
How To Create A Contact At Customer Level With Phone Via TCA API [Document 235357.1]
How To Create A Contact At Customer Level Without Phone Via TCA API ? [Document 177082.1]
How to Create a customer (ORGANIZATION) with dunning info = N via TCA API? [Document 204415.1]
How to Create a customer (ORGANIZATION) with dunning info = Y via TCA API? [Document 204416.1]
How to Create an (ORGANIZATION) customer using Customer Information Descriptive Flexfield via TCA API? [Document 217578.1]
Customer Account Creation Using TCA APIs [Document 837568.1]
How To Create A Contact At Customer Level Without Phone Via TCA API [Document 177082.1]
how to update a customer (organization) with interest charges = Y to interest charges = N via TCA API? [Document 215695.1]
How Do You Use TCA API To Populate Date Established for Customer Records? [Document 1536604.1]
TCA API: How to pass the TAX Registration number and Tax Payer ID number using APIs (Sample Code) [Document 435294.1]

--> Create/Update Customer Account Site Level
How to create two BILL_TO sites for the same customer via TCA API [Document 177080.1]
How to create BILL_TO and SHIP_TO sites via TCA API [Document 177081.1]
How to create a customer (ORGANIZATION) via TCA API with account_number off and party_number on? [Document 219150.1]
Site Level Using TCA-API? [Document 313094.1]
How To Create A Contact At Customer Level With Phone Via TCA API? [Document 235357.1]
How To Create A Contact At Address Level With Phone Via TCA API? [Document 239737.1]
How to Insert a Customer Information with Profile and Profiles Amounts-(No default values) Information Using TCA API? [Document 301410.1]
How To Create A Contact Role At Customer(Org) Level Via TCA API ? [Document 269188.1]
How to Update the Salesperson Information for a Specific Customer via TCA API? [Document 230751.1]
Customer API: How to Update Addressee Field Information using TCA API [Document 219595.1]
How To Create A Contact At Address Level Without Phone Via TCA API ? [Document 177083.1]
How To Create A Contact At Address Level Without Phone Via TCA API using conditions like HZ: Generate Contact Number = No [Document 294142.1]
How To Create A Phone at Address level via TCA API ? [Document 239738.1]
How To Create A New BILL_TO Address To An Existing Customer Via TCA API ? [Document 165308.1]
How to Create an (ORGANIZATION) customer using Address Information Descriptive Flexfield via TCA API? [Document 217579.1]
How to Create an (ORGANIZATION) customer using Site Use Information Descriptive Flexfield via TCA API? [Document 217580.1]
TCA API Issue: How to Create a Customer with Salesperson Information [Document 230750.1]
How to Insert a customer Information with profile and default profiles amounts information using TCA API? [Document 301409.1]
TCA API: How To Insert A Customer Information With Profile Information Using TCA API? [Document 301408.1]
TCA API Issue: How to Create a Customer with Salesperson Information [Document 230750.1]
How to Create an (ORGANIZATION) customer using Customer Information Descriptive Flexfield via TCA API? [Document 217578.1]
How to Create an (ORGANIZATION) customer using Address Information Descriptive Flexfield via TCA API? [Document 217579.1]
How to Create an (ORGANIZATION) customer using Site Use Information Descriptive Flexfield via TCA API? [Document 217580.1]
How to create two BILL_TO sites for the same customer via TCA API [Document 177080.1]
How To Create A Contact At Address Level Without Phone Via TCA API [Document 177083.1]
How to Create a customer (ORGANIZATION) with dunning info = N via TCA API? [Document 204415.1]
How to Create a customer (ORGANIZATION) with dunning info = Y via TCA API? [Document 204416.1]
How To Add A Contact At Customer Level Without Phone Via TCA API [Document 187975.1]
How to update a ORG-customer with dunning info=N to dunning info=Y via TCA API? [Document 204558.1]
How to update a ORG-customer with dunning info=Y to dunning info=N via TCA API? [Document 204559.1]
How To Add A Contact At Address Level Without Phone Via TCA API [Document 187976.1]
How To Create A Phone at Address level via TCA API [Document 239738.1]
How To Insert Two BILL_TO Sites For The Same Customer Via TCA API [Document 187973.1]
How To Create A Customer Via TCA API ? [Document 189369.1]
How to create a PERSON customer via TCA API ? [Document 204170.1]
How to Update a location Information using TCA API [Document 219589.1]
How to create a customer for an specific organization but using different location using TCA API [Document 239993.1]
TCA API: Sample Code to Create AR Customer & Site from AP Supplier & Supplier Site using same Party (Party_id and party_site_id) [Document 1447883.1]
TCA API Usage: How To Assign Price List To Customer Ship To Site Using API [Document 1595423.1]
TCA API: What API Can Be Used to Populated Balance Forward Billing Related Fields at Customer or Site Profile? [Document 1597141.1]
What TCA API Can Assign the Geometry Code to the HZ_LOCATIONS Table? [Document 1623809.1]

--> Create/Update Customer Contact Information Level
How To update A Contact Phone Information Via TCA API [Document 260287.1]
API Issue: How to Create Contact, Phone and Email under Communication tab for Customer Account Site using API [Document 985500.1]
How To Create A Contact At Address Level Without Phone Via TCA API Using Conditions Like HZ: Generate Contact Number = No [Document 294142.1]
How To Add A New BILL_TO Address To An Existing Customer Via TCA API ? [Document 165308.1]
How To Run The Create_org_contact API And Get The Contact To Be Associated At The Account Level ? [Document 1618881.1]

--> Create/Update Customer Account Relationship Level
How to Create Customer Account Relationship via TCA API? [Document 224494.1]
TCA API: How to Use TCA API to Update a Relationship in Release 12? [Document 1319881.1]
Customer APIs: How to Update Customer Account Related Information (Relationships Tab in Customer Form) [Document 236662.1]
How to update a Customer Account Relationship via TCA API? [Document 224495.1]
Sample Code to Create Relationship between two Party using TCA API HZ_RELATIONSHIP_V2PUB [Document 758278.1]

--> Create/Update Customer Account Level Notes with JAVA API
How to create a PERSON customer with site using TCA JAVA-API ? (Doc ID 242929.1)

--> Create/Update Customer Account Site Level with JAVA API
How to create an ORGANIZATION customer with site using TCA JAVA-API ? (Doc ID 242931.1) 

1 comment:

raj said...

Super ..very nice info

Post a Comment

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.
Best Blogger TipsGet Flower Effect