Search Results ar_request_cm

Overview

ARW_CMREQ_COVER is a public PL/SQL cover package in the Oracle E-Business Suite Receivables (AR) module, owned by the APPS schema and classified as an OTHER API type. It provides the server-side logic layer for credit memo requests, the business objects that customer service and collections personnel use to request, submit, and process credit memos against existing transactions. A credit memo request is an internal authorization vehicle: it captures the header, line, and tax details of a proposed credit, routes the request for approval, and, once approved, drives the automatic creation of a credit memo transaction in Receivables. This package encapsulates that workflow, exposing callable entry points that forms and concurrent programs invoke rather than embedding the logic in the UI layer.

The package header declares several strongly typed record structures, including pq_attribute_rec_type, pq_interface_rec_type, and pq_global_attribute_rec_type. These structures carry the descriptive flexfield attribute columns (attribute_category, attribute1 through attribute15, and the corresponding interface_header_attribute1 through interface_header_attribute15 columns) and global attribute context values. Their presence confirms that ARW_CMREQ_COVER supports flexible attribute propagation across the credit memo request interface, a standard requirement for any EBS interface table design. The AUTHID CURRENT_USER declaration indicates the package executes with the privileges of the calling user, consistent with APPS schema conventions for APIs that are called from multiple operating contexts.

Key Procedures and Functions

The documented API surface consists of three callable procedures:

• AR_REQUEST_CM — Creates and submits a credit memo request. This is the primary entry point for the request first half of the workflow: it validates the supplied request data, inserts the credit memo request header and lines into the interface tables, and initiates the request so that it can be approved and later converted into an actual credit memo transaction.
• AR_AUTOCREATE_CM — Automatically creates the credit memo transaction from an approved credit memo request. This procedure performs the conversion step, reading the approved request data and generating the corresponding Receivables transaction records. This is the procedure most directly associated with the search term ar_autocreate_cm; in EBS it is commonly reached through the AutoCreate Credit Memo concurrent program and the associated Credit Memo Request processing forms.
• CANCEL_CM_REQUEST — Cancels an existing credit memo request. It reverses or flags the request so that no further approval or conversion activity occurs, preserving the audit trail of the original submission.

No parameter signatures are documented in the available metadata, and none should be assumed; the procedures are described here solely by their business purpose.

Tables Accessed

ARW_CMREQ_COVER reads and writes a set of Receivables base and interface tables. RA_CM_REQUESTS, RA_CM_REQUESTS_ALL, RA_CM_REQUESTS_S, and RA_CM_REQUEST_LINES hold the credit memo request header and line data at each stage of the request lifecycle, including the public synonyms and sequence-backed rows used for multi-organization access. RA_BATCH_SOURCES and RA_BATCHES supply the batch source configuration and batch grouping used when the resulting transactions are created. RA_CUSTOMER_TRX and RA_CUSTOMER_TRX_LINES are the transaction tables where created credit memos and their lines are ultimately written. AR_PAYMENT_SCHEDULES receives the payment schedule rows that accompany any new transaction. AR_SYSTEM_PARAMETERS and FND_PROFILE_OPTION_VALUES supply system-level and profile-driven defaults that govern behavior such as batch source selection and approval routing. WF_EVENT_T supports Oracle Workflow event records raised during request processing. PLITBLM is the standard PL/SQL table utility used for array-style processing.

Usage Notes

This package is normally invoked indirectly. In a standard EBS 12.1.1 or 12.2.2 environment it is reached from Receivables credit memo request forms and from the concurrent programs that submit and autocreate credit memo requests, including the AutoCreate Credit Memo process. Because it is a documented OTHER API in the APPS schema and is referenced by ten other packages, customizations should call its procedures rather than manipulating the underlying RA_CM_REQUEST tables directly, so that validation, workflow, and audit logic remain intact. When troubleshooting the ar_autocreate_cm path, the most productive starting point is confirming that a request exists in the expected status in RA_CM_REQUESTS and that the batch source configuration is valid before examining the transaction creation output in RA_CUSTOMER_TRX.