Search Results server_pubs_id_pk

Overview

The ASG_SERVER_PUBS table is a core data object within the ASG (CRM Gateway for Mobile Devices) product family of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It functions as a junction or mapping table within the CRM Gateway architecture, which facilitates data synchronization between the central EBS database and mobile devices. Its primary role is to manage the assignment and relationship between available synchronization servers (ASG_SYNCH_SERVER) and the specific data publications (ASG_PUBLICATIONS) that are configured for distribution. This table is essential for defining which publications are served by which synchronization endpoints, thereby controlling the flow of mobile data.

Key Information Stored

The table's structure centers around its primary and foreign key columns, which establish critical relationships. The primary identifier is the SERVER_PUBS_ID column, which is enforced by the SERVER_PUBS_ID_PK primary key constraint. The two pivotal foreign key columns are PUBLICATION_ID, which references a specific data publication definition in the ASG_PUBLICATIONS table, and SERVER_ID, which references a configured synchronization server in the ASG_SYNCH_SERVER table. Together, each record in ASG_SERVER_PUBS represents a single, active association between a server and a publication, enabling the gateway system to route synchronization requests appropriately.

Common Use Cases and Queries

A primary use case is administrative reporting and troubleshooting of the mobile synchronization landscape. Database administrators and functional implementers query this table to audit which publications are enabled on which servers, identify publications without an assigned server, or list all servers responsible for a particular publication. A common diagnostic query would join to the related tables to provide a readable report:

• SELECT s.server_name, p.publication_name FROM asg_server_pubs sp JOIN asg_synch_server s ON sp.server_id = s.server_id JOIN asg_publications p ON sp.publication_id = p.publication_id ORDER BY s.server_name;

Another critical operational use case is during the setup or modification of a mobile deployment, where inserts, updates, or deletions in this table directly configure the synchronization topology.

Related Objects

The ASG_SERVER_PUBS table maintains documented foreign key relationships with two other key tables in the ASG schema, forming the backbone of the synchronization configuration model.

• ASG_PUBLICATIONS: The relationship is defined by the foreign key on the ASG_SERVER_PUBS.PUBLICATION_ID column referencing the ASG_PUBLICATIONS table. This links a server-publication assignment to the master definition of the data publication.
• ASG_SYNCH_SERVER: The relationship is defined by the foreign key on the ASG_SERVER_PUBS.SERVER_ID column referencing the ASG_SYNCH_SERVER table. This links the assignment to the physical or logical synchronization server instance.

These relationships are essential for maintaining referential integrity and for any joins performed to retrieve descriptive information about the assigned servers and publications.