Search Results device_user_id




Overview
Explore in AI Chat

Overview

The ASG_DEVICE_USERS table is a core data object within the Oracle E-Business Suite (EBS) module ASG - CRM Gateway for Mobile Devices. It functions as the central repository for mapping and managing mobile application users, specifically resources like field service engineers or sales personnel, to their associated mobile devices and applications. Its primary role is to facilitate the synchronization and data exchange framework between the central EBS database and mobile applications, enabling offline and remote operations. The table maintains the critical link between a user's EBS identity, their assigned mobile resource profile, and the specific mobile application instance they utilize.

Key Information Stored

While the specific column list is not detailed in the provided metadata, the documented foreign key relationships explicitly define the key reference columns and the core data entities they link. The primary identifier is the DEVICE_USER_ID. The table stores the foreign key USER_ID, which links to the FND_USER table to associate a mobile user with their standard EBS login identity. The RESOURCE_ID column links to JTF_RS_RESOURCE_EXTNS, connecting the user to their detailed resource definition within the CRM Resource Manager. The MOBILE_APPLICATION_ID references ASG_APPLICATIONS_B, defining which mobile application (e.g., for field service, sales) the user is configured to use. Finally, the SERVER_ID links to ASG_SYNCH_SERVER, indicating the synchronization server instance responsible for managing this user's data replication.

Common Use Cases and Queries

This table is central to administration and troubleshooting of the mobile gateway. Common use cases include generating user access reports for mobile deployments, auditing which resources are enabled for specific applications, and diagnosing synchronization failures by examining user-server mappings. A typical administrative query would join ASG_DEVICE_USERS with FND_USER and JTF_RS_RESOURCE_EXTNS to list all active mobile users with their names and resource numbers. Support personnel might query this table to identify users associated with errors logged in the ASG_ERROR table. Developers customizing mobile data sets would reference it to understand the user context for filtering transactional data during synchronization.

Related Objects

The ASG_DEVICE_USERS table maintains integral relationships with several other EBS objects, as documented by its foreign key constraints.

  • Referenced Tables (Parent Tables):
    • FND_USER via USER_ID: Provides the standard EBS user account details.
    • JTF_RS_RESOURCE_EXTNS via RESOURCE_ID: Provides the CRM resource details (e.g., engineer, salesperson).
    • ASG_APPLICATIONS_B via MOBILE_APPLICATION_ID: Defines the mobile application.
    • ASG_SYNCH_SERVER via SERVER_ID: Identifies the synchronization server.
  • Referencing Tables (Child Tables):
    • ASG_ERROR via DEVICE_USER_ID: Error records logged for a specific mobile user.
    • ASG_FLASH_RECIPIENTS via DEVICE_USER_ID: Records indicating users designated to receive flash (urgent) notifications.