|
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
|
--> 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)
