Search Results so_sales_credit_types_115




Overview
Explore in AI Chat

Overview

SO_SALES_CREDIT_TYPES_115 is a reference (lookup) table owned by the OE schema within the Oracle Order Entry (Order Management) product family. It stores the set of sales credit types that Oracle E-Business Suite uses to classify and attribute sales credit when order lines, sales orders, and receivables transactions are recorded. Each row defines a distinct credit type — for example, quota-bearing versus non-quota credit — along with the enablement status and descriptive attributes that control how the credit is applied throughout the order-to-cash flow.

The table occupies a central, low-volatility position in the sales credit model. It is referenced by sales credit transactions, salesrep definitions, and the various interface and staging tables that move credit data between Order Management, Receivables, Advanced Supply Chain, and Service modules. Under a heuristic Data Vault classification derived from the foreign-key structure, this object is best modeled as a hub: it carries a stable business key and serves as the anchor point from which multiple dependent satellite and link relationships radiate.

Key Information Stored

The table contains 26 documented columns. The most significant are the following:

Common Use Cases and Queries

Typical reporting and integration scenarios retrieve the enabled credit types available for assignment, resolve the ID-to-name mapping for sales credit reports, and validate interface records before import. A common query joins the reference table to sales credit facts to produce readable reports:

  • Listing active credit types: SELECT sales_credit_type_id, name, quota_flag FROM oe.so_sales_credit_types_115 WHERE enabled_flag = 'Y' ORDER BY name;
  • Resolving credit contributions: SELECT sc.sales_credit_type_id, sct.name, SUM(sc.percent) FROM oe.so_sales_credits sc, oe.so_sales_credit_types_115 sct WHERE sc.sales_credit_type_id = sct.sales_credit_type_id GROUP BY sc.sales_credit_type_id, sct.name;
  • Validating interface data by joining SO_SALES_CREDITS_INTERFACE or OE_CREDITS_IFACE_ALL on SALES_CREDIT_TYPE_ID to confirm each referenced type exists and is enabled prior to import.

Related Objects

The foreign-key metadata identifies this table as a heavily referenced hub. The most significant dependent objects are: