Search Results rlm_cust_shipto_terms_all




Overview
Explore in AI Chat

Overview

The RLM_CUST_SHIPTO_TERMS_ALL table is an Oracle E-Business Suite Release Management (RLM) transactional configuration table that stores customer address attributes which are dependent upon the ship-from/ship-to relationship. Introduced as part of the R-12 architecture, this table consolidates attributes that were previously scattered across legacy structures; the documentation explicitly notes that some Phase 1 attributes were carried forward from VEH_RA_ADDRESSES, a table being eliminated in Phase 2. The table resides in the RLM schema with a documented status of VALID and contains 119 columns in the 12.2.2 physical schema.

Its principal role is to define the operational and planning terms that govern how a specific ship-from organization services a specific customer ship-to address. These terms include cumulative (CUM) management rules, planning and sequencing horizon windows, shipping calendars, demand tolerances, and release processing parameters. Because such terms vary by the combination of customer, address, ship-from organization, and operating unit, the table functions as a high-cardinality configuration repository rather than a transaction log.

From a modeling perspective, the heuristic Data Vault classification mined from the foreign-key structure is standalone. In Data Vault terms, it is best treated as a standalone satellite-like structure anchored to its own surrogate key rather than as a classic hub or link, since no parent relationships were documented in the ETRM metadata. This classification is offered as a modeling suggestion only.

Key Information Stored

The table is anchored by a surrogate primary key, CUST_SHIPTO_TERMS_ID, enforced through the constraint CUST_SHIPTO_TERMS_PK. A separate unique index, RLM_CUST_SHIPTO_TERMS_U1, defines the business-key candidate over the combination of CUSTOMER_ID, ADDRESS_ID, SHIP_FROM_ORG_ID, and ORG_ID. This four-column key establishes the natural identity of a shipto-terms record.

Among the most operationally significant columns:

Common Use Cases and Queries

Typical usage centers on retrieving the governing terms for a given customer/address/ship-from combination, reporting on active versus inactive configurations, and validating that planning horizons and CUM rules are consistently defined across a customer base.

A common retrieval pattern resolves the business key:

  • SELECT * FROM rlm.rlm_cust_shipto_terms_all WHERE customer_id = :p_customer AND address_id = :p_address AND ship_from_org_id = :p_org AND org_id = :p_org_id;

Reporting queries frequently filter on INACTIVE_DATE IS NULL to isolate currently effective records, or aggregate counts of configured ship-to terms per operating unit. Planning diagnostics join the horizon columns (PLN_*, SHP_*, SEQ_*) to compare time fences across addresses. Release-processing reports examine RELEASE_RULE and RELEASE_TIME_FRAME to verify blanket agreement behavior. Because the unique index covers the four business-key columns, index-driven access is efficient for these lookup patterns.

Related Objects

While ETRM documentation classifies this table as standalone with no mined foreign-key relationships, functional dependencies exist within the RLM and order-management domains:

These associations should be validated against the deployed 12.1.1 or 12.2.2 instance, as the metadata documents the table as relationally standalone.