Results for “sy_docs_seq”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

SY_DOCS_SEQ is a GMA (Process Manufacturing Systems) table that governs document sequencing by organization. Its name reflects its function: a sequence control table that defines, per organization and document type, how identifiers are generated and assigned to process manufacturing documents. The table exists in both Oracle EBS 12.1.1 and 12.2.2, and the documented ETRM physical schema for 12.2.2 shows it owned by GMA with 18 columns and a single unique index, SY_DOCS_SEQ_PK.

In heuristic Data Vault terms, the FK structure suggests a satellite-leaning classification, with SY_DOCS_SEQ acting as a dependent table keyed by the combination of DOC_TYPE and ORGN_CODE. It is not a standalone transactional hub; it stores configuration and state attributes tied to organization and document type.

Key Information Stored

The primary key SY_DOCS_SEQ_PK is a composite of DOC_TYPE and ORGN_CODE. This combination is also documented as the unique business-key candidate via the SY_DOCS_SEQ_PK index.

• DOC_TYPE — identifies the document type being sequenced; also referenced by SY_DOCS_MST.
• ORGN_CODE — the organization for which sequencing applies; a foreign key to both SY_ORGN_MST_B and SY_ORGN_MST.
• ASSIGNMENT_TYPE — controls how the next document number is assigned.
• LAST_ASSIGNED — the most recently assigned sequence value, the operational state of the counter.
• FORMAT_SIZE — the width or size of the generated number format.
• PAD_CHAR — the padding character used when formatting sequence values.
• TEXT_CODE — references SY_TEXT_HDR, likely supplying label or format text for the document sequence.
• TRANS_CNT — a transaction or usage counter associated with the sequence.
• DELETE_MARK — standard logical deletion flag.
• DUMMY_FILL — used for placeholder or formatting purposes.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard EBS audit columns.

The columns SY_DOCS_SEQ_ORGN_CODE, SY_DOCS_SEQ_ORGN_CODE2, and SY_DOCS_SEQ_ORGN_CODE3 carry organization references used in the FK relationships and appear to be denormalized or historical references supporting multi-organization resolution.

Common Use Cases and Queries

Typical reporting and support scenarios involve retrieving the current sequence state or validating configuration per organization and document type.

To retrieve the current sequence for a given document type and organization:

SELECT DOC_TYPE, ORGN_CODE, LAST_ASSIGNED, ASSIGNMENT_TYPE, FORMAT_SIZE, PAD_CHAR FROM GMA.SY_DOCS_SEQ WHERE DOC_TYPE = :doc_type AND ORGN_CODE = :orgn_code;

To audit all sequences configured for an organization:

SELECT DOC_TYPE, LAST_ASSIGNED, TRANS_CNT FROM GMA.SY_DOCS_SEQ WHERE ORGN_CODE = :orgn_code AND NVL(DELETE_MARK, 0) = 0;

To join sequence configuration to document master data for validation:

SELECT s.DOC_TYPE, s.ORGN_CODE, s.LAST_ASSIGNED, m.DOC_TYPE FROM GMA.SY_DOCS_SEQ s, GMA.SY_DOCS_MST m WHERE s.DOC_TYPE = m.DOC_TYPE;

These queries support reconciliation of assigned numbers, identification of exhausted or misconfigured ranges, and diagnostics when documents fail to receive valid sequence identifiers.

Related Objects

• SY_DOCS_MST — master document type table; joined on SY_DOCS_SEQ.DOC_TYPE = SY_DOCS_MST.DOC_TYPE.
• SY_ORGN_MST — organization master; joined on SY_DOCS_SEQ.ORGN_CODE and the SY_DOCS_SEQ_ORGN_CODE, SY_DOCS_SEQ_ORGN_CODE2, SY_DOCS_SEQ_ORGN_CODE3 columns.
• SY_ORGN_MST_B — organization master (base); referenced through the same organization columns, including SY_ORGN_MST_DOC_TYPE.
• SY_TEXT_HDR — text header table; joined on SY_DOCS_SEQ.TEXT_CODE = SY_TEXT_HDR.TEXT_CODE.

The relationship with SY_ORGN_MST and SY_ORGN_MST_B is bidirectional in the metadata: those tables reference SY_DOCS_SEQ via SY_ORGN_MST_DOC_TYPE, while SY_DOCS_SEQ references them via organization code columns. This confirms SY_DOCS_SEQ as a central configuration object coupling document types to organizations within Process Manufacturing.