Search Results asg_publications




Overview
Explore in AI Chat

Overview

The ASG_PUBLICATIONS table is a core data repository within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the ASG - CRM Gateway for Mobile Devices product. This module, often referred to as iConnect, facilitates the synchronization of CRM data between the central EBS database and mobile devices. The table's primary role is to serve as the master list or registry for all defined publication names. In the context of mobile data synchronization, a publication is a predefined set of data (e.g., customer contacts, tasks, opportunities) that can be subscribed to and downloaded by a mobile device. This table is therefore fundamental to the configuration and management of the mobile data distribution framework.

Key Information Stored

While the provided ETRM metadata does not list individual column details, the table's primary key is documented as PUBLICATION_ID. This column uniquely identifies each publication record. Based on the table's description and standard EBS design patterns, the table likely stores the publication's unique identifier (PUBLICATION_ID), its name, a descriptive meaning, and potentially status flags (e.g., Active/Inactive) and timestamps for creation and last update. The central purpose is to maintain a controlled list of available data publications that other components of the CRM Gateway can reference.

Common Use Cases and Queries

This table is primarily accessed for administrative configuration, troubleshooting, and reporting on the mobile synchronization setup. Common operational scenarios include verifying the existence of a publication before assigning it to a user or device, generating a list of all active publications, and auditing publication usage. A typical query would involve joining with related tables to see which publications are mapped to specific data items or subscribed to by users. A fundamental reporting query would be:

  • SELECT publication_id, publication_name, creation_date FROM asg.asg_publications WHERE enabled_flag = 'Y' ORDER BY publication_name;

Database administrators or functional implementers might query this table to resolve foreign key constraint errors during data purges or to understand dependencies before modifying a publication definition.

Related Objects

The ASG_PUBLICATIONS table has several documented foreign key relationships, indicating it is a central hub in the CRM Gateway schema. The primary key (PUBLICATION_ID) is referenced by the following tables, as per the provided metadata:

  • ASG_MAP_PUB_ITEMS: Links publications to the specific data items (tables, columns) they contain via ASG_MAP_PUB_ITEMS.PUBLICATION_ID.
  • ASG_SEQUENCES: Tracks synchronization sequence numbers per publication via ASG_SEQUENCES.PUBLICATION_ID to manage data change capture.
  • ASG_SUBSCRIPTION_PARAMS: Stores parameters for user or device subscriptions to a publication via ASG_SUBSCRIPTION_PARAMS.PUBLICATION_ID.
  • ASG_SERVER_PUBS: Likely manages server-side publication properties or status via ASG_SERVER_PUBS.PUBLICATION_ID.

These relationships confirm that the ASG_PUBLICATIONS table is the parent record for defining what data is published, how its changes are tracked, and how it is subscribed to within the mobile synchronization architecture.