Search Results sy_orgn_mst_b




Overview
Explore in AI Chat

Overview

The SY_ORGN_MST_B table is the foundational organization code master table within Oracle E-Business Suite Process Manufacturing (GMA) modules. It serves as the central repository for defining and managing all operational entities, such as manufacturing plants, warehouses, and corporate divisions, that are critical for transactional and master data segregation. Its role is integral to the multi-organization architecture in EBS, enabling data partitioning and security by organization. The table's extensive foreign key relationships, as documented, demonstrate its pivotal position in linking organizational context to virtually all core Process Manufacturing transactions, configurations, and financial integrations.

Key Information Stored

While the full column list is not provided in the excerpt, the documented primary and foreign keys reveal the core data structure. Each record is uniquely identified by two primary keys: ORGN_CODE (a business identifier) and ORGANIZATION_ID (a system identifier, likely aligning with the standard INV_ORG_PARAMETERS table). Essential relational attributes include CO_CODE (company code), PARENT_ORGN_CODE (for hierarchical structures), ADDR_ID (link to address master), TEXT_CODE (for descriptive flexfields), and TAXLOC_CODE (for tax location). This structure supports complex organizational hierarchies and the attachment of supplementary business information.

Common Use Cases and Queries

This table is primarily accessed for organization validation, reporting segmentation, and as a driving table for setups. Common scenarios include generating a list of all organizations within a specific company code, validating an organization code during a data import, or joining to transactional data for organization-specific reporting. A typical query pattern involves joining SY_ORGN_MST_B to transactional tables using ORGN_CODE. For example, to report on adjustments by organization name, one might join to IC_ADJS_JNL:

  • SELECT o.orgn_code, o.organization_id, COUNT(a.trans_id) FROM sy_orgn_mst_b o, ic_adjs_jnl a WHERE o.orgn_code = a.orgn_code GROUP BY o.orgn_code, o.organization_id;

Another critical use case is in data migration scripts, where this table is referenced to populate the ORGANIZATION_ID foreign key columns in various interface tables.

Related Objects

As evidenced by the extensive foreign key metadata, SY_ORGN_MST_B is a parent table to a vast array of Process Manufacturing objects. Key documented relationships include:

These relationships confirm that SY_ORGN_MST_B is a cornerstone table for data integrity across the GMA product family, ensuring all transactions and master data are correctly associated with a valid operating unit.