Search Results ap_invoices_all
The AP_INVOICES_ALL
table is a fundamental component of Oracle E-Business Suite (EBS) Release 12.1.1 and 12.2.2, specifically within the Accounts Payable (AP) module. It serves as the primary repository for all supplier invoice records, capturing critical financial and operational data required for processing, validation, and payment. This table is part of the Oracle Applications database schema and is essential for maintaining invoice integrity, audit trails, and financial reporting.
Table Structure and Key Columns
TheAP_INVOICES_ALL
table contains numerous columns that store invoice-related information. Key columns include:
- INVOICE_ID: The primary key, uniquely identifying each invoice.
- INVOICE_NUM: The user-defined invoice number assigned by the supplier or AP department.
- VENDOR_ID: References the supplier in the
PO_VENDORS
table. - INVOICE_DATE: The date the invoice was issued by the supplier.
- INVOICE_AMOUNT: The total amount of the invoice, including taxes and discounts.
- INVOICE_CURRENCY_CODE: The currency in which the invoice is denominated.
- PAYMENT_STATUS_FLAG: Indicates whether the invoice is paid, unpaid, or partially paid.
- ORG_ID: Supports multi-org functionality, linking the invoice to a specific operating unit.
- CREATION_DATE and LAST_UPDATE_DATE: Audit columns tracking when the record was created or modified.
Functional Role in Oracle EBS
TheAP_INVOICES_ALL
table is central to the AP workflow, enabling:
- Invoice Entry and Validation: Stores raw invoice data entered manually or via automated interfaces (e.g., EDI, XML). Validations include matching against purchase orders (POs) or receipts.
- Approval Workflow: Tracks approval statuses, routing invoices through predefined hierarchies.
- Payment Processing: Links to payment schedules (
AP_PAYMENT_SCHEDULES_ALL
) and payment batches (AP_CHECKS_ALL
). - Tax and Accounting Integration: Integrates with the General Ledger (GL) via the
AP_ACCOUNTING_EVENTS_ALL
table for accruals and expense postings. - Reporting and Analytics: Supports standard AP reports (e.g., Invoice Register, Aging Reports) and custom queries.
Integration with Other Modules
The table interacts with several EBS modules:- Purchasing (PO): References
PO_HEADERS_ALL
for PO-matched invoices. - General Ledger (GL): Distributes accounting entries via
AP_INVOICE_DISTRIBUTIONS_ALL
. - Cash Management (CE): Reconciles payments with bank statements.
- Tax (ZX): Stores tax details in related tables like
AP_INVOICE_LINES_ALL
.
Multi-Org and Security
The_ALL
suffix denotes multi-org support, allowing data partitioning by ORG_ID
. Access is controlled via Oracle’s Virtual Private Database (VPD) policies, ensuring users only view invoices for their assigned operating units.
Technical Considerations
- Indexing: Key indexes include
AP_INVOICES_U1
(onINVOICE_ID
) andAP_INVOICES_N1
(onVENDOR_ID
). - Partitioning: Large implementations may partition the table by
INVOICE_DATE
for performance. - API Usage: Oracle provides PL/SQL APIs (e.g.,
AP_INVOICES_PKG
) for programmatic access.
Conclusion
TheAP_INVOICES_ALL
table is a cornerstone of Oracle EBS Accounts Payable, enabling end-to-end invoice processing. Its design supports scalability, compliance, and integration across financial modules, making it indispensable for organizations leveraging Oracle EBS 12.1.1 or 12.2.2. Proper understanding of its structure and relationships is critical for customization, reporting, and troubleshooting in AP operations.
-
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.JL_JLCOPCWT_XMLP_PKG dependencies on AP_INVOICES_ALL
12.1.1
-
APPS.IGIPMSMD dependencies on AP_INVOICES_ALL
12.1.1
-
APPS.IBY_PAYMENT_FORMAT_VAL_PVT dependencies on AP_INVOICES_ALL
12.1.1
-
APPS.POS_AP_INVOICE_PAYMENTS_PKG dependencies on AP_INVOICES_ALL
12.1.1
-
APPS.OKL_CREATE_DISB_TRANS_PVT dependencies on AP_INVOICES_ALL
12.1.1
-
APPS.AP_RETAINAGE_RELEASE_PKG dependencies on AP_INVOICES_ALL
12.1.1
-
APPS.POA_EDW_SPEND_PKG dependencies on AP_INVOICES_ALL
12.1.1
-
APPS.PJM_TRANSFER_CHARGES_PKG dependencies on AP_INVOICES_ALL
12.1.1
-
APPS.PA_PWP_INVOICE_REL dependencies on AP_INVOICES_ALL
12.1.1
-
APPS.FII_AP_INV_SUM_INC dependencies on AP_INVOICES_ALL
12.1.1
-
APPS.AP_APPROVAL_MATCHED_PKG dependencies on AP_INVOICES_ALL
12.1.1
-
APPS.CSE_AP_PA_PKG dependencies on AP_INVOICES_ALL
12.1.1
-
APPS.PA_WORK_TYPE_UPGRADE dependencies on AP_INVOICES_ALL
12.1.1
-
APPS.IGI_STP_CREATE_PCK_PKG dependencies on AP_INVOICES_ALL
12.1.1
-
APPS.AP_IMPORT_UTILITIES_PKG dependencies on AP_INVOICES_ALL
12.1.1
-
APPS.JAI_AP_MISC_PKG dependencies on AP_INVOICES_ALL
12.1.1
-
APPS.JA_JAINITCL_XMLP_PKG dependencies on AP_INVOICES_ALL
12.1.1
-
APPS.AP_WEB_UTILITIES_PKG dependencies on AP_INVOICES_ALL
12.1.1
-
APPS.JE_JEPLPSSR_XMLP_PKG dependencies on AP_INVOICES_ALL
12.1.1
-
APPS.AP_WEB_DB_AP_INT_PKG dependencies on AP_INVOICES_ALL
12.1.1
-
APPS.FTE_FPA_UTIL dependencies on AP_INVOICES_ALL
12.1.1
-
APPS.PSA_AP_BC_PVT dependencies on AP_INVOICES_ALL
12.1.1
-
APPS.ZX_JL_EXTRACT_PKG dependencies on AP_INVOICES_ALL
12.1.1
-
APPS.GMS_FUNDS_CONTROL_PKG dependencies on AP_INVOICES_ALL
12.1.1
-
APPS.AP_WEB_AUDIT_PROCESS dependencies on AP_INVOICES_ALL
12.1.1
-
APPS.AP_ETAX_SERVICES_PKG dependencies on AP_INVOICES_ALL
12.1.1
-
APPS.AP_RCT_AMT_MATCH_PKG dependencies on AP_INVOICES_ALL
12.1.1
-
APPS.IGC_CC_ARCHIVE_PURGE_PKG dependencies on AP_INVOICES_ALL
12.1.1
-
APPS.PA_TRX_IMPORT dependencies on AP_INVOICES_ALL
12.1.1
-
APPS.IGI_CIS2007_IGIPMTHR_PKG dependencies on AP_INVOICES_ALL
12.1.1
-
APPS.OPI_EDW_COGS_F_SZ dependencies on AP_INVOICES_ALL
12.1.1
-
APPS.AP_WEB_EXPORT_ER dependencies on AP_INVOICES_ALL
12.1.1
-
APPS.JA_JAINSTAC_XMLP_PKG dependencies on AP_INVOICES_ALL
12.1.1
-
APPS.PA_PROJ_TSK_UTILS dependencies on AP_INVOICES_ALL
12.1.1
-
APPS.AP_ACCOUNTING_PAY_PKG dependencies on AP_INVOICES_ALL
12.1.1
-
APPS.GMS_AP_API dependencies on AP_INVOICES_ALL
12.1.1
-
APPS.AP_ETAX_SERVICES_PKG dependencies on AP_INVOICES_ALL
12.1.1
-
APPS.IGI_EXP_HOLDS dependencies on AP_INVOICES_ALL
12.1.1
-
APPS.AP_FUNDS_CONTROL_PKG dependencies on AP_INVOICES_ALL
12.1.1
-
APPS.FII_AP_INV_DISTRIBUTIONS_B_C dependencies on AP_INVOICES_ALL
12.1.1
-
APPS.FII_SIZING_UTIL dependencies on AP_INVOICES_ALL
12.1.1
-
APPS.JA_JAINSTAC_XMLP_PKG dependencies on AP_INVOICES_ALL
12.2.2
-
APPS.PA_FUNDS_CONTROL_UTILS dependencies on AP_INVOICES_ALL
12.2.2
-
APPS.AP_WORKFLOW_PKG dependencies on AP_INVOICES_ALL
12.2.2
-
APPS.CST_ACCRUAL_LOAD dependencies on AP_INVOICES_ALL
12.2.2
-
APPS.FV_FACTS1_GL_PKG dependencies on AP_INVOICES_ALL
12.2.2
-
APPS.AP_REPORTS_UTILITY_PKG dependencies on AP_INVOICES_ALL
12.2.2
-
APPS.AP_GET_SUPPLIER_BALANCE_PKG dependencies on AP_INVOICES_ALL
12.2.2