Search Results oe_cust_item_settings




Overview
Explore in AI Chat

Overview

The OE_CUST_ITEM_SETTINGS table is a core Order Management (ONT) reference table in Oracle E-Business Suite 12.1.1 and 12.2.2, owned by the ONT schema. It stores shipment and return tolerances for customer-item, item-site, and item-level combinations. These tolerances govern the acceptable variance between ordered quantity and shipped or returned quantity before the system raises an exception or blocks the transaction, allowing organizations to enforce fulfillment policies at a granular level.

The table carries a status of VALID and is maintained within the ONT product module. From a Data Vault modeling perspective, the FK structure suggests this object is satellite-leaning: it attaches descriptive tolerance attributes to the customer and item relationships rather than acting as an independent business hub or a pure intersection link. The heuristic classification is a modeling suggestion only, derived from the single documented foreign key to RA_CUSTOMERS.

Key Information Stored

Each row is uniquely identified by the surrogate primary key CUST_ITEM_SETTING_ID, enforced through the OE_CUST_ITEM_SETTINGS_PK constraint. A corresponding unique index, OE_CUST_ITEM_SETTINGS_U, is documented on the same column and serves as the business-key candidate. The table contains 30 documented columns, of which the most functionally significant are:

Common Use Cases and Queries

Order Management relies on this table during pick release, ship confirmation, and return processing to validate whether quantities fall within configured tolerance bands. A typical reporting query resolves tolerance settings for a given customer and item:

  • Retrieving tolerances for a customer-item combination: SELECT over_shipment_tolerance, under_shipment_tolerance FROM oe_cust_item_settings WHERE customer_id = :p_customer_id AND internal_item_id = :p_item_id.
  • Auditing site-level overrides by joining on SITE_USE_ID and INVENTORY_ORG_ID.
  • Identifying all settings defined for a specific item to reconcile fulfillment policy across customers.
  • Enforcing or reporting on return tolerance breaches in RMA workflows.

Because CUSTOMER_ID relates to RA_CUSTOMERS, reporting joins typically combine this table with customer master data to produce tolerance-by-customer extracts.

Related Objects

  • RA_CUSTOMERS — joined via CUSTOMER_ID; the documented foreign key referenced by this table.
  • OE_ORDER_HEADERS_ALL / OE_ORDER_LINES_ALL — order and line data compared against tolerance thresholds during shipping.
  • MTL_SYSTEM_ITEMS_B — source of item validation via INTERNAL_ITEM_ID.
  • ORG_ORGANIZATION_DEFINITIONS — resolves INVENTORY_ORG_ID to organization context.
  • RA_SITE_USES_ALL — provides site use detail for SITE_USE_ID.
  • The Order Management tolerances setup UI and related PL/SQL APIs that read and maintain these records.