Results for “fff_function_id”

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

Overview

OKC_CLASSES_B is the foundational reference table in the Oracle Contracts Core (OKC) module that stores the highest level categorization of a contract. In Oracle E-Business Suite 12.1.1 and 12.2.2, every contract entered into the system — whether a sales agreement, purchase agreement, lease, or service contract — is classified under a contract class, and this classification drives core processing behavior including numbering, security, defaulting, and which operations are permitted on the contract. The table resides in the OKC schema and is flagged as VALID in the data dictionary.

From a Data Vault modeling perspective, the mined foreign key structure suggests OKC_CLASSES_B behaves as a hub-leaning entity: it holds a stable, non-volatile business key (CODE) referenced by multiple dependent tables, with descriptive and audit attributes attached directly to the row rather than separated into a satellite. This classification is a heuristic suggestion only and is not an Oracle-documented designation.

Key Information Stored

The table contains twelve documented columns in the 12.2.2 physical schema. The most significant are:

• CODE — the business identifier for the contract class and the single column making up the primary key (OKC_CLASSES_B_PK). Application logic and foreign keys reference classes through this value.
• ZD_EDITION_NAME — participates with CODE in the unique index OKC_CLASSES_B_U1, supporting the editioning model introduced in 12.2 for online patching. Together, CODE and ZD_EDITION_NAME constitute the business-key candidate, while CODE alone serves as the surrogate primary key in this schema.
• OBJECT_VERSION_NUMBER — supports optimistic locking during concurrent updates through the Oracle Applications framework.
• FFF_FUNCTION_ID and ADV_SEARCH_FORM_FUNCTION_ID — reference forms functions used for the folder-style (flexfield) form and the advanced search page associated with the class.
• SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS, enforcing multi-organization / security group access control over class definitions.
• APPLICATION_ID — identifies the owning application of the class record.
• Standard audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN — provide the who/when/trace information required by EBS audit conventions.

Common Use Cases and Queries

Typical usage centers on joining class definitions to the contracts, subclasses, operations, and numbering rules that depend on them. Reporting on which contract types exist, which operations are enabled, or how contracts are numbered all begin with this table. A representative query joining classes to their subclasses:

SELECT c.CODE, s.CODE subclass_code FROM okc.okc_classes_b c, okc.okc_subclasses_b s WHERE c.CODE = s.CLS_CODE;

To find numbering sequences configured per class:

SELECT c.CODE, l.SCS_CODE FROM okc.okc_classes_b c, okc.okc_k_seq_lines l WHERE c.CODE = l.SCS_CODE;

To review permitted operations per class:

SELECT c.CODE, o.CLS_CODE FROM okc.okc_classes_b c, okc.okc_class_operations o WHERE c.CODE = o.CLS_CODE;

In 12.2 environments, queries should be aware of editioning and may need to filter or join on ZD_EDITION_NAME to target the active edition.

Related Objects

The following objects depend directly on OKC_CLASSES_B through documented foreign keys:

• OKC_SUBCLASSES_B — references OKC_CLASSES_B.CODE via SUBCLASSES_B.CLS_CODE; provides the next level of contract categorization.
• OKC_CLASS_OPERATIONS — references OKC_CLASSES_B.CODE via CLS_CODE; defines which contract operations are valid for the class.
• OKC_K_SEQ_LINES — references OKC_CLASSES_B.CODE via SCS_CODE; holds numbering sequence assignments tied to the class.
• FND_SECURITY_GROUPS — referenced by OKC_CLASSES_B.SECURITY_GROUP_ID for access control.

These relationships confirm OKC_CLASSES_B as a central hub in the Contracts Core data model, driving subclass, operation, and numbering configuration across the module.