Search Results validate_cdi




Overview
Explore in AI Chat

Overview

CTXSYS.DRICON is an Oracle Text (interMedia) internal PL/SQL package that belongs to the CTXSYS schema, the schema that owns the Oracle Text server-side infrastructure. Within Oracle E-Business Suite 12.1.1 and 12.2.2 the package is documented under the ETRM with an API classification of OTHER, meaning it is not an EBS-owned application programming interface and is not intended for direct customer invocation. Its role is to resolve and validate the metadata that Oracle Text indexes require: selecting the correct datatype and datastore preference objects for an index, inspecting column datatypes, and validating that the tables, columns, and metadata columns referenced by a text index are structurally sound. The prefix "DRI" denotes the Oracle Text "Document Runtime Interface" family of packages used during index creation, preference resolution, and index maintenance. Because EBS modules such as iProcurement, Knowledge Management, CRM, and the Oracle iStore catalog rely on Oracle Text indexes, DRICON indirectly underpins search and retrieval functionality across those applications, even though it is never called by an end user.

Key Procedures and Functions

  • SET_DATATYPE_OBJ — Calculates and returns the datatype preference and datatype identifier that should be used for a given Oracle Text type, allowing the index machinery to select an appropriate datatype object.
  • SET_STORE_OBJ — Determines the datastore objects required for an index, returning the store interface and store type names to use, based on the datastore preference, text type, index owner, and key column.
  • GET_DATA_TYPE — Returns, as a word, the datatype of a specified table column, together with the Oracle type identifier, length, and scale; all name arguments must be supplied in upper case.
  • GET_TYPE_DATA_TYPE — Returns the datatype and data length of a column within a user-defined type (object type) table, using the type name with owner prefix and the column name without owner prefix.
  • VALIDATE_TAB — Validates that a candidate table is a legal target for a text index.
  • EXIST_TAB — Determines whether a referenced table exists.
  • VALIDATE_TEXT_COLUMN — Validates a candidate text column for indexing eligibility.
  • VALIDATE_META_COLUMN — Validates a metadata (filter/attribute) column used alongside the indexed text column.
  • GET_PRIMARY_KEY — Retrieves the primary key definition of the table being indexed, which Oracle Text requires to join index rows back to base table rows.
  • VALIDATE_CDI — Validates the catalog/document identifier configuration used for the index.

Tables Accessed

The package reads the Oracle data dictionary and related metadata views, reached in EBS through APPS-owned synonyms: DBA_TYPES and DBA_TYPE_ATTRS (for resolving object type columns), DBA_COLL_TYPES (for collection type definitions), DBA_CONSTRAINTS and DBA_CONS_COLUMNS (for primary key and constraint discovery), DBA_OBJECTS (for object existence and validity checks), DUAL (for single-row expressions), and PLITBLM, the Oracle Text internal table used for preference and metadata storage. The package is referenced by seven other packages, confirming its position as a low-level utility invoked by higher-level Oracle Text routines rather than as an entry point itself.

Usage Notes

DRICON is an internal Oracle Text package and should not be called directly from EBS forms, concurrent programs, or custom code. It is invoked implicitly during Oracle Text index creation, rebuild, synchronization, and optimization, and during preference validation performed by CTX_DDL operations. Because it executes as CTXSYS and queries DBA-level dictionary views, direct invocation from an APPS session would ordinarily fail on privileges unless explicitly granted, which Oracle does not support. Administrators encountering the package name in EBS diagnostics should treat it as evidence of Oracle Text index activity rather than as a defect source. The user query "Cyera configure IP" is unrelated to this object; Cyera is a data-security posture tool, and IP configuration is not a function of CTXSYS.DRICON.