Search Results ap_unselected_invoices_all

The AP_UNSELECTED_INVOICES_ALL table in Oracle E-Business Suite (EBS) 12.1.1 or 12.2.2 is a critical repository for temporarily storing invoice data that has not yet been selected for payment processing. This table plays a pivotal role in the Accounts Payable (AP) module, particularly during the payment batch selection process. Below is a detailed analysis of its structure, functionality, and integration within Oracle EBS.

Purpose and Functionality

The AP_UNSELECTED_INVOICES_ALL table acts as a staging area for invoices that are excluded from payment runs due to predefined criteria or manual intervention. When users initiate a payment batch, Oracle EBS evaluates invoices against selection rules (e.g., due dates, payment terms, holds). Invoices failing these criteria are logged in this table, ensuring transparency and auditability. This facilitates troubleshooting and allows AP teams to review excluded invoices before reprocessing.

Key Columns and Data Structure

The table's schema includes columns essential for tracking unselected invoices:

INVOICE_ID: Primary key reference to AP_INVOICES_ALL.
CHECKRUN_ID: Links to AP_SELECTED_INVOICES_ALL for payment batch correlation.
REJECTION_REASON_CODE: Categorizes exclusions (e.g., "HOLD," "TERMS_NOT_MET").
CREATION_DATE and LAST_UPDATE_DATE: Timestamps for audit trails.
ORG_ID: Supports multi-org architecture in EBS.

Integration with Payment Workflow

During payment batch creation:

Oracle EBS queries payable invoices from AP_INVOICES_ALL.
Invoices meeting selection criteria populate AP_SELECTED_INVOICES_ALL.
Excluded invoices are written to AP_UNSELECTED_INVOICES_ALL with rejection reasons.

This segregation enables users to generate "Unselected Invoices" reports via Oracle Standard Reports or custom queries.

Customization and Extensions

Organizations often extend the table's utility by:

Developing custom alerts for specific rejection reasons.
Creating APIs to auto-resolve issues (e.g., releasing holds).
Building reconciliation scripts comparing AP_UNSELECTED_INVOICES_ALL with GL accruals.

Performance Considerations

In high-volume environments:

Indexes on INVOICE_ID and CHECKRUN_ID optimize join operations.
Partitioning by ORG_ID or CREATION_DATE improves query performance.
Regular purging of historical records via concurrent programs reduces table bloat.

Audit and Compliance

The table serves as a compliance artifact by:

Documenting payment selection decisions for SOX audits.
Providing traceability for internal controls over disbursements.
Supporting dispute resolution with vendors regarding payment timing.

Conclusion

The AP_UNSELECTED_INVOICES_ALL table is a foundational component of Oracle EBS's AP architecture, ensuring systematic handling of payment exclusions. Its design aligns with Oracle's best practices for financial data integrity while offering flexibility for organizational-specific enhancements. Proper utilization of this table streamlines payment operations and strengthens fiscal governance.

Table: AP_UNSELECTED_INVOICES_ALL 12.2.2
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_UNSELECTED_INVOICES_ALL, object_name:AP_UNSELECTED_INVOICES_ALL, status:VALID, product: AP - Payables , description: This table holds invoices that could not be paid by a payment batch. , implementation_dba_data: AP.AP_UNSELECTED_INVOICES_ALL ,
Table: AP_UNSELECTED_INVOICES_ALL 12.1.1
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_UNSELECTED_INVOICES_ALL, object_name:AP_UNSELECTED_INVOICES_ALL, status:VALID, product: AP - Payables , description: This table holds invoices that could not be paid by a payment batch. , implementation_dba_data: AP.AP_UNSELECTED_INVOICES_ALL ,
APPS.AP_PAYMENT_UTIL_PKG dependencies on AP_UNSELECTED_INVOICES_ALL 12.1.1
APPS.AP_PMT_CALLOUT_PKG dependencies on AP_UNSELECTED_INVOICES_ALL 12.2.2
APPS.AP_PMT_CALLOUT_PKG dependencies on AP_UNSELECTED_INVOICES_ALL 12.1.1
APPS.AP_AUTOSELECT_PKG dependencies on AP_UNSELECTED_INVOICES_ALL 12.1.1
APPS.AP_AUTOSELECT_PKG dependencies on AP_UNSELECTED_INVOICES_ALL 12.2.2
APPS.AP_PAYMENT_UTIL_PKG dependencies on AP_UNSELECTED_INVOICES_ALL 12.2.2
APPS.AP_AUTOSELECT_PKG dependencies on AP_UNSELECTED_INVOICES 12.2.2
APPS.AP_AUTOSELECT_PKG dependencies on AP_UNSELECTED_INVOICES 12.1.1
APPS.AP_AUTOSELECT_PKG dependencies on FND_STATS 12.2.2
VIEW: AP.AP_UNSELECTED_INVOICES_ALL# 12.2.2
owner:AP, object_type:VIEW, object_name:AP_UNSELECTED_INVOICES_ALL#, status:VALID,
SYNONYM: APPS.AP_UNSELECTED_INVOICES_ALL 12.1.1
owner:APPS, object_type:SYNONYM, object_name:AP_UNSELECTED_INVOICES_ALL, status:VALID,
SYNONYM: APPS.AP_UNSELECTED_INVOICES_ALL 12.2.2
owner:APPS, object_type:SYNONYM, object_name:AP_UNSELECTED_INVOICES_ALL, status:VALID,
TABLE: AP.AP_UNSELECTED_INVOICES_ALL 12.1.1
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_UNSELECTED_INVOICES_ALL, object_name:AP_UNSELECTED_INVOICES_ALL, status:VALID,
VIEW: AP.AP_UNSELECTED_INVOICES_ALL# 12.2.2
TABLE: AP.AP_UNSELECTED_INVOICES_ALL 12.2.2
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_UNSELECTED_INVOICES_ALL, object_name:AP_UNSELECTED_INVOICES_ALL, status:VALID,
SYNONYM: APPS.AP_UNSELECTED_INVOICES 12.1.1
owner:APPS, object_type:SYNONYM, object_name:AP_UNSELECTED_INVOICES, status:VALID,
SYNONYM: APPS.AP_UNSELECTED_INVOICES 12.2.2
owner:APPS, object_type:SYNONYM, object_name:AP_UNSELECTED_INVOICES, status:VALID,
Table: AP_INV_SELECTION_CRITERIA_ALL 12.1.1
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_INV_SELECTION_CRITERIA_ALL, object_name:AP_INV_SELECTION_CRITERIA_ALL, status:VALID, product: AP - Payables , description: Payment batch invoice selection criteria , implementation_dba_data: AP.AP_INV_SELECTION_CRITERIA_ALL ,
Table: AP_INV_SELECTION_CRITERIA_ALL 12.2.2
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_INV_SELECTION_CRITERIA_ALL, object_name:AP_INV_SELECTION_CRITERIA_ALL, status:VALID, product: AP - Payables , description: Payment batch invoice selection criteria , implementation_dba_data: AP.AP_INV_SELECTION_CRITERIA_ALL ,
PACKAGE BODY: APPS.AP_PAYMENT_UTIL_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:AP_PAYMENT_UTIL_PKG, status:VALID,
PACKAGE BODY: APPS.AP_PAYMENT_UTIL_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:AP_PAYMENT_UTIL_PKG, status:VALID,
PACKAGE BODY: APPS.AP_AUTOSELECT_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:AP_AUTOSELECT_PKG, status:VALID,
PACKAGE BODY: APPS.AP_PMT_CALLOUT_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:AP_PMT_CALLOUT_PKG, status:VALID,
PACKAGE BODY: APPS.AP_PMT_CALLOUT_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:AP_PMT_CALLOUT_PKG, status:VALID,
PACKAGE BODY: APPS.AP_AUTOSELECT_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:AP_AUTOSELECT_PKG, status:VALID,
12.2.2 DBA Data 12.2.2
APPS.AP_PAYMENT_UTIL_PKG SQL Statements 12.1.1
12.1.1 FND Design Data 12.1.1
12.1.1 DBA Data 12.1.1
12.2.2 DBA Data 12.2.2
12.2.2 FND Design Data 12.2.2
12.2.2 DBA Data 12.2.2
Table: AP_INVOICES_ALL 12.1.1
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_INVOICES_ALL, object_name:AP_INVOICES_ALL, status:VALID, product: AP - Payables , description: Detailed invoice records , implementation_dba_data: AP.AP_INVOICES_ALL ,
Table: AP_INVOICES_ALL 12.2.2
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_INVOICES_ALL, object_name:AP_INVOICES_ALL, status:VALID, product: AP - Payables , description: Detailed invoice records , implementation_dba_data: AP.AP_INVOICES_ALL ,
APPS.AP_PAYMENT_UTIL_PKG SQL Statements 12.2.2
12.1.1 DBA Data 12.1.1
12.2.2 DBA Data 12.2.2
12.1.1 DBA Data 12.1.1
12.2.2 DBA Data 12.2.2
APPS.AP_PMT_CALLOUT_PKG dependencies on AP_SELECTED_INVOICES_ALL 12.2.2
APPS.AP_PMT_CALLOUT_PKG SQL Statements 12.1.1
PACKAGE BODY: APPS.AP_PAYMENT_UTIL_PKG 12.1.1
APPS.AP_PMT_CALLOUT_PKG SQL Statements 12.2.2
PACKAGE BODY: APPS.AP_PAYMENT_UTIL_PKG 12.2.2
APPS.AP_PMT_CALLOUT_PKG dependencies on FND_LOG 12.1.1
APPS.AP_AUTOSELECT_PKG SQL Statements 12.1.1
APPS.AP_PMT_CALLOUT_PKG dependencies on FND_LOG 12.2.2
APPS.AP_AUTOSELECT_PKG SQL Statements 12.2.2