Search Results doc_category_usage_id




Overview
Explore in AI Chat

Overview

The FND_DOC_CATEGORY_USAGES table is a core data object within the Application Object Library (FND) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It serves as a mapping or junction table that defines the permissible relationships between document categories and specific user interface components. Its primary role is to govern the attachment functionality within the EBS framework, controlling which predefined document categories are available for users to select when attaching files to a particular form or form function. This table is essential for enforcing business rules around document management and ensuring that attachments are correctly categorized based on their context within the application.

Key Information Stored

The table stores the unique associations that link a document category to an attachment point. The critical columns are the foreign keys that establish these relationships. The CATEGORY_ID column references a specific document category defined in the FND_DOCUMENT_CATEGORIES table, such as "Invoice," "Contract," or "Specification." The ATTACHMENT_FUNCTION_ID column references an entry in the FND_ATTACHMENT_FUNCTIONS table, which represents a specific form or function within EBS where attachments are enabled. The combination of these two columns is enforced as a unique key (FND_DOC_CATEGORY_USAGES_UK2), preventing duplicate mappings. Each record is also uniquely identified by a system-generated DOC_CATEGORY_USAGE_ID, which serves as the primary key.

Common Use Cases and Queries

A primary use case is auditing and troubleshooting the setup of attachment categories. Administrators often need to verify which categories are enabled for a specific form. A common query involves joining to the related tables to get descriptive names:

  • List all document categories available for a specific form function:
    SELECT faf.USER_FUNCTION_NAME, fdc.CATEGORY_NAME
    FROM APPLSYS.FND_DOC_CATEGORY_USAGES fdcu,
    APPLSYS.FND_ATTACHMENT_FUNCTIONS faf,
    APPLSYS.FND_DOCUMENT_CATEGORIES fdc
    WHERE fdcu.ATTACHMENT_FUNCTION_ID = faf.ATTACHMENT_FUNCTION_ID
    AND fdcu.CATEGORY_ID = fdc.CATEGORY_ID
    AND faf.USER_FUNCTION_NAME = 'PO_FORM';
  • Identify all forms where a specific document category is used: This reverse lookup is useful before modifying or obsoleting a category to understand its impact.
  • Data Fix Scripts: Technical consultants may write INSERT or DELETE statements against this table to correct configuration errors or implement new attachment rules as part of a customization or patch.

Related Objects

FND_DOC_CATEGORY_USAGES is centrally positioned between two key master tables in the EBS document attachment architecture, as defined by its foreign key constraints:

  • FND_DOCUMENT_CATEGORIES: This table is referenced via the CATEGORY_ID column. It holds the master list of all defined document categories available in the system.
  • FND_ATTACHMENT_FUNCTIONS: This table is referenced via the ATTACHMENT_FUNCTION_ID column. It registers the forms, functions, and entities within EBS that are enabled to use the attachment framework.

These relationships are fundamental. Any configuration of document attachments for a specific form requires an entry in FND_ATTACHMENT_FUNCTIONS, a defined category in FND_DOCUMENT_CATEGORIES, and a linking record in FND_DOC_CATEGORY_USAGES to make the category available for selection.