Search Results asg_incident_acc_pk

Overview

The ASG_INCIDENT_ACC table is a core data object within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the ASG - CRM Gateway for Mobile Devices product module. Its primary function is to manage and record the accessibility permissions between the CRM Gateway server and individual service requests (incidents). The table acts as a junction or control mechanism, storing a record to indicate whether a specific gateway server instance is authorized to access and synchronize data for a particular service request. This is critical for enabling secure, controlled data synchronization of service request information to and from mobile devices in a distributed deployment where multiple gateway servers may be present.

Key Information Stored

The table's structure is designed to map two key identifiers. The primary key is a composite of the INCIDENT_ID and SERVER_ID columns, enforcing a unique relationship between a service request and a gateway server. The INCIDENT_ID column stores the unique identifier for a service request, typically corresponding to the INCIDENT_ID from the CRM Service module (e.g., from the CS_INCIDENTS_ALL_B table). The SERVER_ID column stores the identifier for a specific CRM Gateway server, which references a record in the ASG_SYNCH_SERVER table. Each row essentially represents a permission grant, signifying that the gateway server denoted by SERVER_ID has access to the service request denoted by INCIDENT_ID.

Common Use Cases and Queries

The primary use case revolves around the gateway server's synchronization engine. Before transmitting service request data to a mobile device, the gateway queries this table to verify it has the requisite access rights. A common administrative query would be to audit access permissions for troubleshooting synchronization issues. For example, to list all service requests accessible to a specific gateway server, one might use: SELECT incident_id FROM asg.asg_incident_acc WHERE server_id = <SERVER_ID_VALUE>;. Conversely, to identify which gateway servers can access a particular service request: SELECT server_id FROM asg.asg_incident_acc WHERE incident_id = <INCIDENT_ID_VALUE>;. Reporting on the total number of access grants per server is another typical pattern for monitoring system load and distribution.

Related Objects

The ASG_INCIDENT_ACC table maintains a direct foreign key relationship with the ASG_SYNCH_SERVER table, which is central to the CRM Gateway architecture. The relationship is defined as follows:

• Foreign Key from ASG_INCIDENT_ACC to ASG_SYNCH_SERVER: The SERVER_ID column in ASG_INCIDENT_ACC references the primary key of the ASG_SYNCH_SERVER table. This ensures that every access record points to a valid, configured gateway server instance.

While not explicitly listed in the provided metadata, the INCIDENT_ID column logically relates to the service request entities in the CRM Foundation tables, such as CS_INCIDENTS_ALL_B. The table's primary key constraint, ASG_INCIDENT_ACC_PK, enforces data integrity for the core INCIDENT_ID and SERVER_ID combination.