Search Results apply_open_receipt_cover

Overview

ARP_DEDUCTION is a PL/SQL package in the APPS schema that supports Oracle Receivables' deduction and claim handling, including the Trade Management (TM) integration that governs deduction claims raised against customer receipts. In Oracle EBS 12.1.1 and 12.2.2 the package underpins the logic used when a receipt is short-paid or a customer deduction is contested, coordinating claim creation, deduction validation, and the application of open receipts. It operates within the standard Receivables application flow and is classified as a non-public ("OTHER") API, meaning it is called by Oracle's own concurrent programs and forms rather than being a documented extension point. Its dependencies on AR_CASH_RECEIPTS, AR_PAYMENT_SCHEDULES, and AR_RECEIVABLE_APPLICATIONS confirm its role in the receipt-to-invoice settlement cycle.

Key Procedures and Functions

• CHECK_TM / CHECK_TM_DEFAULT_SETUP — Determine whether Trade Management functionality is enabled and whether the required default setup is present before deduction processing proceeds.
• CLAIM_CREATION / CREATE_CLAIMS_RAPP_DIST — Create deduction claims and generate the associated receivable application distributions.
• UPDATE_CLAIM / UPDATE_CLAIM_CREATE_STATUS — Maintain claim records and reflect the outcome of claim-creation attempts.
• CLAIM_CREATE_FAIL_RECOVER — Handle recovery when claim creation fails, allowing the process to be reversed or retried safely.
• GET_FUNCTIONAL_CURRENCY / GET_RECEIVABLES_TRX_ID — Retrieve the ledger's functional currency and the Receivables transaction identifier needed for claim and application processing.
• CONC_REQ_LOG_MSG / CONC_REQ_OUT_MSG — Write log and output messages to the concurrent request log, supporting diagnostics during concurrent processing.
• OVERAPPLICATION_INDICATOR / CHECK_APP_VIOLATE — Flag over-application conditions and detect violations of application rules.
• GET_TM_ORACLE_REASON — Return the Oracle reason code associated with a Trade Management deduction.
• APPLY_OPEN_RECEIPT_COVER — Apply open receipts to cover the deduction or claim amount.
• GET_ACTIVE_CLAIM_FLAG — Indicate whether an active claim exists for the deduction in question.

Tables Accessed

The package reads and writes the core Receivables settlement tables. AR_CASH_RECEIPTS and AR_CASH_RECEIPT_HISTORY provide the receipt header and activity records; AR_PAYMENT_SCHEDULES and AR_PAYMENT_SCHEDULES_ALL supply the instalment and due-date detail used to assess short payments. AR_RECEIVABLE_APPLICATIONS and AR_DISTRIBUTIONS / AR_DISTRIBUTIONS_ALL record the application and accounting distributions generated for claims. AR_SYSTEM_PARAMETERS and AR_RECEIPT_METHOD_ACCOUNTS supply setup defaults, while AR_RECEIVABLES_TRX, RA_CUSTOMER_TRX, and RA_CUST_TRX_TYPES resolve transaction identifiers and types. DBMS_SQL and PLITBLM indicate reliance on dynamic SQL and standard PL/SQL table utilities.

Usage Notes

ARP_DEDUCTION is invoked indirectly. It is referenced by ARP_PROCESS_APPLICATION and by several open-interface and open-items views, including AR_OPEN_ITEMS_V, AR_RECEIVABLE_APPLICATIONS_V, AR_INTERIM_CASH_RECEIPTS_V, and AR_MASS_APPLICATIONS_V, which are exposed through Receivables forms and concurrent programs such as AutoLockbox and the automatic application processes. Because the package is undocumented as a public API (classification OTHER) and is referenced by eight other packages, custom development should not call it directly; extended deduction or claim logic should instead be implemented through supported Receivables APIs and the standard Trade Management configuration. Any reliance on the package internals risks breakage across patches and upgrades between 12.1.1 and 12.2.2.