Search Results asg_flash_recipients




Overview
Explore in AI Chat

Overview

The ASG_FLASH_RECIPIENTS table is a core data object within the Oracle E-Business Suite module ASG - CRM Gateway for Mobile Devices. It functions as the junction table that manages the association between flash messages and their intended recipients. Its primary role is to store the subscription or delivery records for real-time notifications, known as flash messages, sent to mobile device users registered within the CRM Gateway ecosystem. This table is essential for the targeted dissemination of alerts and updates, enabling the mobile application framework to track which users are designated to receive specific messages.

Key Information Stored

The table's structure is designed to link messages to users via foreign key relationships. The primary key, MOBILE_FLASH_SUBS_ID, uniquely identifies each recipient record for a flash message. Two critical foreign key columns establish the core relationships: the FLASH_ID column references a specific message in the ASG_FLASH_MESSAGES table, and the DEVICE_USER_ID column references a registered mobile user in the ASG_DEVICE_USERS table. While the provided metadata does not list additional columns, typical implementations in this context might include status flags (e.g., SENT_STATUS, READ_DATE), delivery timestamps, or error codes to manage the message lifecycle.

Common Use Cases and Queries

This table is central to operations involving mobile notification history and auditing. Common use cases include generating delivery reports for sent flash messages, troubleshooting failed notifications, and purging historical recipient data for compliance. A frequent query pattern involves joining to related tables to get a comprehensible report. For example, to list all recipients for a specific message, one might use:

  • SELECT du.USER_NAME, afr.* FROM ASG_FLASH_RECIPIENTS afr JOIN ASG_DEVICE_USERS du ON afr.DEVICE_USER_ID = du.DEVICE_USER_ID WHERE afr.FLASH_ID = <message_id>;

Conversely, to find all messages sent to a particular device user:

  • SELECT afm.MESSAGE_SUBJECT, afr.* FROM ASG_FLASH_RECIPIENTS afr JOIN ASG_FLASH_MESSAGES afm ON afr.FLASH_ID = afm.FLASH_ID WHERE afr.DEVICE_USER_ID = <user_id>;

Related Objects

The ASG_FLASH_RECIPIENTS table has defined dependencies on two primary tables, as per the provided relationship data. It is a child table to both ASG_FLASH_MESSAGES and ASG_DEVICE_USERS.

  • ASG_FLASH_MESSAGES: This is the parent table for flash message definitions. The relationship is established via the foreign key constraint where ASG_FLASH_RECIPIENTS.FLASH_ID references the primary key of ASG_FLASH_MESSAGES. This join retrieves the message content and metadata.
  • ASG_DEVICE_USERS: This is the parent table for registered mobile application users. The relationship is established via the foreign key constraint where ASG_FLASH_RECIPIENTS.DEVICE_USER_ID references the primary key of ASG_DEVICE_USERS. This join retrieves the recipient's user identity and device information.