Search Results process_invoice_inbound

Overview

APPS.ECEINI is a public PL/SQL package in Oracle E-Business Suite that supports the inbound processing of supplier invoices through the e-Commerce Gateway interface. Its name follows the ECE (e-Commerce Gateway) naming convention, and the "INI" suffix denotes inbound invoice handling. The package provides a single entry point for reading an external invoice file, mapping its contents into the Oracle Payables open interface tables, and optionally invoking the Payables Invoice Import program to validate and create invoice records. It belongs to the ETRM integration layer and is classified as an "OTHER" API rather than a formally published public API.

In EBS 12.1.1 and 12.2.2 the package remains substantially unchanged in purpose. The 12.2.2 metadata records an older header revision (2005), indicating that the implementation is stable and predates the multi-org and online patching changes of 12.2. The package declares AUTHID CURRENT_USER, so it executes with the privileges of the calling session rather than as definer, and it relies on APPS synonyms for all table access.

Key Procedures and Functions

• PROCESS_INVOICE_INBOUND — The principal driver procedure. It accepts a file path and file name identifying the inbound invoice data file, control flags governing whether Invoice Import runs, batch and hold naming attributes, a GL date, a purge flag, a summarize flag, a transaction type, a mapping identifier, a debug mode indicator, and a source character set. It reads and interprets the flat file, applies the specified ECE mapping, and loads invoice rows into the Payables open interface. Optional parameters control hold application, purge behavior after import, and summarization of interface lines. Standard concurrent program OUT parameters (errbuf, retcode) allow the procedure to surface errors and completion status.
• GET_GROUP_ID — An internal helper (documented as introduced under Bug 2598743) that obtains a group identifier from the AP interface groups sequence. The group identifier binds a set of interface rows to a single inbound load so that Invoice Import and subsequent purge operations can select them consistently.

Tables Accessed

• AP_INTERFACE_GROUPS_S — The interface group sequence used by GET_GROUP_ID to allocate unique group identifiers for each inbound run.
• AP_INVOICES_INTERFACE — The Payables open interface table into which inbound invoice header and line data is inserted or updated prior to Invoice Import.
• ECE_MAPPINGS — The e-Commerce Gateway mapping definitions that translate the external file layout into open interface columns, selected by the mapping identifier parameter.
• DUAL — Used for singleton PL/SQL expressions and sequence access.
• PLITBLM — The standard Oracle file-handling package used to read the inbound flat file from the server file system.

Usage Notes

ECEINI is typically invoked from a concurrent program in the e-Commerce Gateway or Payables responsibility, where an administrator specifies the inbound file, mapping, batch name, and import options. It is also called from custom PL/SQL that automates inbound invoice loading, and in some configurations from the e-Commerce Gateway inbound transaction flow. The OUT error buffer and return code make it suitable for direct integration with the concurrent manager framework.

Because the package is classified as "OTHER" and is not referenced by any other packaged API, it should be treated as an internal implementation component. Customizations that call it directly must supply the full file path and mapping identifier, and must be re-validated after patching because the package is not a committed public interface. In 12.2.2 environments, callers should also account for online patching file system editions when specifying the inbound file path.