Search Results as_changed_accounts_all




Overview
Explore in AI Chat

Overview

The AS_CHANGED_ACCOUNTS_ALL table is a core data repository within the Oracle E-Business Suite Sales Foundation module (AS). Its primary function is to track and store records of accounts (customer or prospect entities) that have undergone significant changes. This table operates as a critical audit and synchronization mechanism, enabling downstream processes, such as territory management, lead assignment, and data enrichment workflows, to identify and act upon modified account information. It is a multi-org table, as indicated by the '_ALL' suffix, meaning it stores data for all operating units and requires a security predicate, such as ORG_ID, for proper querying in a multi-organization environment.

Key Information Stored

The table's structure is designed to link changed account records to their source entities through foreign key relationships. While the provided metadata does not list all columns, the primary and foreign keys define its essential data points. The primary key is a composite of ADDRESS_ID and LEAD_ID, indicating a granular level of tracking potentially down to the address and lead level. Key foreign key columns include CUSTOMER_ID, linking to the Trading Community Architecture's HZ_PARTIES table to identify the specific customer or prospect party. The ADDRESS_ID links to HZ_PARTY_SITES, and LEAD_ID and SALES_LEAD_ID link to the AS_LEADS_ALL and AS_SALES_LEADS tables, respectively. This structure suggests the table captures changes related to a party's involvement in sales lead processes across different addresses.

Common Use Cases and Queries

A primary use case is triggering territory reassignment or notification workflows when a key account attribute, such as location (address) or industry classification, is updated. System processes or concurrent programs likely poll this table to batch-process changes. For reporting, analysts may query it to generate metrics on account volatility or change frequency. A typical query would join to the related party and lead tables to extract meaningful information.

SELECT acc.*, party.party_name, lead.status_code
FROM osm.as_changed_accounts_all acc,
     hz_parties party,
     as_leads_all lead
WHERE acc.customer_id = party.party_id
AND   acc.lead_id = lead.lead_id
AND   acc.org_id = :p_org_id;

Administrators might also periodically archive or purge processed records from this table to manage its growth.

Related Objects

The AS_CHANGED_ACCOUNTS_ALL table is centrally connected to several key EBS entities, as defined by its foreign keys:

  • AS_LEADS_ALL / AS_SALES_LEADS: These are the primary source tables for sales lead information. The changed accounts table references leads to which the account change is relevant.
  • HZ_PARTIES: The master table for all customer, prospect, and organization entities in the Trading Community Architecture (TCA) model. This link identifies the core account that changed.
  • HZ_PARTY_SITES: The TCA table storing address information for parties. The link via ADDRESS_ID specifies the particular location associated with the change.

These relationships position AS_CHANGED_ACCOUNTS_ALL as an integration point between the Sales Foundation lead management system and the enterprise-wide TCA customer model, facilitating coordinated data flow.