Search Results populate_supplier_sched_api1

Overview

APPS.ECE_SPSO_TRANS1 is a PL/SQL package in the Oracle E-Business Suite (EBS) Applications schema (APPS) that supports the Supplier Scheduling and Supplier Portal integration between Oracle Purchasing/Supply Chain modules and Oracle E-Commerce Gateway (ECE/ETRM). The package name references ECE (E-Commerce Gateway), SPSO (Supplier Portal Schedule Output), and TRANS (transformation). Its role is to transform supplier schedule data residing in the CHV (Supplier Scheduling / Collaborative Planning) and ECE staging tables into the outbound XML/document format consumed by suppliers through the Oracle Supplier Portal Network or via ECI/EDI schedules.

The package is classified as an OTHER API in ETRM 12.2.2, meaning it is not a fully published, externally supported open interface but an internal utility invoked by ECE concurrent processing. It is owned by APPS, has a VALID status, and, according to the ETRM dependency extract, references only SYS.STANDARD directly, while all table access is accomplished through APPS synonyms. It is referenced by no other packages, confirming it is a top-of-stack driver rather than a shared library.

Key Procedures and Functions

• NAME — A name-resolution utility within the package, typically used to return or resolve an object identifier string used by the surrounding transformation logic.
• PUT_DATA_TO_OUTPUT_TABLE — Writes the assembled supplier schedule payload into the ECE output staging table (ECE_OUTPUT), where it becomes available to the ECE output writer for final document generation.
• POPULATE_SUPPLIER_SCHED_API1 — Populates the supplier scheduling API structures for release/version 1 of the schedule interface, gathering header and item schedule data from the CHV tables.
• POPULATE_SUPPLIER_SCHED_API3 — The corresponding population routine for release/version 3, handling the later schedule format variant.
• UPDATE_CHV_SCHEDULE_HEADERS — Updates CHV schedule header records after processing, marking them as transmitted or otherwise advancing their processing status.

The documented procedure/function inventory lists six entries; the remaining internal (private) helper is not separately described in the extract and is not used externally. No public parameter lists are documented, and none are inferred here.

Tables Accessed

The package reads and/or writes the following tables via APPS synonyms:

• CHV_SCHEDULE_HEADERS, CHV_SCHEDULE_ITEMS — Source schedule header and line data produced by Oracle Supplier Scheduling.
• CHV_ITEM_ORDERS, CHV_CUM_PERIODS, CHV_AUTHORIZATIONS, CHV_ORG_OPTIONS — Item order, cumulative receipt period, authorization, and organization-level configuration data required to fully qualify the outbound schedule.
• ECE_SPSO_HEADERS_S, ECE_SPSO_ITEMS, ECE_SPSO_ITEMS_S, ECE_SPSO_ITEM_DET, ECE_SPSO_ITEM_DET_S — ECE staging tables for SPSO headers, items, and item detail, populated as the transformation progresses.
• ECE_TP_DETAILS — Trading partner detail, used to determine routing, mapping, and document attributes for the schedule output.
• ECE_OUTPUT, ECE_OUTPUT_RUNS_S — Final output and run-sequence tables consumed by the ECE output generator.
• MTL_PARAMETERS — Inventory organization parameters, used for organizational defaults and validation.

Usage Notes

ECE_SPSO_TRANS1 is invoked indirectly as part of the Oracle E-Commerce Gateway outbound processing for supplier schedules, typically triggered by the concurrent program that extracts supplier scheduling data and generates the outbound schedule document. It should not be called directly from forms or custom code; it is an internal driver with no documented public API contract. Because it references only SYS.STANDARD and is referenced by no other packages, changes to its signature or the layout of its staging tables carry localized risk but are still governed by standard APPS patch and upgrade procedures. In 12.1.1 and 12.2.2 the object remains VALID, and any debugging should focus on the CHV schedule tables and the ECE_OUTPUT/ECE_OUTPUT_RUNS_S tables it populates.