Search Results hz_party_relationship_v
DeepseekTRM - AR Tables and Views in Oracle EBS 12.1.1/12.2.2
Oracle E-Business Suite (EBS) Receivables (AR) module relies on a comprehensive set of tables and views to manage customer transactions, invoices, receipts, and accounting entries. DeepseekTRM provides technical reference documentation for these critical database objects in Oracle EBS 12.1.1 and 12.2.2. Below is a detailed overview of key AR tables and views:
Core AR Tables
- RA_CUSTOMERS - Master table storing customer information including name, address, and contact details.
- RA_CUST_TRX_TYPES - Defines transaction types for invoices, debit memos, and credit memos.
- RA_CUST_TRX_LINE_GL_DIST - Contains accounting distributions for transaction lines.
- AR_CASH_RECEIPTS - Stores receipt header information including receipt number and amount.
- AR_CASH_RECEIPT_HISTORY - Tracks the status history of cash receipts.
- AR_PAYMENT_SCHEDULES - Maintains payment schedule information for customer transactions.
- AR_ADJUSTMENTS - Records adjustments made to customer accounts.
- AR_DISTRIBUTIONS - Contains accounting entries for AR transactions.
Important AR Views
- AR_VAT_TAX_ALL - Provides tax information for transactions.
- AR_TRANSACTION_HISTORY_V - Shows transaction history with status changes.
- AR_PAYMENT_SCHEDULES_V - Combines payment schedule data with related transaction information.
- AR_CASH_RECEIPTS_V - Presents receipt information with related application details.
- AR_CUSTOMER_BALANCES_V - Displays current customer account balances.
Technical Architecture
The AR module follows Oracle's application table architecture with:
- Header tables (e.g., RA_CUSTOMERS) storing master data
- Line tables (e.g., RA_CUSTOMER_TRX_LINES) containing transaction details
- Distribution tables (e.g., RA_CUST_TRX_LINE_GL_DIST) handling accounting entries
- Interface tables (e.g., RA_INTERFACE_LINES_ALL) for data import/export
- Temporary tables for batch processing
Integration Points
AR tables integrate with other EBS modules through:
- GL_INTERFACE for general ledger postings
- AP_INVOICES for supplier invoices
- OE_ORDER_HEADERS for order management
- XLA_AE_LINES for Subledger Accounting
Key Technical Considerations
- Multi-org architecture implemented through ORG_ID column
- Set of Books (SOB) information stored in GL tables
- Flexfield columns for customizable data elements
- Audit columns (CREATED_BY, CREATION_DATE, etc.) for tracking changes
- Status columns controlling workflow (e.g., STATUS in AR_PAYMENT_SCHEDULES)
DeepseekTRM documentation provides complete data dictionaries including column definitions, indexes, constraints, and relationships between these tables and views. This technical reference is essential for custom reporting, data extraction, and system integrations in Oracle EBS AR implementations.
-
View: HZ_PARTY_RELATIONSHIP_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:AR.HZ_PARTY_RELATIONSHIP_V, object_name:HZ_PARTY_RELATIONSHIP_V, status:VALID, product: AR - Receivables , implementation_dba_data: APPS.HZ_PARTY_RELATIONSHIP_V ,
-
View: HZ_PARTY_RELATIONSHIP_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:AR.HZ_PARTY_RELATIONSHIP_V, object_name:HZ_PARTY_RELATIONSHIP_V, status:VALID, product: AR - Receivables , implementation_dba_data: APPS.HZ_PARTY_RELATIONSHIP_V ,
-
APPS.PV_TAP_BES_PKG dependencies on HZ_PARTY_RELATIONSHIP_V
12.2.2
-
APPS.PV_TAP_BES_PKG dependencies on JTF_RS_RESOURCE_EXTNS
12.2.2
-
APPS.PV_TAP_BES_PKG dependencies on HZ_PARTIES
12.2.2
-
PACKAGE BODY: APPS.PV_TAP_BES_PKG
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PV_TAP_BES_PKG, status:VALID,
-
APPS.PV_TAP_BES_PKG dependencies on PV_PARTNER_PROFILES
12.2.2
-
12.1.1 FND Design Data
12.1.1
-
12.2.2 FND Design Data
12.2.2
-
APPS.PV_TAP_BES_PKG SQL Statements
12.2.2
-
VIEW: APPS.AR_LOOKUPS
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:AR.AR_LOOKUPS, object_name:AR_LOOKUPS, status:VALID,
-
VIEW: APPS.AR_LOOKUPS
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:AR.AR_LOOKUPS, object_name:AR_LOOKUPS, status:VALID,
-
SYNONYM: APPS.HZ_RELATIONSHIPS
12.1.1
owner:APPS, object_type:SYNONYM, object_name:HZ_RELATIONSHIPS, status:VALID,
-
SYNONYM: APPS.HZ_RELATIONSHIPS
12.2.2
owner:APPS, object_type:SYNONYM, object_name:HZ_RELATIONSHIPS, status:VALID,
-
VIEW: APPS.HZ_PARTY_RELATIONSHIP_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:AR.HZ_PARTY_RELATIONSHIP_V, object_name:HZ_PARTY_RELATIONSHIP_V, status:VALID,
-
VIEW: APPS.HZ_PARTY_RELATIONSHIP_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:AR.HZ_PARTY_RELATIONSHIP_V, object_name:HZ_PARTY_RELATIONSHIP_V, status:VALID,
-
SYNONYM: APPS.HZ_PARTIES
12.2.2
owner:APPS, object_type:SYNONYM, object_name:HZ_PARTIES, status:VALID,
-
SYNONYM: APPS.HZ_PARTIES
12.1.1
owner:APPS, object_type:SYNONYM, object_name:HZ_PARTIES, status:VALID,
-
PACKAGE BODY: APPS.PV_TAP_BES_PKG
12.2.2
-
12.2.2 DBA Data
12.2.2
-
eTRM - AR Tables and Views
12.2.2
description: Territory information ,
-
12.1.1 DBA Data
12.1.1
-
eTRM - AR Tables and Views
12.1.1
description: Territory information ,
-
eTRM - AR Tables and Views
12.1.1
description: Territory information ,
-
eTRM - AR Tables and Views
12.2.2
description: Territory information ,