Search Results xtr_company_authorities_pk

Overview

The XTR_COMPANY_AUTHORITIES table is a core security and access control object within the Oracle E-Business Suite (EBS) Treasury module (XTR). It functions as a mapping table that defines and enforces user access permissions at the company level. Its primary role is to establish which dealers (users) are authorized to view, enter, or process transactions for specific treasury entities or counterparties (parties). This table is essential for maintaining segregation of duties, operational control, and data security within the treasury function, ensuring users can only interact with data for companies they are explicitly permitted to access.

Key Information Stored

The table's structure is relatively simple, consisting of two key columns that form a composite primary key, establishing a direct relationship between a user and a company. The DEALER_CODE column stores the identifier for a treasury dealer or user, typically linked to the system's user or employee master data. The PARTY_CODE column stores the identifier for a company, which represents either an internal legal entity or an external counterparty within the treasury system. The existence of a record in this table signifies that the dealer specified by DEALER_CODE has the authority to perform treasury operations for the company specified by PARTY_CODE. The absence of a record explicitly denies such access.

Common Use Cases and Queries

A primary use case is the validation of user authority during transaction entry. Before a dealer can book a deal for a specific company, the application logic will query this table to confirm authorization. This is also critical for generating company-specific reports and dashboards, filtering data to only show authorized entities. Common queries include listing all companies a specific dealer can access, or identifying all dealers authorized for a particular company for audit or support purposes.

• To find all companies accessible to a specific dealer: SELECT PARTY_CODE FROM XTR_COMPANY_AUTHORITIES WHERE DEALER_CODE = '&DEALER';
• To find all dealers authorized for a specific company: SELECT DEALER_CODE FROM XTR_COMPANY_AUTHORITIES WHERE PARTY_CODE = '&PARTY';
• To audit a user's full access profile, joining to descriptive tables: SELECT d.DEALER_NAME, p.NAME FROM XTR_COMPANY_AUTHORITIES ca, XTR_DEALER_CODES d, XTR_PARTY_INFO p WHERE ca.DEALER_CODE = d.DEALER_CODE AND ca.PARTY_CODE = p.PARTY_CODE ORDER BY 1,2;

Related Objects

XTR_COMPANY_AUTHORITIES has defined relationships with two primary master data tables via foreign key constraints, as documented in the ETRM. The DEALER_CODE column references the XTR_DEALER_CODES table, which holds detailed information about treasury users. The PARTY_CODE column references the XTR_PARTY_INFO table, the central repository for all internal and external entities (companies, banks, counterparties) within the Treasury module. This table is also a likely parent or reference point for various treasury transaction tables and views that enforce company-level data access, though these are not explicitly listed in the provided metadata. Its integrity is maintained by the primary key constraint XTR_COMPANY_AUTHORITIES_PK.