Search Results ap_bank_branches
The AR_CASH_RECEIPTS_ALL
table in Oracle E-Business Suite (EBS) 12.1.1 or 12.2.2 is a critical component of the Accounts Receivable (AR) module, serving as the primary repository for recording and managing cash receipt transactions. This table stores comprehensive details about incoming payments, refunds, and adjustments, facilitating efficient cash application, reconciliation, and financial reporting. Below is a detailed breakdown of its structure, functionality, and significance within Oracle EBS.
1. Purpose and Role
TheAR_CASH_RECEIPTS_ALL
table captures all cash receipt entries, including:
- Payments from Customers: Checks, wire transfers, credit cards, or other payment methods.
- Refunds: Amounts returned to customers.
- Miscellaneous Receipts: Non-invoice-related cash inflows (e.g., deposits).
2. Key Columns and Data Structure
The table includes columns to track receipt attributes, such as:- CASH_RECEIPT_ID: Primary key, uniquely identifying each receipt.
- RECEIPT_NUMBER: User-assigned or system-generated identifier.
- AMOUNT: Total receipt value.
- CURRENCY_CODE: Currency of the transaction.
- RECEIPT_DATE: Date of receipt creation.
- TYPE: Distinguishes between standard receipts, refunds, or miscellaneous entries.
- STATUS: Tracks workflow (e.g., "APPROVED," "REVERSED").
- CUSTOMER_ID: Links to
HZ_CUST_ACCOUNTS
for customer details. - GL_DATE: Date posted to the GL.
- ORG_ID: Supports multi-org architecture.
3. Integration with Other Modules
The table interacts with:- AR_CASH_RECEIPT_HISTORY_ALL: Stores activity history (e.g., adjustments, reversals).
- AR_DISTRIBUTIONS_ALL: Tracks accounting entries for GL integration.
- AR_PAYMENT_SCHEDULES_ALL: Links receipts to invoices for cash application.
- CE_BANK_ACCT_USES_ALL: Associates receipts with bank accounts for reconciliation.
4. Functional Workflow
- Creation: Receipts are entered manually or via AutoLockbox.
- Application: Payments are matched to open invoices using rules or manual methods.
- Accounting: Distributions generate GL journal entries upon posting.
- Reconciliation: Bank statements are reconciled against receipts in Cash Management.
5. Customization and Extensions
Common enhancements include:- Custom validations via triggers or APIs.
- Integration with third-party payment gateways.
- Reporting extensions using BI Publisher or Oracle Reports.
6. Audit and Compliance
The table supports audit trails through:- WHO columns (
CREATED_BY
,LAST_UPDATE_DATE
). - Integration with Oracle Audit Vault.
7. Performance Considerations
Indexes onCASH_RECEIPT_ID
, RECEIPT_NUMBER
, and CUSTOMER_ID
optimize queries. Partitioning may be used for high-volume environments.
Conclusion
TheAR_CASH_RECEIPTS_ALL
table is central to Oracle AR’s cash management capabilities, ensuring accurate payment tracking, seamless integration with financial systems, and compliance with accounting standards. Its design supports scalability, auditability, and multi-org functionality, making it indispensable for organizations using Oracle EBS.
-
View: AR_TA_VUP_DETAILS_V
12.1.1
product: AR - Receivables , implementation_dba_data: Not implemented in this database ,
-
Table: AR_CASH_RECEIPTS_ALL
12.1.1
owner:AR, object_type:TABLE, fnd_design_data:AR.AR_CASH_RECEIPTS_ALL, object_name:AR_CASH_RECEIPTS_ALL, status:VALID, product: AR - Receivables , description: Detailed receipt information , implementation_dba_data: AR.AR_CASH_RECEIPTS_ALL ,
-
View: AR_TA_VUP_DETAILS_V
12.2.2
product: AR - Receivables , implementation_dba_data: Not implemented in this database ,
-
Table: AR_CASH_RECEIPTS_ALL
12.2.2
owner:AR, object_type:TABLE, fnd_design_data:AR.AR_CASH_RECEIPTS_ALL, object_name:AR_CASH_RECEIPTS_ALL, status:VALID, product: AR - Receivables , description: Detailed receipt information , implementation_dba_data: AR.AR_CASH_RECEIPTS_ALL ,
-
View: AR_OEX_RECEIPTS_VIEW
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:AR.AR_OEX_RECEIPTS_VIEW, object_name:AR_OEX_RECEIPTS_VIEW, status:VALID, product: AR - Receivables , description: This is the view for the Oracle Exchange Bill Presentment Payments page. , implementation_dba_data: APPS.AR_OEX_RECEIPTS_VIEW ,
-
View: AR_OEX_RECEIPTS_VIEW
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:AR.AR_OEX_RECEIPTS_VIEW, object_name:AR_OEX_RECEIPTS_VIEW, status:VALID, product: AR - Receivables , description: This is the view for the Oracle Exchange Bill Presentment Payments page. , implementation_dba_data: APPS.AR_OEX_RECEIPTS_VIEW ,
-
Table: AR_BATCHES_ALL
12.2.2
owner:AR, object_type:TABLE, fnd_design_data:AR.AR_BATCHES_ALL, object_name:AR_BATCHES_ALL, status:VALID, product: AR - Receivables , description: Receipt batch information , implementation_dba_data: AR.AR_BATCHES_ALL ,
-
Table: AR_INTERIM_CASH_RECEIPTS_ALL
12.1.1
owner:AR, object_type:TABLE, fnd_design_data:AR.AR_INTERIM_CASH_RECEIPTS_ALL, object_name:AR_INTERIM_CASH_RECEIPTS_ALL, status:VALID, product: AR - Receivables , description: QuickCash payments processed by the PostBatch program , implementation_dba_data: AR.AR_INTERIM_CASH_RECEIPTS_ALL ,
-
Table: AR_INTERIM_CASH_RECEIPTS_ALL
12.2.2
owner:AR, object_type:TABLE, fnd_design_data:AR.AR_INTERIM_CASH_RECEIPTS_ALL, object_name:AR_INTERIM_CASH_RECEIPTS_ALL, status:VALID, product: AR - Receivables , description: QuickCash payments processed by the PostBatch program , implementation_dba_data: AR.AR_INTERIM_CASH_RECEIPTS_ALL ,
-
Table: AR_BATCHES_ALL
12.1.1
owner:AR, object_type:TABLE, fnd_design_data:AR.AR_BATCHES_ALL, object_name:AR_BATCHES_ALL, status:VALID, product: AR - Receivables , description: Receipt batch information , implementation_dba_data: AR.AR_BATCHES_ALL ,
-
View: AR_CUSTOMER_BANK_ACCOUNTS_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:AR.AR_CUSTOMER_BANK_ACCOUNTS_V, object_name:AR_CUSTOMER_BANK_ACCOUNTS_V, status:VALID, product: AR - Receivables , description: (Release 10SC Only) , implementation_dba_data: APPS.AR_CUSTOMER_BANK_ACCOUNTS_V ,
-
View: AR_CUSTOMER_BANK_ACCOUNTS_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:AR.AR_CUSTOMER_BANK_ACCOUNTS_V, object_name:AR_CUSTOMER_BANK_ACCOUNTS_V, status:VALID, product: AR - Receivables , description: (Release 10SC Only) , implementation_dba_data: APPS.AR_CUSTOMER_BANK_ACCOUNTS_V ,