Search Results chv_horizontal_schedules




Overview
Explore in AI Chat

Overview

CHV_HORIZONTAL_SCHEDULES is a table owned by the PO schema within the CHV (Supplier Scheduling) product of Oracle E-Business Suite, released under Oracle Proprietary, Confidential Information terms. Its documented description is "Horizontal schedule table." It holds the transactional and transient output of Oracle Supplier Scheduling's horizontal schedule generation process, which produces a wide-format, row-in-time representation of supplier releases consumed by Supplier Scheduling Workbench, AutoSchedule, and Supplier Portal users.

The table appears in Oracle EBS release levels including 12.1.1 and 12.2.2 with identical structure. It is a standalone object rather than a traditional multi-table master–detail hierarchy. From a Data Vault modeling perspective, the heuristic classification is standalone, meaning the object is not a hub, link, or satellite in the classic Kimball sense; it functions as a wide, denormalized staging structure rather than as a normalized transaction store.

Key Information Stored

The documented physical schema has 73 columns. The most significant are:

  • SCHEDULE_ID — identifies a given horizontal schedule run or schedule header context.
  • SCHEDULE_ITEM_ID — documented as a foreign key to CHV_PURGE_SCHEDULE_LIST, allowing purge processes to associate a schedule item with the list of records eligible for removal.
  • ROW_SELECT_ORDER — sequencing value controlling the order rows are presented or selected in a horizontal schedule.
  • ROW_TYPE — categorizes the nature of a row (for example, header, detail, or total), which downstream consumers rely on to interpret the record correctly.
  • COLUMN1 through COLUMN60 — sixty generic, position-based columns forming the "horizontal" axis. Each column represents one bucket, in sequence, along the schedule horizon. The absence of semantic names reflects that the table is deliberately domain-neutral, with the application populating the buckets based on schedule definition rather than a fixed schema.
  • Standard Oracle who-columns: LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN.
  • Concurrent-program context columns: REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE.

The documented primary-key surrogate is SCHEDULE_ID. SCHEDULE_ITEM_ID serves as a business-key candidate and as the sole documented foreign key from this table to CHV_PURGE_SCHEDULE_LIST.

Common Use Cases and Queries

Typical use is to retrieve a horizontal schedule for reporting, to inspect bucket values by row type, and to identify records associated with a concurrent request for troubleshooting. A representative query pattern follows:

SELECT SCHEDULE_ID, SCHEDULE_ITEM_ID, ROW_SELECT_ORDER, ROW_TYPE, COLUMN1, COLUMN2, COLUMN3
FROM PO.CHV_HORIZONTAL_SCHEDULES
WHERE SCHEDULE_ID = :p_schedule_id
ORDER BY ROW_SELECT_ORDER;

A second pattern correlates purge activity:

SELECT h.SCHEDULE_ITEM_ID, p.*
FROM PO.CHV_HORIZONTAL_SCHEDULES h, PO.CHV_PURGE_SCHEDULE_LIST p
WHERE h.SCHEDULE_ITEM_ID = p.SCHEDULE_ITEM_ID;

Because the sixty bucket columns are un-named semantically, reporting queries generally pivot COLUMN1..COLUMN60 against ROW_TYPE and ROW_SELECT_ORDER, or delegate rendering to the Supplier Scheduling Workbench rather than extracting bucket values directly.

Related Objects

  • CHV_PURGE_SCHEDULE_LIST — referenced by CHV_HORIZONTAL_SCHEDULES.SCHEDULE_ITEM_ID; drives purge of schedule items.
  • CHV_SCHEDULE_ITEMS — parent schedule item definition that supplies SCHEDULE_ITEM_ID context.
  • CHV_SCHEDULE_HEADERS — schedule header that groups items appearing on horizontal output.
  • PO_RELEASES / PO_RELEASE_SCHEDULES — source release and delivery schedule data that the horizontal schedule represents.
  • PO_HEADERS_ALL / PO_LINES_ALL — blanket purchase agreement and line context referenced by schedule items.
  • FND_CONCURRENT_REQUESTS — joinable on REQUEST_ID to tie a schedule row to its generating concurrent program run.
  • Supplier Scheduling Workbench (CHV module UI) — primary consumer that reads and renders rows from this table.