Search Results receipts

The AP_MATCHED_RECT_ADJ_ALL table in Oracle E-Business Suite (EBS) 12.1.1 or 12.2.2 is a critical repository for storing matched reconciliation adjustments related to Accounts Payable (AP) transactions. This table plays a pivotal role in the financial reconciliation process, ensuring accuracy and consistency between supplier invoices, payments, and accounting entries. Below is a detailed summary of its structure, purpose, and integration within Oracle EBS.

Purpose and Functionality

The AP_MATCHED_RECT_ADJ_ALL table is designed to track adjustments made during the reconciliation of supplier invoices and payments. These adjustments may arise from discrepancies such as partial payments, discounts, write-offs, or currency exchange differences. The table ensures that all adjustments are systematically recorded, providing an audit trail for financial reporting and compliance. It is integral to Oracle Payables' ability to maintain accurate financial records and support the General Ledger (GL) reconciliation process.

Key Columns and Data Structure

The table contains several important columns, including:

MATCHED_RECT_ADJ_ID: A unique identifier for each adjustment record.
INVOICE_ID: References the invoice involved in the adjustment (links to AP_INVOICES_ALL).
PAYMENT_ID: References the payment record (links to AP_PAYMENTS_ALL).
ADJUSTMENT_TYPE: Specifies the nature of the adjustment (e.g., discount, write-off).
AMOUNT: The monetary value of the adjustment.
GL_DATE: The date the adjustment is posted to the General Ledger.
ACCOUNTING_EVENT_ID: Links to the accounting event in XLA_EVENTS for Subledger Accounting (SLA) integration.
CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE: Audit columns tracking record creation and modifications.

Integration with Oracle EBS Modules

The AP_MATCHED_RECT_ADJ_ALL table interacts with multiple Oracle EBS modules:

Accounts Payable (AP): Directly tied to invoice and payment processing, ensuring adjustments are reflected in supplier balances.
General Ledger (GL): Adjustments are posted to GL via Subledger Accounting, ensuring accurate financial statements.
Subledger Accounting (SLA): Uses ACCOUNTING_EVENT_ID to map adjustments to accounting entries in XLA_AE_LINES.
Cash Management (CE): Supports bank reconciliation by aligning payment adjustments with bank statements.

Technical Considerations

The table is part of the multi-org architecture in Oracle EBS, with records partitioned by ORG_ID to support multiple operating units. It is indexed on key columns like INVOICE_ID, PAYMENT_ID, and MATCHED_RECT_ADJ_ID for performance optimization. Customizations or extensions to this table should be approached cautiously, as it is tightly integrated with Oracle's seeded reconciliation logic.

Conclusion

The AP_MATCHED_RECT_ADJ_ALL table is a foundational component of Oracle EBS's Accounts Payable module, ensuring financial integrity by systematically tracking reconciliation adjustments. Its design supports auditability, multi-org functionality, and seamless integration with GL and SLA, making it indispensable for accurate financial reporting and compliance in organizations using Oracle EBS 12.1.1 or 12.2.2.

Lookup Type: OIE_NOTIFY_RCT_RECEIVED 12.2.2
product: AP - Payables , meaning: Expenses Notify When Receipts Are Received , description: Expenses Notify When Receipts Are Received ,
Lookup Type: OIE_IMG_ASSIGN_AUDITOR_STAGE 12.2.2
product: AP - Payables , meaning: Assign Auditor to the reports that require image receipts , description: Assign Auditor to the reports that require image receipts ,
Lookup Type: OIE_NOTIFY_RCT_RECEIVED 12.1.1
product: AP - Payables , meaning: Expenses Notify When Receipts Are Received , description: Expenses Notify When Receipts Are Received ,
Lookup Type: OIE_HOLD_TYPES 12.1.1
product: AP - Payables , meaning: Expense Report Hold Types , description: Expense Report Hold Types ,
Concurrent Program: APWRECPT 12.1.1
execution_filename: AP_WEB_RECEIPTS_WF.TrackOverdue , product: AP - Payables , user_name: Expenses Overdue Receipts Tracking , description: Expenses Overdue Receipts Tracking , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Lookup Type: OIE_HOLD_TYPES 12.2.2
product: AP - Payables , meaning: Expense Report Hold Types , description: Expense Report Hold Types ,
Concurrent Program: APWRECPT 12.2.2
execution_filename: AP_WEB_RECEIPTS_WF.TrackOverdue , product: AP - Payables , user_name: Expenses Overdue Receipts Tracking , description: Expenses Overdue Receipts Tracking , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Lookup Type: OIE_AUDIT_ACTIONS 12.1.1
product: AP - Payables , meaning: Expenses Audit Actions , description: Expenses Audit Actions ,
Lookup Type: OIE_AUDIT_ACTIONS 12.2.2
product: AP - Payables , meaning: Expenses Audit Actions , description: Expenses Audit Actions ,
Concurrent Program: APXMTMRR 12.2.2
execution_filename: APXMTMRR , product: AP - Payables , user_name: APXMTMRR , description: Matched and Modified Receipts report , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,
Lookup Type: OIE_LINE_ADJUSTMENT_REASONS 12.2.2
product: AP - Payables , meaning: Line Adjustment Reasons , description: Line Adjustment Reasons ,
Concurrent Program: APXMTMRR 12.1.1
execution_filename: APXMTMRR , product: AP - Payables , user_name: APXMTMRR , description: Matched and Modified Receipts report , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,
Lookup Type: EXPENSE REPORT STATUS 12.2.2
product: AP - Payables , meaning: Expense Report Status , description: Expense Report Status ,
Lookup Type: OIE_AUD_WAIVE_REASONS 12.1.1
product: AP - Payables , meaning: Expenses Audit Waive Reasons , description: Expenses Audit Waive Reasons ,
Lookup Type: OIE_AUD_WAIVE_REASONS 12.2.2
product: AP - Payables , meaning: Expenses Audit Waive Reasons , description: Expenses Audit Waive Reasons ,
Concurrent Program: APXMTMRR_XML 12.1.1
product: AP - Payables , user_name: Matched and Modified Receipts Report (XML) - Not Supported: Reserved For Future Use , description: Matched and Modified Receipts Report , argument_method: Standard , enabled: No , execution_method: Java Concurrent Program ,
Concurrent Program: APXMTMRR_XML 12.2.2
product: AP - Payables , user_name: Matched and Modified Receipts Report (XML) - Not Supported: Reserved For Future Use , description: Matched and Modified Receipts Report , argument_method: Standard , enabled: No , execution_method: Java Concurrent Program ,
Lookup Type: OIE_NIGHT_RATES 12.1.1
product: AP - Payables , meaning: Night Rates , description: Night rate options used by policy compliance ,
Lookup Type: OIE_NIGHT_RATES 12.2.2
product: AP - Payables , meaning: Night Rates , description: Night rate options used by policy compliance ,
Lookup Type: OIE_BP_CC_HOLD_TYPES 12.1.1
product: AP - Payables , meaning: Expenses Credit Card Both Pay Hold Types , description: Expenses Credit Card Both Pay Hold Types ,
Lookup Type: OIE_BP_CC_HOLD_TYPES 12.2.2
product: AP - Payables , meaning: Expenses Credit Card Both Pay Hold Types , description: Expenses Credit Card Both Pay Hold Types ,
Lookup Type: OIE_AUD_RETURN_REASONS 12.1.1
product: AP - Payables , meaning: Audit Return Reasons , description: Audit Return Reasons ,
Lookup Type: OIE_AUD_RETURN_REASONS 12.2.2
product: AP - Payables , meaning: Audit Return Reasons , description: Audit Return Reasons ,
Lookup Type: EXPENSE REPORT STATUS 12.1.1
product: AP - Payables , meaning: Expense Report Status , description: Expense Report Status ,
Table: AP_MATCHED_RECT_ADJ_ALL 12.2.2
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_MATCHED_RECT_ADJ_ALL, object_name:AP_MATCHED_RECT_ADJ_ALL, status:VALID, product: AP - Payables , description: Tracks receipts that have been modified after invoices have been matched to them , implementation_dba_data: AP.AP_MATCHED_RECT_ADJ_ALL ,
Table: AP_MATCHED_RECT_ADJ_ALL 12.1.1
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_MATCHED_RECT_ADJ_ALL, object_name:AP_MATCHED_RECT_ADJ_ALL, status:VALID, product: AP - Payables , description: Tracks receipts that have been modified after invoices have been matched to them , implementation_dba_data: AP.AP_MATCHED_RECT_ADJ_ALL ,