Search Results mtl_interorg_parameters

Overview

The MTL_INTERORG_PARAMETERS table is a core master data table within Oracle E-Business Suite Inventory (INV) that defines and governs the operational and financial relationships between two inventory organizations. It serves as the central repository for inter-organization parameters, enabling and controlling the flow of material and associated accounting transactions across organizational boundaries. Every defined relationship from a source (FROM) organization to a destination (TO) organization requires a corresponding record in this table. Its configuration is essential for functionalities like inter-organization transfers, in-transit inventory management, internal sales, and Kanban replenishment.

Key Information Stored

The table's primary key is a composite of FROM_ORGANIZATION_ID and TO_ORGANIZATION_ID, ensuring a unique definition for each directional relationship. Beyond the organizational identifiers, the table stores critical control and accounting parameters. Key columns include SHIPPABLE_FLAG, which determines if items can be shipped between the organizations, and various account IDs that define the General Ledger accounts used for intercompany transactions. Per the provided metadata, these include INTRANSIT_INV_ACCOUNT, INTERORG_TRANSFER_CR_ACCOUNT, INTERORG_RECEIVABLES_ACCOUNT, INTERORG_PAYABLES_ACCOUNT, and INTERORG_PRICE_VAR_ACCOUNT. Additional columns often define transfer types (direct or in-transit), freight codes, and internal order requirements.

Common Use Cases and Queries

This table is pivotal for transaction processing and reporting. Common operational use cases include validating transfer order creation, determining in-transit accounting, and sourcing Kanban replenishment signals from a supplying organization. A fundamental query retrieves all defined relationships for an organization:

• SELECT from_org.organization_code from_org, to_org.organization_code to_org, mip.* FROM mtl_interorg_parameters mip JOIN hr_organization_units from_org ON mip.from_organization_id = from_organization_id JOIN hr_organization_units to_org ON mip.to_organization_id = to_org.organization_id WHERE from_org.organization_code = '&FROM_ORG';

For troubleshooting transfer errors, a query to verify if a specific relationship is active and shipable is essential. Reporting often involves joining this table with HR_ORGANIZATION_UNITS for organization names and GL_CODE_COMBINATIONS for account details to analyze inter-org accounting setups.

Related Objects

As indicated by the foreign key constraints, MTL_INTERORG_PARAMETERS has strong dependencies on several key tables. It references MTL_PARAMETERS (via FROM_ORGANIZATION_ID and TO_ORGANIZATION_ID) for organization-specific inventory parameters and GL_CODE_COMBINATIONS for its various accounting segments. Crucially, it is referenced by transactional and planning tables. The metadata shows that MTL_SUPPLY references it to track inter-organization supply, while FLM_KANBAN_SUMMARY, MTL_KANBAN_CARDS, and MTL_KANBAN_PULL_SEQUENCES reference it to define Kanban source relationships. This network of relationships underscores its role as a foundational setup table for supply chain execution within Oracle EBS.