Search Results sy_addr_mst




Overview
Explore in AI Chat

Overview

The SY_ADDR_MST table is the central address master repository within the Oracle Process Manufacturing (OPM) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. Owned by the GMA (Process Manufacturing Systems) schema, it functions as a single source of truth for all address data across the OPM suite. Its primary role is to eliminate data redundancy by storing address information once and allowing it to be referenced by a unique identifier (ADDR_ID) from numerous transactional and master tables throughout the system. This design ensures data integrity and consistency for business entities such as customers, vendors, warehouses, and organizations.

Key Information Stored

While the provided metadata does not list specific columns, the structure of SY_ADDR_MST is defined by its primary and foreign key relationships. The table's core identifier is the ADDR_ID column, which serves as the primary key (SY_ADDR_MST_PK). A typical OPM address master would also contain standard address attributes such as address lines (ADDR_LINE_1, ADDR_LINE_2, ADDR_LINE_3), city (CITY), state (STATE), postal code (ZIP), country (COUNTRY), and potentially contact names and phone numbers. The extensive list of foreign key relationships indicates that the table is designed to support a wide array of address types, including shipping, billing, mailing, and physical location addresses.

Common Use Cases and Queries

This table is integral to any process requiring address lookup or validation. Common use cases include generating shipping documents, customer and vendor communications, tax calculations, and logistics planning. A frequent query pattern involves joining SY_ADDR_MST to a transactional table to retrieve a complete address for a record. For example, to find the ship-to address for a specific sales order, one would join OP_ORDR_HDR to SY_ADDR_MST. The user's search for "op_fobc_mst" is directly relevant, as OP_FOBC_MST (likely FOB or Freight-On-Board master) references SY_ADDR_MST via its ADDR_ID column, possibly to define a location associated with shipping terms.

SELECT oh.ordr_no, oh.ordr_id, a.*
FROM op_ordr_hdr oh,
     sy_addr_mst a
WHERE oh.shipaddr_id = a.addr_id
AND oh.ordr_no = '123456';

Related Objects

SY_ADDR_MST is a foundational table with extensive dependencies across OPM and integrated EBS modules. As documented, its foreign key relationships span several key functional areas:

The table referenced in the user's search, OP_FOBC_MST, is one of these related objects, confirming SY_ADDR_MST's role in defining geographical points for trade terms.