Search Results oke_form_dd250




Overview
Explore in AI Chat

Overview

OKE_FORM_DD250_EXT is a PL/SQL extension package in the APPS schema that supports the Oracle E-Business Suite Project Contracts (OKE) module, specifically the DD250 form printing process. DD250 refers to the U.S. Department of Defense Form 250 (Material Inspection and Receiving Report), a standard government form used to document receipt and acceptance of goods under defense contracts. Within Oracle EBS, the DD250 form is generated for shipments and contract deliverables subject to government acceptance requirements.

The package functions as a designated extension point for the core form driver, OKE_FORM_DD250. Its status is recorded as VALID, and it is classified as an OTHER API, meaning it is not a public transactional API but rather a client-side or server-side extension hook intended to be invoked by Oracle's delivered form logic. The "_EXT" suffix signals that the package exists explicitly to hold customer-specific overrides without modifying seeded code.

Key Procedures and Functions

Two documented procedures are exposed by OKE_FORM_DD250_EXT:

  • OVERRIDE_SHIPMENT_PREFIX — Allows the standard shipment prefix logic used on the DD250 output to be replaced or adjusted. Implementers use it to alter how a shipment identifier prefix is derived or displayed when the standard rule does not match business or agency-specific formatting requirements.
  • OVERRIDE_FORM_DATA — Provides a hook to modify the form data payload before the DD250 report is rendered. It enables substitution or augmentation of header or line data that the seeded OKE_FORM_DD250 process would otherwise emit unchanged.

Neither procedure is documented as a standalone callable API with published parameters in the ETRM metadata; both are invoked through the standard form workflow and are intended to be customized in place. References to the SYS.STANDARD package reflect normal PL/pgSQL-style language runtime dependencies.

Tables Accessed

The ETRM metadata documents no direct table references for OKE_FORM_DD250_EXT through APPS synonyms. This is consistent with an extension package whose data manipulation is expected to be added by the implementer during customization. The base package OKE_FORM_DD250 performs the substantive reads and writes against contracts and shipping tables; the extension package inherits that context and is expected to operate on the same in-memory data structures or to add queries as required by the specific override. Because no DML is delivered, the package is safe to leave unmodified when no DD250 customization is required.

Usage Notes

The package is referenced by OKE_FORM_DD250 and by itself, establishing a bidirectional dependency that confirms it is a nested extension unit of the DD250 form process rather than a top-level entry point. It is not referenced by any concurrent program or interface in the documented metadata.

In practice the package is invoked when a user launches the DD250 form or report from the Project Contracts responsibility or an associated shipping transaction. Typical use cases include defense contractors and government suppliers who must tailor the printed DD250 to agency-specific formats, distribution statements, or acceptance data. Customization should be performed in a development environment and migrated via standard EBS patch mechanisms, retaining a copy of the delivered package body. Because the procedures are non-public extension hooks, they should not be called directly from unrelated custom code; any additional logic belongs inside the packaged procedures so that the delivered form driver continues to control the invocation sequence.