Search Results hold_description

Overview

APPS.AP_WEB_EXPORT_ER is a server-side PL/SQL package in Oracle E-Business Suite that supports the Oracle Internet Expenses (OIE) module. Its principal business function is to export approved expense reports from the Internet Expenses schema into the Oracle Payables invoice interface tables, thereby enabling expense reports to be converted into supplier invoices for payment. The package bridges the Expenses data model (expense report headers, lines, and distributions) and the Payables open interface (AP_INVOICES_INTERFACE and AP_INVOICE_LINES_INTERFACE), assembling the invoice header, line, and payee information required by the Payables Invoice Import process.

The package is owned by APPS and is classified as OTHER in the ETRM metadata for release 12.2.2. Its source header indicates it was last shipped in the 12.1.x code line, and it remains valid across both 12.1.1 and 12.2.2. The presence of the record type InvoiceInfoRecType reveals that the package constructs an in-memory projection of expense report header attributes—including employee, location, address, vendor, currency, and exchange rate fields—before writing those values to the interface tables.

Key Procedures and Functions

• EXPORTERTOAP — The primary driver procedure. It orchestrates the export of expense reports to Payables, invoking the supporting routines that build and insert invoice interface records.
• INSERTINVOICEINTERFACE — Populates the AP_INVOICES_INTERFACE table with invoice header records derived from expense report header data.
• INSERTINVOICELINESINTERFACE — Populates AP_INVOICE_LINES_INTERFACE with invoice line records derived from expense report lines and distributions.
• VALIDATEERLINES — Validates expense report lines prior to export, identifying conditions that should prevent or flag the report from being passed to Payables.
• UPDATEDISTSWITHRECEIPTINFO — Updates expense report distribution records with receipt-related information, ensuring that distributions carry the documentation required for the downstream invoice.
• GETVENDORINFO — Retrieves supplier and supplier site information needed to establish the payee on the generated invoice.
• CREATEPAYEE — Creates or resolves the payee record associated with the expense report so the Payables invoice has a valid supplier reference.

Tables Accessed

The package reads from and writes to a range of Expenses, Payables, and HR tables via APPS synonyms. Expense report source data is drawn from AP_EXPENSE_REPORT_HEADERS, AP_EXPENSE_REPORT_HEADERS_ALL, AP_EXPENSE_REPORT_LINES, AP_EXPENSE_REPORT_LINES_ALL, AP_EXP_REPORT_DISTS, and AP_EXP_REPORT_DISTS_ALL, along with AP_EXPENSE_REPORT_PARAMS_ALL and AP_CREDIT_CARD_TRXNS_ALL for report parameters and credit card transactions. Output is written to AP_INVOICES_INTERFACE and AP_INVOICE_LINES_INTERFACE, the Payables open interface tables processed by Invoice Import. Supplier and payee resolution uses AP_SUPPLIERS and AP_SUPPLIER_SITES. Employee and location attributes are sourced from PER_ALL_PEOPLE_F and HR locations. AP_INTERFACE_REJECTIONS captures records that fail interface validation, and AP_INVOICES is referenced for existing invoice information.

Usage Notes

AP_WEB_EXPORT_ER is normally invoked indirectly by the Oracle Internet Expenses export process, which submits the workflow that moves approved expense reports into Payables. It is not exposed as an end-user API; customizations should call it only through the supported export flow. The referenced hold_description field appears in the package source as part of a commented-out block (lines 31–33) alongside hold_lookup_code and nls_hold_code, indicating hold-related columns were considered for but not included in the InvoiceInfoRecType record. The package is referenced by zero other packages per the ETRM metadata, confirming it acts as a top-level entry point rather than a shared utility.