Search Results sy_docs_seq_pk

Overview

The SY_DOCS_SEQ table is a core data object within the GMA (Process Manufacturing Systems) module of Oracle E-Business Suite 12.1.1 and 12.2.2. Its primary function is to manage and control document sequencing on a per-organization basis. This table acts as a configuration and control point, ensuring that critical documents generated within the Process Manufacturing environment, such as batch records, quality results, or process instructions, follow a defined, organization-specific numbering sequence. This is essential for maintaining traceability, audit trails, and operational integrity across manufacturing sites.

Key Information Stored

The table's structure is defined by its primary key, which consists of the columns DOC_TYPE and ORGN_CODE. This composite key enforces the rule that sequencing is uniquely defined for each combination of document type and organization. While the full column list is not detailed in the provided metadata, the foreign key relationships indicate the presence of several critical fields. The DOC_TYPE column links to the SY_DOCS_MST table, which defines the master list of valid document types. The ORGN_CODE column, along with related columns SY_DOCS_SEQ_ORGN_CODE, SY_DOCS_SEQ_ORGN_CODE2, and SY_DOCS_SEQ_ORGN_CODE3, establishes multiple relationships with the organization master tables (SY_ORGN_MST and SY_ORGN_MST_B). A TEXT_CODE column provides a link to the SY_TEXT_HDR table, likely for storing descriptive or instructional text associated with the document sequence setup.

Common Use Cases and Queries

A primary use case is retrieving the current or next sequence number for a specific document type within an organization to generate a new document identifier. Database triggers or application logic would typically query and update this table. Common reporting needs include auditing sequence configurations across all organizations or identifying gaps in sequence numbering. Sample SQL patterns include:

• Retrieving sequence configuration for a specific org: SELECT * FROM GMA.SY_DOCS_SEQ WHERE ORGN_CODE = '<ORG_CODE>';
• Listing all document types with sequencing defined: SELECT DISTINCT DOC_TYPE FROM GMA.SY_DOCS_SEQ;
• Joining with document master for a descriptive report: SELECT s.*, m.DOC_NAME FROM GMA.SY_DOCS_SEQ s, GMA.SY_DOCS_MST m WHERE s.DOC_TYPE = m.DOC_TYPE;

Related Objects

The SY_DOCS_SEQ table is centrally connected to several key master tables in the GMA schema, as evidenced by its foreign key constraints. Its primary relationships are with SY_DOCS_MST (for the document type definition) and the organization master tables SY_ORGN_MST and SY_ORGN_MST_B. The link to SY_TEXT_HDR suggests that descriptive text can be associated with each sequence record. The existence of a primary key constraint named SY_DOCS_SEQ_PK and multiple foreign keys indicates this table is a critical reference point, and it is likely referenced by transactional tables that generate the actual sequenced documents, though those are not listed in the provided metadata.