Search Results ece_spso_items_s

Overview

ECE_SPSO_TRANS1 is a PL/SQL package body owned by the APPS schema within Oracle E-Business Suite. It is classified as a supplier scheduling and supply chain extract component under the ECE (E-Commerce Gateway / Extensible Common Exchange) module. Its principal business function is to transform supplier scheduling data held in the Oracle Supplier Scheduling tables (the CHV_* family) into the staging structures used by the ECE SPSO (Supplier Scheduling Outbound) processing pipeline, ultimately producing flat-file output that can be transmitted to trading partners and suppliers. The package operates in the outbound direction, reading authorized schedule data, supplier item and supplier detail information, and writing normalized records into the ECE_SPSO_* staging and output tables.

The dependency list confirms a tight relationship with the ECE data-transformation layer: helper packages ECE_SPSO_X, ECE_SPSO_TRANS2, ECE_FLATFILE_PVT, ECE_EXTRACT_UTILS_PUB, EC_MAPPING_UTILS, EC_CODE_CONVERSION_PVT, and ECE_ERROR_HANDLING_PVT are all referenced. The dependency on ECE_SPSO_ITEMS_S, the object the user searched for, indicates this package is the primary producer that populates supplier scheduling item staging records during the outbound extraction run.

Key Procedures and Functions

The ETRM 12.2.2 metadata documents six procedures/functions in this package body. Their names and purposes are as follows:

• NAME — Provides a named entry point within the package, typically used as an identifier/logging helper or a standard package naming routine that supports the remaining procedures.
• PUT_DATA_TO_OUTPUT_TABLE — Writes the assembled supplier scheduling staging rows into the ECE output table structure, finalizing the transformed records for flat-file generation.
• POPULATE_SUPPLIER_SCHED_API1 — Populates supplier schedule data through the API1 path, gathering scheduling header and item information from the CHV tables for the first processing variant.
• POPULATE_SUPPLIER_SCHED_API3 — Populates supplier schedule data through the API3 path, providing an alternative extraction variant used for differing schedule or trading-partner processing requirements.
• UPDATE_CHV_SCHEDULE_HEADERS — Updates schedule header records after extraction, marking them as processed or otherwise reflecting extraction status.

The documentation lists these five named entries against a stated total of six; the remaining member is undocumented and should not be assumed. No parameter lists are published in the metadata, so procedure signatures are not reproduced here.

Tables Accessed

The package reads from the Oracle Supplier Scheduling (CHV) source tables and writes to the ECE staging/output tables. Documented source tables include CHV_AUTHORIZATIONS, CHV_CUM_PERIODS, CHV_ITEM_ORDERS, CHV_ORG_OPTIONS, CHV_SCHEDULE_HEADERS, and CHV_SCHEDULE_ITEMS, which together carry supplier authorization, cumulative receipt, item order, organization option, and schedule header/item detail. Reference and validation data is drawn from MTL_PARAMETERS, MTL_SYSTEM_ITEMS, MTL_PLANNERS, MTL_ITEM_FLEXFIELDS, PO_VENDOR_SITES, PO_APPROVED_SUPPLIER_LIST, and PO_ASL_ATTRIBUTES, along with PER_ALL_PEOPLE_F for personnel information. Output and staging targets include ECE_OUTPUT, ECE_OUTPUT_RUNS_S, ECE_SPSO_HEADERS_S, ECE_SPSO_ITEMS, ECE_SPSO_ITEMS_S, ECE_SPSO_ITEM_DET, ECE_SPSO_ITEM_DET_S, and ECE_TP_DETAILS.

Usage Notes

ECE_SPSO_TRANS1 is invoked by the ECE Supplier Scheduling outbound concurrent program chain rather than by an Oracle Forms user interface directly. It is not referenced by any other database object, confirming that it acts as a top-level transformation driver within the outbound extraction flow. Custom implementations extending supplier scheduling extracts typically call or clone its procedures such as PUT_DATA_TO_OUTPUT_TABLE and POPULATE_SUPPLIER_SCHED_API1/API3. Because the package relies on FND_PROFILE and HR_SECURITY, output is subject to profile option settings and organizational security at runtime.