Results for “wsh_cc_service_setups”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

WSH_CC_SERVICE_SETUPS is a table in the WSH (Shipping Execution) schema that stores Service Setup Information for Oracle E-Business Suite Release 12.1.1 and 12.2.2. It belongs to the family of "CC" (cost calculation / charge computation) tables used by Shipping Execution to configure how carrier and shipping services are invoked during the rating, routing, and manifesting process. Each row defines a service configuration record — a handler, a version, country-matching rules, thresholds, and workflow routing — that WSH uses to determine which external or internal service should be called and how its result should be applied to a shipment, delivery, or freight cost.

From a data-modeling perspective, the mined foreign-key structure gives WSH_CC_SERVICE_SETUPS a standalone Data Vault classification — it is not documented as a strict hub, link, or satellite by ETRM. Treat this as a heuristic: in practice the table can be modeled as a satellite attached to an organization or master-organization hub, since it carries descriptive setup attributes (service type, version, handler, thresholds, flags) keyed by a surrogate identifier. Because no outgoing FK dependencies are documented, the table is largely self-contained and referenced by service-invocation logic rather than by declarative constraints.

Key Information Stored

The table contains 25 documented columns in the 12.2.2 physical schema. The most significant are:

• CC_SERVICE_SEQUENCE_ID — the surrogate primary key defined by constraint WSH_CC_SERVICE_SETUPS_PK. It uniquely identifies each service setup record.
• MASTER_ORGANIZATION_ID and ORGANIZATION_ID — define the organizational scope of the setup, distinguishing a master (global) configuration from an operating-unit-specific override.
• APPLICATION_ID and APPLICATION_USER_ID — identify the owning application and the user context under which the service is executed.
• SERVICE_TYPE_CODE — the business discriminator classifying the service (for example, rate shopping, address validation, or routing).
• SERVICE_VERSION and SERVICE_HANDLER — the version and the PL/SQL or external handler invoked to execute the service.
• SERVICE_DEFAULT_THRESHOLD — the threshold value applied when no override (such as a customized threshold) is provided.
• COUNTRY_MATCH_FLAG and RED_FLAG — control flags governing whether country matching is enforced and whether the service is flagged for exception handling.
• SHIP_FROM_COUNTRY_SCHEME / SHIP_FROM_COUNTRY_DOMAIN and SHIP_TO_COUNTRY_SCHEME / SHIP_TO_COUNTRY_DOMAIN — define the country classification schemes and domains used for ship-from and ship-to matching.
• CHARGE_SCHEME and CHARGE_DOMAIN — determine how charges are classified and grouped for the service.
• SERVICE_PRIORITY — the ordering value used when multiple services qualify for a transaction.
• WF_ITEM_TYPE and WF_ACTIVITY — the Oracle Workflow item type and activity invoked for the service, enabling post-processing or exception workflows.
• LAST_UPDATED_BY, CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard auditing columns maintained by the EBS concurrency and audit framework.

The documented primary key is the only unique constraint identified; business-key candidates are not separately enumerated in ETRM, so joins should generally rely on CC_SERVICE_SEQUENCE_ID or on the organization and service-type combination.

Common Use Cases and Queries

Typical uses of this table include reviewing service configuration for a given organization, validating that a required service type is enabled, and auditing which workflow activity is attached to a service.

• List active service setups for an operating unit:

  SELECT cc_service_sequence_id, service_type_code, service_handler,
         service_version, service_priority
    FROM wsh.wsh_cc_service_setups
   WHERE organization_id = :org_id
     AND master_organization_id = :master_org_id;

• Find services using a specific handler or version, useful when debugging service invocation failures.

  SELECT service_type_code, service_handler, service_version
    FROM wsh.wsh_cc_service_setups
   WHERE service_handler = :handler_name;

• Identify services configured for a workflow activity, or those with a red flag set for exception monitoring.

  SELECT service_type_code, wf_item_type, wf_activity, red_flag
    FROM wsh.wsh_cc_service_setups
   WHERE wf_item_type = :item_type;

• Reporting on country matching coverage for ship-from and ship-to domains.

Related Objects

Because the table is documented as standalone, it has no declarative foreign-key dependents. However, the following significant objects frequently participate in the same shipping and workflow processing paths and are the usual join or reference points:

• WSH_CC_SERVICE_SETUPS_PK — the primary key constraint on CC_SERVICE_SEQUENCE_ID.
• WSH_CC_SERVICE_SETUP_PARAMS (or analogous service parameter tables) — store the parameter values consumed by the handler defined here.
• WSH_CC_SERVICE_RESULTS / WSH_CC_SERVICE_LOG — capture invocation outcomes for the configured services.
• HR_ALL_ORGANIZATION_UNITS — resolves ORGANIZATION_ID and MASTER_ORGANIZATION_ID to organization names.
• FND_APPLICATION — resolves APPLICATION_ID to the owning application.
• FND_USER — resolves APPLICATION_USER_ID to a user.
• WSH_DELIVERY_DETAILS, WSH_TRIPS, WSH_NEW_DELIVERIES — the shipping entities whose rating, routing, or manifesting consumes the configured services.
• WF_ITEM_TYPES / WF_ACTIVITIES — resolve the workflow item type and activity referenced by WF_ITEM_TYPE and WF_ACTIVITY.