Search Results ams_custom_setups_b




Overview
Explore in AI Chat

Overview

The AMS_CUSTOM_SETUPS_B table is a core data repository within the Oracle E-Business Suite Marketing (AMS) module. It serves as the central master table for storing definitions of custom setup entities. In the context of Oracle EBS 12.1.1 and 12.2.2, custom setups are configurable metadata objects that extend and control the behavior of various marketing components. The table's primary role is to provide a unique identifier and base attributes for these setups, enabling their association and reuse across a wide spectrum of marketing and related functionalities, from campaigns and events to partner programs and data mining models.

Key Information Stored

The table's primary key is the CUSTOM_SETUP_ID, a unique system-generated identifier for each custom setup record. While the provided metadata does not list all columns, the foreign key relationships indicate other critical fields. The APPLICATION_ID column links the setup to a specific Oracle application via the FND_APPLICATION table, establishing product ownership. The MEDIA_ID column associates the setup with a specific media type defined in the AMS_MEDIA_B table. Additional columns, not explicitly listed but typical for such master tables, would likely include creation and last update dates, the ID of the creating user, and a system-level ENABLED_FLAG to control active status.

Common Use Cases and Queries

This table is fundamental for queries that need to identify or report on the custom setups used across the marketing instance. A common use case involves tracing which setups are applied to specific marketing objects, such as offers or events. For example, to find all active custom setups used for campaign offers, a developer might execute a query joining AMS_CUSTOM_SETUPS_B to AMS_OFFERS. Another typical scenario is auditing setup usage before a migration or upgrade. A sample query to list all custom setups and their associated application would be:

  • SELECT cs.CUSTOM_SETUP_ID, fa.APPLICATION_NAME FROM AMS_CUSTOM_SETUPS_B cs, FND_APPLICATION fa WHERE cs.APPLICATION_ID = fa.APPLICATION_ID;

Technical consultants also query this table to understand dependencies when modifying or purging setup data.

Related Objects

As evidenced by its extensive foreign key relationships, AMS_CUSTOM_SETUPS_B is a pivotal parent table referenced by numerous objects across AMS and related modules like Trade Management (OZF) and Partner Management (PV). Key documented relationships include:

These relationships are typically joined on the child table's column referencing AMS_CUSTOM_SETUPS_B.CUSTOM_SETUP_ID, or in specific cases like events, the SETUP_TYPE_ID or USED_BY_ID columns.