Search Results okc_folder_contents




Overview
Explore in AI Chat

Overview

The OKC_FOLDER_CONTENTS table is a core data structure within the Oracle E-Business Suite Contracts Core (OKC) module. It functions as the primary repository for managing the association between contract clause folders and the individual clauses (articles) they contain. This table was introduced to replace the legacy OKC_STD_ART_SET_MEMS table in release 11.5.10, representing a more normalized and scalable design for organizing standard clauses. Its primary role is to support the clause library functionality, enabling users to group related clauses into folders for efficient authoring, management, and reuse during the contract creation process.

Key Information Stored

The table's structure is centered on the relationship between a folder and its members. The primary key is a composite of two columns, ensuring a unique relationship for each clause within a folder. The most critical columns are:

  • FOLDER_ID: A foreign key referencing OKC_FOLDERS_ALL_B.FOLDER_ID. This identifies the specific clause folder.
  • MEMBER_ID: A foreign key referencing OKC_ARTICLES_ALL.ID. This identifies the specific clause (article) that is a member of the folder. This is the column directly relevant to the user's search term.

Together, these two columns define the fundamental membership record. The table does not typically store extensive descriptive data, as that information resides in the parent tables for folders and articles.

Common Use Cases and Queries

A primary use case is generating a list of all clauses contained within a specific folder for review or reporting. Another is identifying all folders that contain a particular standard clause. Sample queries include:

  • Listing all clauses in a folder: 
    SELECT a.ARTICLE_NUMBER, a.TITLE
FROM OKC_FOLDER_CONTENTS fc,
     OKC_ARTICLES_ALL a
WHERE fc.FOLDER_ID = :p_folder_id
  AND fc.MEMBER_ID = a.ID
ORDER BY a.ARTICLE_NUMBER;
  • Finding folders containing a specific clause (using MEMBER_ID): 
    SELECT f.FOLDER_NAME
FROM OKC_FOLDER_CONTENTS fc,
     OKC_FOLDERS_ALL_B f
WHERE fc.MEMBER_ID = :p_member_id
  AND fc.FOLDER_ID = f.FOLDER_ID;

These queries are foundational for building clause library user interfaces, validating folder contents, and supporting migration scripts when updating clause libraries.

Related Objects

OKC_FOLDER_CONTENTS is centrally linked to two key master tables via foreign key constraints:

  • OKC_FOLDERS_ALL_B: The parent table for all clause folders, referenced by FOLDER_ID.
  • OKC_ARTICLES_ALL: The master table for all contract articles (clauses), referenced by MEMBER_ID.

As the successor to OKC_STD_ART_SET_MEMS, it may share functional similarities with that deprecated table. Applications and interfaces that manage the clause library, such as the "Clauses" and "Folders" forms in the Contracts Core module, will perform INSERT, UPDATE, and DELETE operations on this table to maintain folder memberships.