Search Results op_fobc_mst_pk




Overview
Explore in AI Chat

Overview

The OP_FOBC_MST table is a master data table within the Oracle E-Business Suite (EBS) Process Manufacturing Logistics (GML) module. It serves as the central repository for defining and maintaining Free on Board (FOB) codes. An FOB code is a critical term in commercial and logistics transactions that determines the point at which ownership, costs, and risks of goods are transferred from a seller to a buyer. This table provides a standardized list of such codes (e.g., FOB Origin, FOB Destination) that are referenced throughout the order management and procurement cycles in both discrete and process manufacturing environments. Its role is to ensure consistent application of shipping and liability terms across sales orders, purchase orders, and customer/supplier records.

Key Information Stored

While the provided ETRM metadata does not list all columns, the primary and foreign key relationships reveal its core structure. The table's primary identifier is the FOB_CODE column, which is enforced by the OP_FOBC_MST_PK primary key constraint. This column stores the unique alphanumeric code for each FOB term. The table also contains descriptive and relational attributes. Key columns include TEXT_CODE, which links to the OP_TEXT_HDR table to store descriptive text and long definitions for the FOB term, and ADDR_ID, which links to the SY_ADDR_MST table, potentially to associate a specific shipping location or address with the FOB term. The existence of a column named OF_FOB_CODE, noted as part of the OP_FOBC_MST01 key, may indicate an alternate or legacy key structure.

Common Use Cases and Queries

This table is primarily used for setup, validation, and reporting on transactional data. Common scenarios include configuring available FOB terms during implementation, validating FOB codes entered on orders, and generating reports that analyze order terms. A typical query to retrieve all active FOB codes with their descriptions would involve joining to the text table. For troubleshooting, one might query which sales orders use a specific FOB code to understand its application.

  • Listing All FOB Codes: SELECT fob.fob_code, tl.meaning FROM gml.op_fobc_mst fob, fnd_lookup_values_tl tl WHERE tl.lookup_type = 'FOB' AND tl.lookup_code = fob.fob_code AND tl.language = USERENV('LANG');
  • Finding Transactions for a Code: SELECT order_number, fob_code FROM oe_order_headers_all WHERE fob_code = 'ORIGIN';

Related Objects

The OP_FOBC_MST table is a foundational reference object with extensive dependencies across the Order Management (OP) and Purchasing (PO) modules. As per the metadata, its FOB_CODE column is referenced as a foreign key in numerous critical transaction tables. Key related objects include: