Results for “rule_information15_dsc”
14 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
OKC_RULES1_BLK_V is a read-only database view owned by the APPS schema in Oracle E-Business Suite, and is shipped as a valid object within the OKC (Contracts Core) product. Its purpose is to present the business rules stored against contract documents in a fully descriptive, human-readable form. Whereas the underlying contract rules tables store rule attributes as coded identifiers, this view resolves those identifiers into displayed values and descriptions at query time, so that reporting tools, forms, and integrations can consume meaningful text without invoking the Contracts Core public APIs themselves.
The view is particularly relevant to the Contracts Core descriptive flexfield mechanism. The RULE_INFORMATION attributes are flexfield segments, and the view exposes each segment value alongside its translated value and description. This makes OKC_RULES1_BLK_V a convenient source for extracting rule definitions in reporting and integration scenarios where the caller cannot or does not wish to call the flexfield resolution APIs directly.
Underlying Base Objects
Per the documented ETRM metadata for release 12.2.2, the view references two objects:
OKC_RULES_V(VIEW) — the primary contract rules view, supplying the rule rows, identifiers, object references, and rawRULE_INFORMATIONcolumn values that this view projects and enriches. It is aliasedRLEin the view definition.OKC_RULE_PUB(PACKAGE) — the Contracts Core public package supplying the helper functions used to derive the resolved values and descriptions:GET_OBJECT_VAL,GET_OBJECT_DSC,GET_FLEX_VAL, andGET_FLEX_DSC.
The view therefore sits one layer above OKC_RULES_V, adding no new persisted data; every derived column is computed through the package, generally at row-fetch time.
Key Columns
The view exposes identifying columns, three object-reference triplets, and the flexfield-based rule information attributes. Important columns include:
ID,DNZ_CHR_ID,RGP_ID,OBJECT_VERSION_NUMBER— the rule's primary identifier, its owning contract/document identifier, rule group identifier, and the optimistic locking version.RULE_INFORMATION_CATEGORY— the descriptive flexfield context used to resolve theRULE_INFORMATION*segments.JTOT_OBJECT1_CODE/OBJECT1_ID1/OBJECT1_ID2, with corresponding columns for OBJECT2 and OBJECT3 — coded object references. For each, the view addsJTOT_OBJECTn_VALandJTOT_OBJECTn_DSC, resolved viaGET_OBJECT_VALandGET_OBJECT_DSCand truncated to 240 bytes.RULE_INFORMATION1throughRULE_INFORMATIONn— the raw flexfield segment values, each accompanied by a_VAL(translated value) and_DSC(description) column resolved throughGET_FLEX_VALandGET_FLEX_DSC. This is the structure that answers a search such as "rule_information15": the segmentRULE_INFORMATION15is exposed asRULE_INFORMATION15,RULE_INFORMATION15_VAL, andRULE_INFORMATION15_DSC.
Common Use Cases and Queries
The view is typically used to report rule configurations on contracts, to reconcile coded object references against their descriptions, and to extract flexfield rule attributes for downstream systems. A representative query filtering on a specific rule information segment is:
SELECT id, dnz_chr_id, rule_information_category, rule_information15, rule_information15_val, rule_information15_dsc FROM okc_rules1_blk_v WHERE rule_information15_val IS NOT NULL;SELECT id, dnz_chr_id, jtot_object1_val, jtot_object1_dsc FROM okc_rules1_blk_v WHERE dnz_chr_id = :contract_id;
Because value resolution occurs through OKC_RULE_PUB, queries returning large row sets can be costly; filtering by DNZ_CHR_ID or RULE_INFORMATION_CATEGORY is advisable. The view should be treated strictly as a reporting and integration source, not as a target for DML.
-
View: OKC_RULES1_BLK_V 12.1.1
APPS.OKC_RULES1_BLK_V·↳ OKC_RULES_V·↳ OKC_RULE_PUB·Explore OKC module →
-
View: OKC_RULES1_BLK_HV 12.1.1
APPS.OKC_RULES1_BLK_HV·↳ OKC_RULES_HV·↳ OKC_RULE_PUB·Explore OKC module →
-
View: OKC_RULES1_BLK_HV 12.2.2
APPS.OKC_RULES1_BLK_HV·↳ OKC_RULES_HV·↳ OKC_RULE_PUB·Explore OKC module →
-
View: OKC_RULES1_BLK_V 12.2.2
APPS.OKC_RULES1_BLK_V·↳ OKC_RULES_V·↳ OKC_RULE_PUB·Explore OKC module →
-
VIEW: APPS.OKC_RULES1_BLK_HV 12.2.2
-
VIEW: APPS.OKC_RULES1_BLK_HV 12.1.1
-
VIEW: APPS.OKC_RULES1_BLK_V 12.2.2
-
VIEW: APPS.OKC_RULES1_BLK_V 12.1.1
-
VIEW: APPS.OKC_RULES1_BLK_HV 12.1.1
-
VIEW: APPS.OKC_RULES1_BLK_V 12.2.2
-
VIEW: APPS.OKC_RULES1_BLK_V 12.1.1
-
VIEW: APPS.OKC_RULES1_BLK_HV 12.2.2
-
eTRM - OKC Tables and Views 12.1.1
Intersection entity between templates and rules.
-
eTRM - OKC Tables and Views 12.2.2
Intersection entity between rules and templates