Results for “firm_entity”

8 results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

WSH_TP_RELEASE is the Transportation Planning release-management package body owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It encapsulates the business logic behind Transportation Planning Actions — the release, firming, un-firming, and date-calculation operations that users perform against deliveries, delivery batches, trips, and order lines during transportation planning. The package implements the semantics of the Ignore for Planning and Include for Planning flags, cascading those flags across the trip–delivery–line hierarchy so the planning engine sees a consistent set of entities. It also derives transportation planning dates (such as earliest pick-up and latest drop-off) from calendar and transit-time profiles, and centralizes exception logging for date calculations. In the broader shipping (WSH) flow, it acts as the server-side gatekeeper that validates whether a planning action may be performed from a given entity level before delegating the update.

Key Procedures and Functions

  • CHANGE_IGNOREPLAN_STATUS — Sets or clears the Ignore-for-Planning flag on the entity from which the action is invoked. Validation enforces that Ignore/Include actions are performed only from the topmost entity: a line attached to a delivery, and a delivery attached to a trip, must be acted on at the higher level. When invoked from a trip, the flag cascades to all associated deliveries and lines; conflicting flags on other trips sharing a delivery raise an error, and multiple trips on one delivery must be selected together. Transportation Planning Workbench (TPW), carrier-manifest lines, and deliveries are always marked ignore-for-plan.
  • FIRM_ENTITY — Applies the firming action to the selected transportation entity, locking its planning results so subsequent planning runs do not reschedule or reassign it.
  • UNFIRM_ENTITY — Reverses firming, returning the entity to the planning pool so it becomes eligible for re-planning.
  • CALCULATE_TP_DATES — Computes transportation planning dates for an entity using calendar, routing, and transit-time profiles (including the routing-firm and lead-time day profiles referenced in the package header).
  • CALCULATE_CONT_DEL_TPDATES — Performs the same date derivation for a container delivery, applying container-level assumptions.
  • LOG_TPDATE_EXCEPTION — Captures and records exceptions raised during transportation date calculation for diagnostic and support purposes.
  • CHECK_SHIPSET_IGNOREFLAG — Evaluates the ignore-for-planning flag across an entire ship set, supporting the rule that all members of a ship set must be treated consistently.

Tables Accessed

  • WSH_NEW_DELIVERIES, WSH_DELIVERY_DETAILS, WSH_DELIVERY_LEGS — read and updated to firm/unfirm deliveries, cascade ignore-for-plan flags, and support date calculation.
  • WSH_TRIPS, WSH_TRIP_STOPS — the trip header and stop records whose planning status governs the deliveries attached to them.
  • OE_ORDER_LINES_ALL — the order lines underlying delivery details, cascaded when the action is performed from a higher entity.
  • MTL_SYSTEM_ITEMS — item attributes influencing planning and transit assumptions.
  • PLITBLM — the PL/SQL table used for bulk id handling and messaging within the package.

Usage Notes

WSH_TP_RELEASE is invoked indirectly through the Transportation Planning Workbench and shipping forms, and through the group API that Oracle introduced to enforce consistent validation for TRIP entities. Note that the source header explicitly warns that no new internal calls to the older direct APIs should be added, and new integrations must route through the group API instead. Because the package is referenced by approximately twenty other packages, it is a foundational dependency in the WSH transportation-planning stack; customizations should call the documented public procedures only and avoid direct DML on WSH_TRIPS or WSH_NEW_DELIVERIES to preserve cascading and ship-set consistency.