Search Results cs_tp_freetexts

Overview

CS_TP_FREETEXTS is a Service (CS) module table that supports the Template Driven Service Request answer framework in Oracle E-Business Suite 12.1.1 and 12.2.2. Its documented purpose is to store the freetext size attribute associated with template-driven SR answers of the freetext type. In effect, it acts as a configuration/sizing repository for free-text answer elements presented to agents on Service Request templates, allowing Oracle EBS to constrain or define the amount of text a given answer field accepts.

The table resides in the CS schema and is flagged VALID in the ETRM data dictionary. It is keyed by a single-column surrogate primary key, CS_TP_FREE_PK, which enforces uniqueness on FREETEXT_ID. A unique index, CS_TP_FREETEXTS_U1, also covers FREETEXT_ID, confirming it as the only viable business-key candidate. The heuristic Data Vault classification derived from the foreign-key structure is standalone, meaning the table has no dependent hub/link/satellite relationships through the mined FK graph and is best modeled as an independent reference or configuration table rather than a transactional hub. The only documented outbound foreign key is SECURITY_GROUP_ID referencing FND_SECURITY_GROUPS.

Key Information Stored

The documented physical schema contains 25 columns. The most significant are:

• FREETEXT_ID — surrogate primary key and unique business-key candidate; identifies each freetext configuration record.
• LOOKUP_ID — links the freetext definition to its associated lookup context used by the template answer mechanism.
• FREETEXT_SIZE — the principal payload column; stores the size constraint applied to the freetext answer field.
• SECURITY_GROUP_ID — the only documented foreign key, referencing FND_SECURITY_GROUPS; enforces multi-tenant/security-group isolation in a shared environment.
• CREATION_DATE, CREATED_BY — standard audit columns recording initial insert metadata.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard audit columns capturing the most recent modification and session context.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — the standard EBS DFF (descriptive flexfield) column set, providing extensibility for customer-specific attributes.

No additional descriptive/label columns are documented beyond these; the table is intentionally narrow in business meaning and serves primarily as a sizing/configuration lookup.

Common Use Cases and Queries

Typical use cases include verifying that a template-driven SR answer field has the expected size limit, auditing freetext configuration by security group, and reporting on setup completeness.

-- Retrieve freetext size definitions with security group
SELECT f.FREETEXT_ID,
       f.LOOKUP_ID,
       f.FREETEXT_SIZE,
       g.SECURITY_GROUP_NAME
FROM   CS.CS_TP_FREETEXTS f,
       FND_SECURITY_GROUPS g
WHERE  f.SECURITY_GROUP_ID = g.SECURITY_GROUP_ID(+);

-- Locate a size definition by its business key
SELECT FREETEXT_ID, LOOKUP_ID, FREETEXT_SIZE
FROM   CS.CS_TP_FREETEXTS
WHERE  FREETEXT_ID = :p_freetext_id;

Reporting scenarios include validating that no freetext record exceeds expected length thresholds, reconciling configuration across environments (DEV vs. PROD), and extracting audit trails for setup changes using LAST_UPDATE_DATE.

Related Objects

• FND_SECURITY_GROUPS — referenced via SECURITY_GROUP_ID; the sole documented FK.
• CS_TP_* template tables — sibling Template Driven SR answer configuration tables (e.g., answer-type and template definition tables) that share the LOOKUP_ID / FREETEXT_ID design pattern.
• CS_SR_* / Service Request answer tables — operational SR answer storage that consumes freetext sizing at runtime.
• FND_LOOKUPS — related through LOOKUP_ID, resolving answer-type or freetext-category codes.
• CS_INCIDENTS_ALL — the Service Request base entity whose template answers ultimately reference these configurations.

Because the table is classified standalone, no dependent FK children are documented; join modeling should therefore treat it as a leaf reference table keyed by FREETEXT_ID.