Results for “sy_orgn_mst”

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

Overview

SY_ORGN_MST is the organization code master table within the GMA (Process Manufacturing Systems) product family of Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the definitive register of organizations—companies, plants, warehouses, and related operating units—used throughout the Process Manufacturing applications. Nearly every transactional and setup table in the Process Manufacturing schema carries an ORGN_CODE or CO_CODE column that resolves to this master, making SY_ORGN_MST the principal organizational reference entity for the suite.

The ETRM metadata records an important caveat: this table is documented as "not implemented in this database," meaning the definition exists in the ETRM reference model but may not be instantiated in every environment. Implementers should verify physical presence before writing queries against it. From a modeling perspective, the documented FK structure is best characterized as hub-leaning: SY_ORGN_MST is a central reference point with a stable business key, a self-referencing hierarchy, and a very large number of dependent tables, which is consistent with hub behavior in a Data Vault style model.

Key Information Stored

The documented primary key is SY_ORGN_MST_PK, defined on ORGN_CODE. A second unique key, SY_ORGN_MST_U1, is defined on ORGANIZATION_ID, indicating the surrogate identifier used to align the Process Manufacturing organization with the Oracle EBS HR organization model. The principal columns documented in the metadata are:

• ORGN_CODE — the business organization code and the primary key of the table.
• ORGANIZATION_ID — surrogate identifier; the second unique key, used to cross-reference the EBS organization definition.
• CO_CODE — company code; a self-referencing foreign key pointing back to SY_ORGN_MST.
• PARENT_ORGN_CODE — self-referencing foreign key that establishes the organizational hierarchy.
• ADDR_ID — foreign key to SY_ADDR_MST, supplying the organization address.
• TEXT_CODE — foreign key to SY_TEXT_HDR, linking descriptive text.
• TAXLOC_CODE — foreign key to TX_TLOC_CDS, the tax location code.
• SY_ORGN_MST_DOC_TYPE — together with ORGN_CODE, forms the foreign key to SY_DOCS_SEQ for document sequencing.

Additional descriptive attributes exist beyond those enumerated in the excerpt, but the columns above are the ones confirmed by the documented metadata and are the ones most commonly joined in practice.

Common Use Cases and Queries

The most frequent use of SY_ORGN_MST is resolving an ORGN_CODE to a human-readable organization name and its associated company or parent. A typical lookup joins the master to a transactional table such as IC_CLDR_HDR, the inventory calendar header, which the user's search term "ic_cldr_hdr" suggests was the original subject of investigation:

SELECT c.ORGN_CODE, o.ORGANIZATION_ID, o.CO_CODE, o.PARENT_ORGN_CODE
FROM IC_CLDR_HDR c, SY_ORGN_MST o
WHERE c.ORGN_CODE = o.ORGN_CODE;

Hierarchy reporting is another common scenario, using the self-referencing PARENT_ORGN_CODE to walk the organization tree, for example with a CONNECT BY query rooted at a top-level company code. Company-level rollups join on CO_CODE, allowing transactions recorded at plant level to be aggregated to the legal entity. Address and tax reporting joins to SY_ADDR_MST via ADDR_ID and to TX_TLOC_CDS via TAXLOC_CODE. Entries in SY_DOCS_SEQ, IC_TRAN_ARC, IC_TRAN_CMP, and IC_TRAN_PND all depend on this master, so master-data validation queries—identifying orphaned organization codes in transaction tables—are a routine data-integrity task.

Related Objects

The documented relationship data identifies a broad dependency footprint. The most significant related objects include:

• IC_CLDR_HDR — inventory calendar header, joined on ORGN_CODE.
• IC_TRAN_ARC, IC_TRAN_CMP, IC_TRAN_PND — inventory transaction tables, joined on ORGN_CODE and CO_CODE.
• IC_JRNL_MST and IC_CYCL_HDR — inventory journal and cycle count headers, joined on ORGN_CODE.
• SY_DOCS_SEQ — document sequence definition, joined on ORGN_CODE and the document type columns.
• SY_ADDR_MST and SY_TEXT_HDR — address and text masters referenced by ADDR_ID and TEXT_CODE.
• TX_TLOC_CDS — tax location codes referenced by TAXLOC_CODE.
• GL_ACCT_MAP and GL_PLCY_MST — general ledger mapping and policy tables, joined on ORGN_CODE and CO_CODE.
• PO_ORDR_HDR and OP_ORDR_HDR — purchasing and order headers, joined on ORGN_CODE.

Because it functions as the organizational hub for the Process Manufacturing schema, SY_ORGN_MST should be treated as reference data of the highest stability, and any change to its contents should be evaluated against the full set of dependent tables listed in the ETRM relationship data.