Search Results oke_deliverable_shipping_v




Overview
Explore in AI Chat

Overview

OKE_ACTION_VALIDATIONS_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified as an OTHER-type API within the ETRM repository. It belongs to the Oracle Knowledge Exchange (OKE) product family, historically associated with the Project Contracts and project deliverable functionality. The package consolidates server-side validation logic used when project-related deliverables, actions, and downstream supply-chain documents are created or modified. In the context of Oracle EBS 12.1.1 and 12.2.2, the package provides reusable validation routines that enforce referential and business-rule correctness across several modules, most notably Order Management (MDS/fulfillment), Shipping (WSH), and Purchasing (requisitions).

Its central role is to validate the attributes supplied for a deliverable action before that action is committed, and to return a status or error string to the calling program. Supporting utility functions handle currency conversion, functional-currency lookup, and location-description retrieval. This design keeps validation logic centralized and callable from multiple entry points, rather than duplicating checks in each form or interface.

Key Procedures and Functions

The package exposes seven documented program units. Their parameters are not enumerated here; only their documented names and purposes are described.

  • Validate_MDS — Validates a deliverable action against the MDS (shipping/delivery) context, checking ship-from and ship-to organization and location, schedule designator, expected date, quantity, and unit of measure, and returns a validation result.
  • Validate_WSH — Performs the analogous validation for the WSH (Shipping) integration path, additionally considering volume, volume UOM, weight, and weight UOM along with the standard shipping attributes.
  • Validate_Req — Validates a deliverable action intended to generate or relate to a purchasing requisition, covering destination type, requisition line type, category, currency, quantity, UOM, unit price, rate type, rate date, exchange rate, expenditure type, expenditure organization, and expenditure item date.
  • Exchange_Rate — Returns the exchange rate between an originating and a target currency for a given rate type and effective date, used to support price and requisition validation.
  • Functional_Currency — Returns the functional currency associated with a given operating unit organization, typically derived from organization parameters.
  • Get_Location_Description — Returns the descriptive text for a location identified by its primary key, joining the appropriate location tables to produce a human-readable description.
  • Add_Msg — A utility procedure that registers or appends a message keyed to a specific action ID, providing the mechanism by which validation routines surface errors back to the caller.

Tables Accessed

The package reads and writes the following documented tables through APPS synonyms:

The tables are referenced rather than owned, confirming the package acts as a validation layer over other products' data.

Usage Notes

OKE_ACTION_VALIDATIONS_PKG is invoked from three documented dependent packages, indicating it is called programmatically rather than directly by end users. Typical invocation points include Oracle Forms events on deliverable and action windows, concurrent programs that process project deliverables and create downstream supply-chain documents, and custom extensions that interface with OKE. The validation functions return a VARCHAR2 result, so callers should check the return value and consult messages added via Add_Msg. Because the package references tables in HR, HZ, PA, PJM, and OKE, implementations must ensure the APPS schema has the appropriate synonyms and privileges, and that setup data for currencies, organizations, and locations is complete before actions are validated. In 12.1.1 and 12.2.2 the package behaves consistently, with 12.2.x online-patching considerations applying to any customization built on top of it.