Results for “internal_flag”

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

Overview

OKC_DELIVERABLE_TYPES_B is a foundational setup table within the Oracle Contracts Core (OKC) module of Oracle E-Business Suite. It functions as the lookup table for all deliverable types that may be defined and tracked against a contract. Deliverables represent the tangible or administrative outputs a contract party is obligated to provide — for example, a signed document, a payment, a shipment, or a report. Because deliverable types are reused across many contracts and different business document combinations, this table serves as a reference master rather than a transaction table.

Applying a Data Vault modeling heuristic, the object is classified as hub-leaning. It carries a stable business key (DELIVERABLE_TYPE_CODE), a single-column surrogate primary key, and descriptive attributes with no dependent child history in its own structure, which aligns well with the role of a hub that other tables reference. This classification is a modeling suggestion; the operational reality is that OKC_DELIVERABLE_TYPES_B remains a standard Oracle EBS lookup table whose rows are seeded and maintained by administrators.

Key Information Stored

The table contains nine documented columns. The most significant are:

• DELIVERABLE_TYPE_CODE — The business key. A short, user-assigned code uniquely identifying each deliverable type. It is the column most frequently used in joins, queries, and API parameters.
• INTERNAL_FLAG — Distinguishes deliverable types defined internally by the implementing organization from those delivered as seed data or intended for internal-only use.
• CREATED_BY, CREATION_DATE — Standard WHO audit columns capturing the user and timestamp of row creation.
• LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Audit columns recording the most recent modification and the login/session that performed it.
• OBJECT_VERSION_NUMBER — Optimistic locking column used by the Oracle Applications Framework (OAF) to detect concurrent updates.
• ZD_EDITION_NAME — Editioning column supporting Oracle EBS 12.2 online patching; it separates the runtime edition of the row from other editions during the patching cycle.

The surrogate primary key is OKC_DELIVERABLE_TYPE_PK, implemented on DELIVERABLE_TYPE_CODE. A unique index, OKC_DELIVERABLE_TYPES_B_U1, enforces uniqueness across DELIVERABLE_TYPE_CODE and ZD_EDITION_NAME, which functions as the business-key candidate within the editioning model.

Common Use Cases and Queries

Typical reporting and setup validation scenarios include listing all active deliverable types, verifying which are internal, and confirming the combinations permitted against a given business document type.

• Enumerating available deliverable types: SELECT deliverable_type_code, internal_flag FROM okc_deliverable_types_b ORDER BY deliverable_type_code;
• Joining to the combination table to identify valid pairings: SELECT c.deliverable_type, c.business_doc_type_code FROM okc_del_bus_doc_combxns c, okc_deliverable_types_b t WHERE c.deliverable_type = t.deliverable_type_code;
• Auditing recent configuration changes using LAST_UPDATED_BY and LAST_UPDATE_DATE to support change-control review.
• Feeding contract deliverable reports and LOV (List of Values) sources in OAF pages or concurrent programs.

Related Objects

The principal dependent object is OKC_DEL_BUS_DOC_COMBXNS, whose DELIVERABLE_TYPE column references DELIVERABLE_TYPE_CODE in this table. This combination table defines which deliverable types are valid for which business document types. Other significant related objects include the contract deliverables entity tables (such as OKC_K_ITEMS and OKC_DELIVERABLES) that consume these types when instances are created, the OKC Contracts APIs (for example OKC_CONTRACT_PUB and OKC_DELIVERABLE_PUB) that validate values against this lookup, and standard EBS lookup views that surface the codes for user-interface selection. Together these objects form the configuration backbone for contract deliverable tracking.