Results for “asg_wireless_parameters”

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

Overview

The ASG_WIRELESS_PARAMETERS table resides in the ASG schema and belongs to the ASG - CRM Gateway for Mobile Devices product within Oracle E-Business Suite 12.1.1 and 12.2.2. Its documented purpose is to hold profile values for wireless — that is, the configurable runtime parameters that govern how a wireless or mobile synchronization session behaves between a mobile device client and the EBS back end. Each row defines a parameter set that is tied to a specific synchronization server through the SERVER_ID foreign key, allowing distinct tuning profiles to coexist for different servers deployed across the enterprise.

From a modeling perspective, the mined foreign-key structure classifies this object as satellite-leaning. This is a heuristic suggestion: the table does not appear to hold a broad shared business entity of its own, but rather descriptive, time-stamped attributes that hang off a parent entity — in this case the synchronization server. Under a Data Vault interpretation it behaves like a satellite attached to the server hub, with its surrogate key acting as the row identifier and the audit columns supporting change tracking.

Key Information Stored

The table is documented with 16 columns and a single-column primary key. Its most significant attributes fall into three groups: identity, connection context, and wireless timing/behavior control.

• WIRELESS_PARAMETERS_ID — the surrogate primary key defined by the constraint ASG_WIRELESS_PARAMETERS_PK, and also the sole documented unique index candidate (ASG_WIRELESS_PARAMETERS_U1). This is the row-level identifier used in all joins.
• SERVER_ID — the foreign key referencing ASG_SYNCH_SERVER, establishing which synchronization server owns this parameter set.
• SERVER_REMOTE_FLAG — indicates whether the associated server is remote, influencing connection topology.
• SEND_INTERVAL, SEND_DELAY, NUM_OF_RETRIES, TIME_BETWEEN_RETRIES — control the outbound transmission cadence and retry policy for wireless messages.
• TIME_TO_ACK and OUT_OF_COVERAGE — define acknowledgment timeouts and behavior when a device is outside network coverage.
• REPLICATION_INTERVAL — governs how frequently data replication cycles occur.
• TRANSACTION_HISTORY — controls the retention or tracking of transaction history for the session.
• SECURITY_GROUP_ID — a foreign key to FND_SECURITY_GROUPS, supporting multi-org security filtering.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE — standard EBS audit columns present on virtually all transactional configuration tables.

Common Use Cases and Queries

Administrators and integrators consult this table when diagnosing mobile synchronization problems, tuning retry behavior, or auditing configuration drift across servers. A typical lookup retrieves all wireless parameters bound to a known synchronization server:

• SELECT p.wireless_parameters_id, p.send_interval, p.send_delay, p.num_of_retries, p.time_between_retries, p.time_to_ack FROM asg.asg_wireless_parameters p WHERE p.server_id = :server_id;
• Joining to the server table to obtain a human-readable server name: SELECT w.*, s.* FROM asg.asg_wireless_parameters w, asg.asg_synch_server s WHERE w.server_id = s.server_id;
• Security-scoped reporting that filters by operating unit via SECURITY_GROUP_ID against FND_SECURITY_GROUPS.

Reporting scenarios commonly include a configuration audit report listing every parameter set per server, a retry/timeout analysis for troubleshooting delayed device synchronization, and a change-tracking query using LAST_UPDATE_DATE to find recently modified profiles.

Related Objects

The following objects are the most significant dependents and references for ASG_WIRELESS_PARAMETERS, based on the documented foreign-key relationships:

• ASG_SYNCH_SERVER — parent table referenced through ASG_WIRELESS_PARAMETERS.SERVER_ID; the primary master-detail relationship.
• FND_SECURITY_GROUPS — referenced through SECURITY_GROUP_ID; supplies the security group definition used for multi-org filtering.
• ASG_WIRELESS_PARAMETERS_PK — the primary key constraint on WIRELESS_PARAMETERS_ID.
• ASG_WIRELESS_PARAMETERS_U1 — the unique index on WIRELESS_PARAMETERS_ID, the documented business-key candidate.
• FND_USER / ASG application APIs — indirectly involved via the CREATED_BY and LAST_UPDATED_BY audit references and the ASG CRM Gateway for Mobile Devices module that consumes these parameters at synchronization time.

Because the table is satellite-leaning and tightly bound to a single server parent, joins should always be driven from ASG_SYNCH_SERVER or by a known WIRELESS_PARAMETERS_ID, with security filtering applied where operating-unit context is required.