AR — Receivables
610 documented tables · 709 views — Oracle EBS ETRM 12.2.2
Most-referenced tables
| Table | Description | Data Vault class* |
|---|---|---|
HZ_PARTIES |
Information about parties such as organizations, people, and groups | hub |
HZ_PARTY_SITES |
Links party to physical locations | hub |
HZ_CUST_ACCOUNTS |
Stores information about customer accounts. | hub |
HZ_LOCATIONS |
Physical addresses | hub |
RA_TERMS_B |
Payment Term information | hub |
HZ_CUST_SITE_USES_ALL |
Stores business purposes assigned to customer account sites. | hub-leaning |
HZ_CUST_ACCT_SITES_ALL |
Stores all customer account sites across all operating units | hub |
RA_TERRITORIES |
Territory information | hub-leaning |
HZ_TIMEZONES |
Time zone information | hub-leaning |
RA_CUST_TRX_TYPES_ALL |
Transaction type for invoices, commitments and credit memos | hub |
RA_CUSTOMER_TRX_ALL |
Header-level information about invoices, debit memos, chargebacks, commitments and credit memos | hub |
HZ_ORG_CONTACTS |
People as contacts for parties | hub-leaning |
HZ_CUST_ACCOUNT_ROLES |
Roles that parties perform in customer accounts | hub-leaning |
RA_CUSTOMERS |
Customer information | hub |
AR_LOCATION_VALUES_OLD |
Defines the location and description for each of the value sets used in the Sales Tax Location flexfield | hub |
*Heuristic classification mined from FK structure — a modeling suggestion, not Oracle's.
Key public APIs
| Package | Class | Procedures | Used by |
|---|---|---|---|
AR_RECEIPT_API_PUB |
PUB | 23 | 48 packages |
AR_INVOICE_API_PUB |
PUB | 6 | 14 packages |
AR_CMGT_CREDIT_REQUEST_API |
API | 4 | 12 packages |
AR_ADJUST_PUB |
PUB | 5 | 9 packages |
AR_INVOICE_SQL_FUNC_PUB |
PUB | 10 | 8 packages |
AR_BILLS_MAINTAIN_PUB |
PUB | 19 | 6 packages |
AR_CREDIT_MEMO_API_PUB |
PUB | 7 | 6 packages |
AR_BILLS_MAINTAIN_STATUS_PUB |
PUB | 10 | 5 packages |
AR_DEFERRAL_REASONS_GRP |
GRP | 3 | 5 packages |
AR_AUTOREC_API |
API | 10 | 4 packages |