Search Results gsa_indicator




Overview
Explore in AI Chat

Overview

SO_CUSTOMERS_ACTIVE_V is a reporting and integration view in the Oracle E-Business Suite Order Entry (OE) module. It was originally defined as a component of the Oracle Order Management schema and is used throughout EBS 12.1.1 and 12.2.2 to expose a filtered, denormalized list of active customers. The view presents only those customer records that represent genuine, active business entities, shielding downstream processes from obsolete, inactive, or prospect-designated records in the customer master.

The view surfaces four columns: the customer name, customer number, customer ID, and a normalized GSA (General Services Administration) indicator. Its primary role is to provide a stable, self-contained source of customer reference data for order entry, reporting, and external integration, so that callers do not need to replicate the underlying filtering predicates themselves. The view is documented as not implemented in the ETRM reference database, meaning it is a seeded/defined object whose definition is shipped but which may not exist in every environment; its text should therefore be treated as the authoritative specification.

Underlying Base Objects

Although the ETRM metadata lists no referenced base objects, the documented view text shows that SO_CUSTOMERS_ACTIVE_V is defined over a single base table: RA_CUSTOMERS (the Oracle Receivables customer master). The relationship is a simple one-to-one projection: the view selects four expressions from RA_CUSTOMERS with no joins.

Two filtering predicates restrict the rows returned. First, STATUS = 'A' retains only customers whose record status is Active in the customer master. Second, NVL(CUSTOMER_PROSPECT_CODE, 'CUSTOMER') = 'CUSTOMER' excludes prospects and includes any record whose prospect code is null or explicitly set to CUSTOMER. Together, these conditions ensure the view contains only established, active customer accounts, and not prospects or inactive records.

Key Columns

  • CUSTOMER_ID — The unique primary identifier for the customer in RA_CUSTOMERS; used as the foreign key for joining to orders, sites, contacts, and other customer-related entities.
  • CUSTOMER_NUMBER — The user-facing, system-assigned customer account number, commonly used in references and interfaces.
  • CUSTOMER_NAME — The display name of the customer, used for reporting, lookups, and validation.
  • GSA_INDICATOR — Derived via NVL(GSA_INDICATOR, 'N'), this column returns the GSA flag for the customer, defaulting to 'N' when the underlying value is null. It indicates whether the customer is associated with GSA (U.S. Government) schedules, and is the column most frequently sought by users searching for gsa_indicator.

Common Use Cases and Queries

Because the view already filters out inactive and prospect customers and normalizes the GSA flag, it is well suited to customer selection lists, order-entry validation, and reporting where only active customers are relevant. A typical query listing active GSA customers would be:

SELECT customer_id, customer_number, customer_name, gsa_indicator
FROM so_customers_active_v
WHERE gsa_indicator = 'Y'
ORDER BY customer_name;

For an integration or lookup that requires all active customers regardless of GSA status, the gsa_indicator predicate is simply omitted:

SELECT customer_number, customer_name
FROM so_customers_active_v
ORDER BY customer_number;

The view is also useful for resolving a customer name from a stored CUSTOMER_ID, or for joining to order headers to restrict results to active customers only. When querying, note that the GSA column is guaranteed non-null, so comparisons against 'Y' or 'N' are reliable without additional NVL handling.