Search Results okc_folders_all_b




Overview
Explore in AI Chat

Overview

The OKC_FOLDERS_ALL_B table is a core data object within the Oracle E-Business Suite Contracts Core (OKC) module. It serves as the primary repository for storing folder definitions at an organizational level. These folders are structural containers used to organize and manage contract articles, clauses, and other related content within the application. Historically, prior to release 11.5.10, this functionality was managed through the FND_LOOKUP_VALUES table, where folders were known as "Article Sets." The migration to a dedicated table underscores its importance in the content management architecture of Oracle Contracts, providing a more robust and scalable framework for classifying and grouping contractual boilerplate text.

Key Information Stored

While the provided ETRM metadata does not list specific columns, based on its function and standard Oracle EBS design patterns, the table typically stores attributes essential for defining and identifying a folder. Key columns would include a unique identifier (likely FOLDER_ID), the folder's name or code (FOLDER_NAME), a description, and an identifier for the owning organization (ORG_ID), as indicated by the "_ALL_B" suffix which denotes multi-organization support. It would also contain standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE) for auditing, and a column to track the active status (e.g., ACTIVE_FLAG or ENABLED_FLAG) of the folder record.

Common Use Cases and Queries

The primary use case is the administrative setup and maintenance of folders used to categorize contract templates and standard clauses. This enables users to efficiently browse and select pre-approved content during contract authoring. Common reporting needs involve listing all active folders for a given operating unit or validating folder usage. A typical query pattern would be:

  • Retrieving active folders for a specific organization: SELECT folder_name, description FROM okc_folders_all_b WHERE org_id = :org_id AND enabled_flag = 'Y' ORDER BY folder_name;
  • Identifying folders that may be referenced by contract articles or templates, often requiring a join to related content tables like OKC_ARTICLE_VERSIONS_B.

Related Objects

The table is central to the Contracts Core data model. It maintains a direct relationship with objects that store the actual content classified within these folders. Key related objects include:

  • OKC_ARTICLE_VERSIONS_B: This table stores the versions of contract articles and clauses. It would typically contain a foreign key column (e.g., FOLDER_ID) referencing OKC_FOLDERS_ALL_B.FOLDER_ID, linking each article to its organizational folder.
  • OKC_TEMPLATES_B / OKC_TEMPLATE_VERSIONS_B: Contract templates and their versions likely reference folders to organize template libraries, using a similar foreign key relationship.
  • FND_LOOKUP_VALUES (Historical): As noted in the documentation, this was the predecessor storage location for folder data ("Article Sets") prior to 11.5.10.