Results for “ar_cmgt_reassign_conc”

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

Overview

The APPS.AR_CMGT_REASSIGN_CONC package is a PL/SQL database object within the Oracle E-Business Suite Receivables (AR) module, specifically belonging to the Credit Management (CMGT) functional area. Its documented purpose is to support the reassignment of credit management responsibilities among credit analysts. In Oracle Credit Management, cases, credit requests, and the associated customer profile data are owned by specific credit analysts. When personnel changes occur — such as an analyst leaving the organization, changing roles, or when workload balancing is required — the ownership of those open credit management records must be transferred to another analyst. This package provides the server-side logic that performs that reassignment across the relevant credit management entities.

The package resides in the APPS schema and is reported as VALID in the ETRM metadata for both Oracle EBS 12.1.1 and 12.2.2. It is classified as an OTHER API, meaning it is not a formally published public API, but rather an internal utility used by the application components that administer Credit Management.

Key Procedures and Functions

The documented metadata lists a single procedure for this package:

• REASSIGN_CREDIT_ANALYST — This is the sole documented procedure in the package. Its purpose is to reassign the credit analyst associated with credit management records from one analyst to another. It encapsulates the update logic required to move ownership of the relevant credit management entities so that the new analyst assumes responsibility for the affected cases and credit requests. The ETRM metadata does not publish the formal parameter list for this procedure, and no parameter signature should be assumed.

Tables Accessed

Based on the documented dependencies, the procedure interacts with the following tables, referenced through APPS synonyms:

• AR_CMGT_CASE_FOLDERS — Stores the credit management case folders that group credit review activity. Reassignment updates the analyst assignment recorded on these folders so that case ownership transfers to the new analyst.
• AR_CMGT_CREDIT_REQUESTS — Holds the individual credit requests submitted for customers. The procedure updates the owning analyst on these request records to reflect the reassignment.
• HZ_CUSTOMER_PROFILES — Contains the customer profile information, including credit profile attributes used by Credit Management. Access to this table supports the association of credit analyst ownership with customer-level profile data.

The package also depends on the SYS STANDARD package, which every PL/SQL program unit references implicitly.

Usage Notes

Because the API is classified as OTHER rather than a published public interface, it is typically invoked from within Oracle Credit Management application components rather than being called directly by external integrations. In practice, administrators reassigning credit analysts execute the corresponding Credit Management function from the application user interface, which in turn drives this package logic. The procedure may also be referenced by the package's own specification and body, as the metadata indicates AR_CMGT_REASSIGN_CONC references itself.

The metadata records that the package is referenced by zero other packages, indicating that its callers are not other documented PL/SQL APIs but application-layer components. When planning a reassignment, technical teams should perform it while the affected credit management records are not under concurrent edit, and should validate that both the source and target analysts hold the appropriate credit management responsibilities. As with any unsupported API, direct invocation carries upgrade risk, and behavior should be verified against the target release.