Results for “asg_synch_server”

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

Overview

The ASG.ASG_SYNCH_SERVER table is a core configuration object within the ASG – CRM Gateway for Mobile Devices product, a component shipped with Oracle E-Business Suite 12.1.1 and 12.2.2. The table stores the definition of each Mobile Device Gateway synchronization server known to the EBS instance, describing how the middle-tier gateway communicates with the Oracle database and with connected handheld devices. Its documented description in the ETRM repository is simply "Information about all the Mobile Device Gateway," confirming that it acts as the master registry of gateway server endpoints.

From a data-modeling perspective, the ETRM metadata classifies ASG_SYNCH_SERVER as hub-leaning under a heuristic Data Vault assessment. This classification is a modeling suggestion rather than a functional label: the table carries a single-column surrogate primary key (SERVER_ID) and is referenced by many dependent tables through that key, which is characteristic of a hub entity surrounded by satellite and link tables. In practice, within the ASG product it behaves as a parent/master table whose rows are enumerated by access, resource, publication, and wireless-parameter child tables.

Key Information Stored

The table contains 19 documented columns in the 12.2.2 physical schema, owned by the ASG schema. The most significant columns include:

• SERVER_ID — the surrogate primary key, enforced by ASG_SYNCH_SERVER_PK and also carried by the unique index ASG_SYNCH_SERVER_U1. This is the column used by all child tables as their foreign key.
• HOST_NAME, PORT_NUMBER, ORACLE_SID — connection coordinates identifying the database instance and listener endpoint that the gateway server addresses.
• NETWORK_PROTOCOL, MOBILE_SERVER_URL — the transport protocol and the published URL used by mobile clients to reach the synchronization server.
• SNAP_DATABASE — reference to the snapshot/database context associated with the gateway.
• WIRELESS_FLAG, ENABLED — status flags indicating whether the server is active for wireless traffic and whether it is enabled for use.
• CONS_PASSWORD, ADMIN_PASSWORD — stored credentials for consumer and administrative connections to the gateway.
• DESCRIPTION — free-text identification of the server.
• VERSION_ID — foreign key to VEA_VERSIONS, tying the server record to a version definition.
• SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS, enforcing multi-org style data security.
• LANGUAGE — the language context of the record.
• Audit columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY.

The surrogate key is SERVER_ID; because ASG_SYNCH_SERVER_U1 is also built on SERVER_ID, no separate natural business key is documented beyond the surrogate itself.

Common Use Cases and Queries

Typical operational and reporting scenarios involve listing active gateway servers, auditing connectivity parameters, and joining child configuration tables back to their parent server.

SELECT server_id, host_name, port_number, oracle_sid,
       network_protocol, enabled, wireless_flag
FROM   asg.asg_synch_server
WHERE  enabled = 'Y';

To resolve the version associated with each gateway:

SELECT s.server_id, s.host_name, v.version_name
FROM   asg.asg_synch_server s,
       vea.vea_versions    v
WHERE  s.version_id = v.version_id;

A common diagnostic pattern joins the server to its wireless parameters and resources to confirm that each gateway is fully provisioned. Administrators also query CONFIG columns to verify that published URLs match the deployed middle-tier endpoints, and use SECURITY_GROUP_ID filtering when multiple operating units share the instance.

Related Objects

ASG_SYNCH_SERVER is a parent to numerous ASG tables that reference it through SERVER_ID, and a child to two foreign tables:

• ASG_DEVICE_USERS (SERVER_ID) — associates registered device users with a gateway server.
• ASG_SERVER_RESOURCES (SERVER_ID) — resources provisioned on each server.
• ASG_SERVER_PUBS (SERVER_ID) — publications distributed by the server.
• ASG_WIRELESS_PARAMETERS (SERVER_ID) — wireless communication settings per server.
• ASG_PARTY_ACC, ASG_PARTY_SITE_ACC, ASG_LOCATION_ACC, ASG_INCIDENT_ACC, ASG_TASK_ACC (all SERVER_ID) — access mappings that scope party, site, location, incident, and task data to a specific gateway.
• VEA_VERSIONS — referenced by ASG_SYNCH_SERVER.VERSION_ID.
• FND_SECURITY_GROUPS — referenced by ASG_SYNCH_SERVER.SECURITY_GROUP_ID.