What is TCA architecture?
Oracle Trading Community Architecture (TCA) is a data model that allows you to manage complex information about the parties, or customers, who belong to your commercial community, including organizations, locations, and the network of hierarchical relationships among them.
What is TCA API?
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.
What is a party in Oracle?
A party is an umbrella relationship across customer, vendor, employee and similar entities. Standard Party Roles like CUSTOMER, VENDOR, DEALER, EMPLOYEE, SALES CHANNEL REPRESENTATIVE are pre-defined in Oracle Communications Data Model with their sub-types.
What is Hz tables in Oracle Apps?
The HZ_LOCATIONS table stores information about a delivery or postal address such as building number, street address, postal code, and directions to a location. This table provides physical location information about parties (organizations and people) and customer accounts.
How do I create a new customer in Oracle Apps r12?
To create a customer:
- Navigate to the Create Customer page. The Create Customer page displays differently, depending upon your customer type selection, Organization or Person, on the Customer Search page.
- Enter customer, account, and account site details.
- Click Save And Add Details or Apply.
What is the difference between party and customer?
A customer is someone who has a buying relationship with the company. So how do we distinguish between a person who has bought something and someone who hasnt purchased anything from you? This is where the party definition comes into picture. A party is anybody that exists.
What is party model?
The “party model” is a “pattern” for relational database design. At least part of it involves finding commonality between many entities, such as Customer, Employee, Partner, etc., and factoring that into some more “abstract” database tables.
What is Hz_party_site_uses?
HZ_PARTY_SITE_USES stores information about how a party uses a. particular site or address.=20. A party site can have multiple site uses such as bill-to or ship-to. Some of the columns are — PARTY_SITE_USE_ID (PK)
Which Oracle ERP table stores information about customers?
HZ_CUST_ACCOUNTS
The HZ_CUST_ACCOUNTS table stores information about customer accounts , or business relationships that the deploying company establishes with a party of type Organization or Person.
How do you make an inactive customer in r12?
Go to the Party Maintenance tab. Enter the Registry Id in “Registry Id” field that was noted in step 2 and click “Go”. (as per step 2, it should be “Active”). Change the status drop down to “Inactive” and click “Save”.
What is universal data model?
‘Universal Data Model’ (UDM) is a package that provides uniform access to models using a meta-programmable interface. UDM uses a metamodel in the style of (GME) UML class diagrams as the metamodel for data. This UDM-metamodel could be automatically generated from a GME metamodel.
https://www.youtube.com/watch?v=rTs4de9-3KE