Search Results ece_spso_items




Overview
Explore in AI Chat

Overview

ECE_SPSO_ITEMS is an Oracle e-Commerce Gateway (EC) staging table owned by the EC schema. It holds supplier schedule line data used to generate the outbound Planning Schedule (830/DELFOR) and Shipping Schedule (862/DELJIT) transactions. During an outbound schedule run, the extraction program populates this table from the source scheduling and sourcing tables; the e-Commerce Gateway transmission program then reads the staged rows, maps them to the appropriate X12 or EDIFACT document, and creates the outbound interface records. The table is therefore an intermediate aggregation point rather than a transactional master: rows are transient, tied to a specific run and schedule, and generally purged or regenerated on each execution.

The primary key is ECE_SPSO_ITEMS_PK, defined across three columns: SCHEDULE_ITEM_ID, SCHEDULE_ID, and RUN_ID. A unique index, ECE_SPSO_ITEMS_U1, is defined on the same three columns, so the surrogate key and the business-key candidate coincide in this case. Mined foreign-key structure suggests a standalone Data Vault classification; in practice, however, the table behaves as a satellite-like staging object anchored to the schedule header via SCHEDULE_ID and to the run via RUN_ID. In the 12.2.2 documented physical schema the table carries 145 columns.

Key Information Stored

The most significant columns, grouped by purpose:

Common Use Cases and Queries

Typical usage centers on diagnosing a schedule transmission and reproducing its content. A frequently used pattern lists all lines for a given run:

SELECT schedulE_item_id, item_number, starting_auth_quantity,
       starting_cum_quantity, last_receipt_quantity
FROM   ec.ece_spso_items
WHERE  run_id = :run_id
AND    schedule_id = :schedule_id
ORDER BY schedule_item_id;

Reconciliation queries join back to the schedule header through SCHEDULE_ID and to the concurrent request through REQUEST_ID or RUN_ID to confirm which lines were picked up by a specific 830/862 execution. Analysts also aggregate volume by ship-to organization, by supplier agreement, or by purchasing UOM for audit and dispute resolution, and inspect the attribute flexfields to verify that descriptive segments were populated before transmission.

Related Objects

The following objects are the most relevant to working with ECE_SPSO_ITEMS:

  • ECE_SPSO_HEADERS — the schedule header table, joined on SCHEDULE_ID; supplies header-level schedule data for the outbound document.
  • ECE_SPSO_ITEM_DETAILS — detail-level schedule buckets, joined on SCHEDULE_ID and SCHEDULE_ITEM_ID.
  • ECE_OUTBOUND_LOG / ECE_TRANSACTIONS — records the outbound transmission and its status, joined through TRANSACTION_RECORD_ID.
  • FND_CONCURRENT_REQUESTS — the concurrent request that populated the run, joined on REQUEST_ID.
  • PO_SOURCING_RULES / sourcing source views — the upstream scheduling data from which the staging rows are derived, ultimately tied to the supplier agreement columns in this table.
  • EC_GRP / e-Commerce Gateway mapping programs — the concurrent programs and grouping logic that read this table to construct the outbound 830 and 862 interface records.