Search Results ap_interface_groups_s

Overview

APPS.ECEINI is an inbound integration package in the Oracle E-Business Suite ECE (e-Commerce Gateway) module. Its purpose is to process inbound invoice data delivered from external trading partners and load that data into Oracle Payables through the standard Open Interface tables. The package sits at the boundary between the ECE inbound processing framework and the AP invoice interface, acting as the bridge that parses staged file or XML content, resolves the appropriate interface group, and inserts validated invoice records into AP_INVOICES_INTERFACE.

The object is documented with a status of VALID in both 12.1.1 and 12.2.2 and is owned by APPS. It is classified as OTHER in the ETRM API classification, indicating it is an internal implementation package rather than a published, supported PL/SQL API. It is not referenced by any other database object, so it functions as an entry point rather than a shared utility library.

Key Procedures and Functions

• PROCESS_INVOICE_INBOUND — The principal entry point for the package. It drives the inbound invoice flow: it accepts inbound staged data, maps the source transaction to Oracle columns using the ECE mapping framework, and performs the insert into the Payables open interface. This procedure is the one invoked during an inbound invoice batch run.
• GET_GROUP_ID — Resolves the interface group identifier required for the inbound load. Interface groups in Payables govern control totals, batch grouping, and error handling for interface data, so this function is what ties the inbound ECE transaction to a valid AP_INTERFACE_GROUPS_S record.

The metadata documents two procedures or functions in total. Parameter lists are not published in the ETRM extract and are therefore not reproduced here.

Tables Accessed

• AP_INTERFACE_GROUPS_S — The Payables interface groups table. Accessed to determine or confirm the interface group under which inbound invoices are loaded, which is the direct reason a search for "ap_interface_groups_s" surfaces this package.
• AP_INVOICES_INTERFACE — The Payables invoice open interface table. This is the primary write target: staged inbound invoice data is inserted here for subsequent validation and import by the Payables Invoice Import program.
• ECE_MAPPINGS — Holds the ECE mapping definitions used to translate inbound trading partner data elements into Oracle Payables columns.
• DUAL — Used for scalar lookups and single-row PL/SQL evaluations.
• PLITBLM — The PL/SQL integer table type used internally for array/collection handling.

Usage Notes

ECEINI is invoked as part of the inbound e-Commerce Gateway invoice process rather than from a standard EBS form. It is typically triggered either by the ECE inbound concurrent program that processes arrived transactions or by custom code that stages inbound invoice data through the ECE inbound framework. It also draws on a set of supporting packages, notably ECE_FLATFILE_PVT, ECE_INBOUND, EC_INBOUND_STAGE, EC_MAPPING_UTILS, EC_XML_UTILS, and EC_UTILS, which confirm its dependence on both flat-file and XML inbound delivery paths.

Because the package relies on FND_REQUEST, FND_PROFILE, and MO_GLOBAL, it participates in concurrent request submission, profile-option resolution, and multi-org security context. From a customization standpoint, ECEINI is not a documented public API and carries an OTHER classification, so direct calls from custom code are not supported and should be avoided in favor of the standard interface table and the Payables Invoice Import path. It is not referenced by any other database object, reinforcing that it is a terminal entry point. Its presence in a dependency search for AP_INTERFACE_GROUPS_S indicates that any diagnostic or impact analysis touching that table should include this package.