Search Results arp_process_cutil




Overview
Explore in AI Chat

Overview

ARP_PROCESS_CUTIL is an Oracle Receivables utility package owned by the APPS schema and classified by ETRM as an "OTHER" API. Its name derives from "AR Process Customer Util," and its role is to centralize low-level update logic for the Receivables payment schedule and transaction summary data that underpins collections and customer account processing. The package exposes a small, focused set of procedures that are called from user-facing collections windows and from other Receivables modules rather than being invoked directly by end users.

The package header carries a header comment referencing ARCEUTLS.pls revision 120.2 (2005/10/30), with a documented modification history entry dated 27-FEB-02 by Pravin Pawar adding the update_ps_fdate procedure under Bug 2218144. That change introduced the ability to write the follow_up_date_last value into the payment schedules table directly from the customer call window, reflecting the package's long-standing role as a supporting utility for collections-related desktop forms.

Key Procedures and Functions

ETRM documents four procedures for this package; two are confirmed by name in the published source excerpt and metadata:

  • UPDATE_PS — Updates an existing row in AR_PAYMENT_SCHEDULES. The documented signature includes the payment schedule identifier, due date, amount in dispute, dispute date, a flag controlling descriptive flexfield updates, the full attribute category and attribute1 through attribute15 columns, and optional collections fields for staged dunning level and dunning level override date. A global attribute category parameter follows, indicating support for global descriptive flexfield segments. The procedure centralizes the write of dispute, dunning, and DFF data so that callers do not update the base table directly.
  • UPDATE_PS_FDATE — Updates the follow-up date last (follow_up_date_last) on the payment schedule record. Added under Bug 2218144, it is invoked from the customer call window to stamp the most recent follow-up activity against the appropriate payment schedule.
  • Two additional procedures are classified in the package metadata but are not reproduced in the excerpt; their behavior is not documented here.

Tables Accessed

The package operates against two Receivables tables, accessed through APPS synonyms:

  • AR_PAYMENT_SCHEDULES — The primary target of both documented update procedures. Dispute fields, dunning level fields, descriptive flexfield columns, and follow-up date values are written here. This table is the central store of scheduled receivables amounts, due dates, and collections status for every transaction and installment.
  • AR_TRX_SUMMARY_HIST — Referenced for transaction summary history, typically to maintain or reconcile summarized aging and balance information associated with payment schedule changes.

Usage Notes

ARP_PROCESS_CUTIL is an internal utility rather than a public integration API. It is most commonly invoked from Oracle Receivables collections forms — notably the customer call window, which calls update_ps_fdate — and from other PL/SQL packages within the Receivables module. ETRM reports that the package is referenced by five other packages, confirming its role as a shared dependency in the collections and customer processing code path.

Because the procedures are classified as OTHER and operate directly on base tables, custom code should call them only when replicating the behavior of a standard Receivables form; direct updates to AR_PAYMENT_SCHEDULES outside these routines risk bypassing validation, DFF handling, or summary history maintenance. The package source resides in ARCEUTLS.pls and has been stable since the 2005 revision, so behavior is consistent across EBS 12.1.1 and 12.2.2.