Search Results sy_docs_mst




Overview
Explore in AI Chat

Overview

The SY_DOCS_MST table is a core master data table within the Oracle Process Manufacturing (OPM) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. Owned by the GMA (Process Manufacturing Systems) schema, it serves as the central repository for document definitions. In the context of OPM, a "document" typically refers to a transaction type or a business document that governs material movements, cost adjustments, production, and other manufacturing processes. This table establishes the valid document types used throughout the OPM inventory, production, and costing cycles, acting as a critical reference for transactional integrity and process control.

Key Information Stored

While the provided ETRM excerpt does not list individual columns, the structure and relationships indicate its primary purpose. The table's primary key is the DOC_TYPE column, which uniquely identifies each document definition, such as a cycle count adjustment, production completion, or physical inventory transfer. Based on its foreign key relationships, the table likely stores additional descriptive attributes for each document type, potentially including a link to textual descriptions via the TEXT_CODE foreign key to the SY_TEXT_HDR table. This connection allows for multilingual support and detailed documentation of each transaction type.

Common Use Cases and Queries

The primary use case for SY_DOCS_MST is as a validation and reporting reference table. Applications and custom reports query it to validate transaction types and retrieve descriptive information. Common SQL patterns include joining transactional tables to SY_DOCS_MST to decode document types in user reports. For instance, a query to list all pending inventory transactions with their document descriptions might resemble:

  • SELECT t.transaction_id, t.doc_type, m.description FROM ic_tran_pnd t, sy_docs_mst m WHERE t.doc_type = m.doc_type;

Another critical use is in setup and configuration, where administrators ensure all required document types for business processes are defined within this master table.

Related Objects

SY_DOCS_MST has extensive relationships with key OPM transactional tables, as shown by its foreign keys. It is referenced by inventory transaction tables (IC_TRAN_PND, IC_TRAN_CMP, IC_TRAN_ARC), cycle count and adjustment journals (IC_CYCL_ADT, IC_ADJS_JNL), production transactions (PC_TRAN_PND), and purchasing cost distributions (PO_COST_DTL, PO_DIST_DTL). It also relates to the material requirements action table (MR_ACTN_TBL) and the document sequence control table (SY_DOCS_SEQ). The link to SY_TEXT_HDR via the TEXT_CODE column provides associated multilingual text. These relationships underscore its role as a foundational master table for OPM transaction processing.