Results for “ar_collectors”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

AR_COLLECTORS is a Receivables (AR) reference table in the Oracle E-Business Suite that stores master information about collection agents (collectors) used throughout the credit and collections process. Each row represents a single collector who can be assigned to customers, customer profile classes, payment schedules, calls, claims, and interest invoices. The table is owned by the AR schema and is validated in both EBS 12.1.1 and 12.2.2. Its documented physical schema comprises 32 columns. Under the heuristic Data Vault classification mined from the foreign key structure, AR_COLLECTORS is a hub-leaning entity: it serves as a business-key-anchored center of reference for collector identity, with the surrounding AR and HZ tables acting as satellites and links tracking collector assignment, customer relationships, and transactional history. The unique key AR_COLLECTORS_UK1 on NAME is the primary business-key access path that most users encounter in the application, including any lookup against the user-facing object name ar_collectors_uk1.

Key Information Stored

The surrogate primary key is COLLECTOR_ID, defined by the AR_COLLECTORS_PK constraint. The unique index AR_COLLECTORS_UK1 enforces uniqueness on NAME, the collector's display name, which is the principal business-key candidate. In multi-tenant or editioned environments, AR_COLLECTORS_U1 on (COLLECTOR_ID, ZD_EDITION_NAME) is also documented. Other significant columns include:

• EMPLOYEE_ID — links the collector to the PSB_EMPLOYEES source, tying collection agents to HR records.
• RESOURCE_ID and RESOURCE_TYPE — associate the collector with a resource in JTF_RS_RESOURCE_EXTNS and JTF_RS_GROUPS_B, integrating collections with the resource (telephony/service) model.
• STATUS and INACTIVE_DATE — control the active/inactive lifecycle of a collector.
• ALIAS and TELEPHONE_NUMBER — secondary identification and contact data.
• DESCRIPTION — free-form notes.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — the standard Oracle flexfield (descriptive flexfield) columns for customer-specific extension.
• Audit columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN provide change tracking.

Common Use Cases and Queries

The primary operational use is assigning collectors to customers, profile classes, and payment schedules. A common reporting query resolves the collector name for a customer's open balances:

SELECT c.name, c.alias, c.status, ps.invoice_currency_code, ps.amount_due_remaining
FROM   ar_payment_schedules_all ps, ar_collectors c
WHERE  ps.collector_last = c.collector_id
AND    c.status = 'A';

Another typical pattern lists active collectors with their resource and employee associations for a collections worklist:

SELECT a.name, a.alias, a.telephone_number, r.resource_name
FROM   ar_collectors a, jtf_rs_resource_extns r
WHERE  a.resource_id = r.resource_id(+)
AND    a.status = 'A';

Collector-level metrics — number of customers assigned, open calls, and claims — are built by joining through AR_CUSTOMER_PROFILES and AR_CUSTOMER_CALLS_ALL. The descriptive flexfield attributes are frequently used to store territory or team codes used for collection strategy reporting.

Related Objects

The most significant surrounding tables and dependencies include:

• AR_CUSTOMER_PROFILES / AR_CUSTOMER_PROFILE_CLASSES — reference the collector via COLLECTOR_ID to define default collection agents at the profile and class level.
• AR_PAYMENT_SCHEDULES_ALL — tracks the last assigned collector through COLLECTOR_LAST, driving open-item assignment.
• AR_CUSTOMER_CALLS_ALL / AR_CUSTOMER_CALL_TOPICS_ALL — record collections activity linked by COLLECTOR_ID.
• JTF_RS_RESOURCE_EXTNS / JTF_RS_GROUPS_B — source resources that AR_COLLECTORS.RESOURCE_ID references.
• PSB_EMPLOYEES — source employees via EMPLOYEE_ID.
• AR_INTEREST_HEADERS_ALL — stores the collector responsible for interest invoices via COLLECTOR_ID.
• HZ_CUSTOMER_PROFILES / HZ_CUST_PROFILE_CLASSES — the trading-community counterparts that also carry collector references.

Because AR_COLLECTORS is referenced by many transactional and history tables (claims, interest, summary/fact tables in the FII and OZF schemas), changes to a collector record are visible across the entire credit-to-collections reporting chain.