Search Results asg_subscription_params




Overview
Explore in AI Chat

Overview

The ASG_SUBSCRIPTION_PARAMS table is a core data object within the Oracle E-Business Suite module ASG - CRM Gateway for Mobile Devices. It functions as a parameter store for mobile data synchronization subscriptions. In the context of Oracle EBS 12.1.1 and 12.2.2, the ASG (Applications Sales and Service Gateway) framework enables the synchronization of CRM data, such as opportunities and service requests, to mobile devices. This table specifically holds the configurable parameters that define the behavior and scope of a data subscription, acting as a child entity that provides detailed runtime settings for a parent publication definition.

Key Information Stored

While the provided ETRM excerpt does not list specific columns, the table's description and foreign key relationship indicate its structure. Based on its role, the table typically contains columns such as SUBSCRIPTION_PARAM_ID (primary key), PUBLICATION_ID (foreign key linking to ASG_PUBLICATIONS), PARAMETER_NAME, and PARAMETER_VALUE. These columns store name-value pairs that fine-tune a subscription. Example parameters could include data filters (e.g., a specific salesperson ID), synchronization frequency settings, or flags controlling conflict resolution rules for mobile updates. The table essentially holds the executable configuration for a mobile data feed.

Common Use Cases and Queries

Primary use cases involve the administration and troubleshooting of mobile synchronization setups. An administrator may query this table to audit or modify the parameters for all subscriptions related to a specific publication. A common diagnostic query is to join with the publication table to see all parameters for a problematic subscription.

  • Sample Query: To list all parameters for a publication named 'MOB_OPP_SYNC':
    SELECT sp.parameter_name, sp.parameter_value
    FROM asg_subscription_params sp, asg_publications p
    WHERE sp.publication_id = p.publication_id
    AND p.publication_name = 'MOB_OPP_SYNC';
  • Data in this table is primarily managed by the ASG framework's administrative functions and underlying APIs during the subscription creation and modification processes, rather than through direct DML.

Related Objects

The table has a direct and documented foreign key relationship, making it a critical child table in the ASG synchronization schema.

  • ASG_PUBLICATIONS: This is the primary related table. The foreign key ASG_SUBSCRIPTION_PARAMS.PUBLICATION_ID references ASG_PUBLICATIONS. A publication defines the high-level data set (e.g., "Service Requests") to be synchronized, while the parameters in this table provide the specific instance-level configuration for that publication.

This relationship is fundamental; subscription parameters are meaningless without the parent publication definition. Other related objects would likely include the central subscription table (e.g., ASG_SUBSCRIPTIONS) and the various ASG runtime engine packages that read these parameters to execute the synchronization jobs.