Search Results oe_attachment_rules




Overview
Explore in AI Chat

Overview

The OE_ATTACHMENT_RULES table is a core data object within the Oracle E-Business Suite (EBS) Order Management (ONT) module. It functions as a junction table that defines and stores the association between a specific business entity—such as a customer, item, or order type—and a corresponding document attachment rule. Its primary role is to enable the conditional, rule-based attachment of documents (e.g., terms and conditions, specifications, or compliance forms) to various transactional entities throughout the order lifecycle. By centralizing these mappings, the table provides the foundational data layer for the Order Management attachment rules functionality, ensuring that relevant documents are automatically and consistently linked to orders, lines, or other entities based on predefined business criteria.

Key Information Stored

While the provided ETRM metadata does not list all columns, the core structure of the table is defined by its documented relationships. The most critical column is the DOCUMENT_ID, which serves as a foreign key to the FND_DOCUMENTS table. This column stores the unique identifier for the specific document or template that constitutes the attachment rule. The table must also contain columns to identify the target entity to which the rule applies, such as ENTITY_ID and ENTITY_TYPE_CODE, though these are inferred from standard EBS design patterns. Additional columns likely exist to define the rule's effective dates, creation information, and the specific context or condition under which the attachment is triggered.

Common Use Cases and Queries

A primary use case is auditing and reporting on configured attachment rules. For instance, administrators may need to list all documents attached to a specific customer or item. A common query involves joining OE_ATTACHMENT_RULES with FND_DOCUMENTS to retrieve the document title and identifier. Troubleshooting why a specific document is not attaching to an order often requires querying this table to verify an active rule exists for the relevant entity. Sample SQL to retrieve rule details might resemble:

  • SELECT oar.entity_type_code, oar.entity_id, fd.document_id, fd.datatype_id, fd.title FROM ont.oe_attachment_rules oar, applsys.fnd_documents fd WHERE oar.document_id = fd.document_id AND SYSDATE BETWEEN oar.start_date_active AND NVL(oar.end_date_active, SYSDATE+1);

This pattern is essential for data validation, security reviews, and supporting business process audits.

Related Objects

The OE_ATTACHMENT_RULES table maintains a direct and critical foreign key relationship with the foundational FND_DOCUMENTS table, as explicitly documented in the ETRM metadata.

  • FND_DOCUMENTS: This is the master table for all documents within Oracle EBS. The relationship is defined as OE_ATTACHMENT_RULES.DOCUMENT_ID → FND_DOCUMENTS.DOCUMENT_ID. Any document referenced in an attachment rule must first be registered in FND_DOCUMENTS. This relationship is fundamental for retrieving the actual document content, title, and metadata associated with a rule.

While not listed in the provided excerpt, this table is also intrinsically linked to the Order Management entities (e.g., OE_ORDER_HEADERS, OE_ORDER_LINES) and setup tables (like OE_TRANSACTION_TYPES) that are referenced by the ENTITY_ID and ENTITY_TYPE_CODE columns to complete the rule's business logic.