Search Results align_acct_id

Overview

The JTF_TTY_ALIGN_ACCTS table is a core data object within the Oracle E-Business Suite CRM Foundation (JTF) module. It functions as a junction table that stores the specific account assignments within a territory alignment. An alignment defines the mapping of resources, such as sales representatives, to territories and the accounts contained within them. This table is therefore critical for implementing and managing complex sales territory structures, enabling the precise association of customer accounts to defined alignments for purposes of assignment, reporting, and access control in releases 12.1.1 and 12.2.2.

Key Information Stored

The table's primary purpose is to maintain the relationship between an alignment, a territory group account, and the resulting aligned account record. Its structure is defined by key foreign key columns that establish these links. The primary identifier for each record is the ALIGN_ACCT_ID. The ALIGNMENT_ID column links the record to its parent alignment definition in the JTF_TTY_ALIGNMENTS table. The TERR_GROUP_ACCOUNT_ID column references a specific account within a territory group from the JTF_TTY_TERR_GRP_ACCTS table. This design allows a single alignment to encompass multiple accounts, with each account's inclusion recorded as a distinct row in this table.

Common Use Cases and Queries

This table is central to territory management operations and related reporting. A common use case is generating a list of all accounts assigned to a specific sales alignment for territory validation or compensation planning. Administrators may query this table to audit account coverage or troubleshoot assignment issues. A typical reporting query would join this table to JTF_TTY_ALIGNMENTS for alignment details and to HZ_PARTIES (via the account reference in JTF_TTY_TERR_GRP_ACCTS) for customer information. For example, to find all accounts in a given alignment named 'Q2_EAST_SALES':

• SELECT hzp.party_name, acct.ALIGN_ACCT_ID FROM JTF_TTY_ALIGN_ACCTS acct, JTF_TTY_ALIGNMENTS align, JTF_TTY_TERR_GRP_ACCTS tgacct, HZ_PARTIES hzp WHERE acct.ALIGNMENT_ID = align.ALIGNMENT_ID AND acct.TERR_GROUP_ACCOUNT_ID = tgacct.TERR_GROUP_ACCOUNT_ID AND tgacct.CUST_ACCOUNT_ID = hzp.party_id AND align.NAME = 'Q2_EAST_SALES';

Related Objects

The JTF_TTY_ALIGN_ACCTS table sits at the intersection of several key territory management entities, as documented by its foreign key relationships.

• Parent References (Foreign Keys from JTF_TTY_ALIGN_ACCTS):
  • JTF_TTY_ALIGNMENTS: Linked via the ALIGNMENT_ID column. This is the master alignment definition.
  • JTF_TTY_TERR_GRP_ACCTS: Linked via the TERR_GROUP_ACCOUNT_ID column. This provides the source account from a territory group.
• Child References (Foreign Keys to JTF_TTY_ALIGN_ACCTS):
  • JTF_TTY_PTERR_ACCTS: This table references JTF_TTY_ALIGN_ACCTS via its ALIGN_ACCT_ID column, indicating that aligned accounts are further utilized in personal territory account assignments.