Search Results asg_party_acc




Overview
Explore in AI Chat

Overview

The ASG_PARTY_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 store the accessibility permissions between the CRM Gateway server and business parties. The table acts as a control mechanism, indicating whether a specific gateway server instance is authorized to synchronize and access data for a given party. This is fundamental to the secure and partitioned operation of the mobile gateway, ensuring that data synchronization is correctly scoped and controlled across different server deployments and organizational entities.

Key Information Stored

The table's structure is defined by a composite primary key, which dictates the fundamental relationship it records. The two critical columns are SERVER_ID and PARTY_ID. The SERVER_ID column stores a unique identifier for a specific CRM Gateway server instance configured within the ASG_SYNCH_SERVER table. The PARTY_ID column stores the identifier for a party from the Trading Community Architecture (TCA) registry. The existence of a record for a given SERVER_ID and PARTY_ID pair signifies that the gateway server has been granted access to that party's data for synchronization purposes to mobile devices. The absence of a record implies the server cannot access that party.

Common Use Cases and Queries

A primary use case is the validation check performed by the gateway server during synchronization requests. Before processing data for a party, the server logic will query this table to confirm authorization. Administrators use this table to manage the deployment model, such as provisioning a new gateway server with access to a specific set of subsidiaries or business units (represented as parties). Common reporting needs include auditing which servers have access to which parties and identifying parties that are not currently accessible by any gateway server. A typical query would join with the TCA party tables to resolve party names.

SELECT apa.server_id, apa.party_id, hp.party_name
FROM asg.asg_party_acc apa,
     hz_parties hp
WHERE apa.party_id = hp.party_id
  AND apa.server_id = :p_server_id;

Related Objects

The table maintains a direct foreign key relationship with the ASG_SYNCH_SERVER table, which is its principal parent object. This relationship enforces referential integrity, ensuring that every SERVER_ID recorded in ASG_PARTY_ACC corresponds to a valid, configured gateway server.

  • ASG_SYNCH_SERVER: The parent table containing the master list of gateway servers. The relationship is defined as ASG_PARTY_ACC.SERVER_ID references ASG_SYNCH_SERVER.

Furthermore, the PARTY_ID column is a foreign key to the HZ_PARTIES table in the TCA schema, linking the access control record to the actual business entity (organization, person, group) within Oracle EBS, though this specific foreign key constraint may not be explicitly documented in the provided ASG metadata.