Oracle Receivables: Receipts API Overview, Setup, Sample Scripts and Troubleshooting (Doc ID 1361075.1)

Last updated on SEPTEMBER 16, 2024

Applies to:

Oracle Receivables - Version 12 to 12.2.3 [Release 12.0 to 12.2]
Oracle Receivables - Version 11.5.10.0 to 11.5.10.3 [Release 11.5.10]
Oracle Receivables - Version 12.2.5 and later
Information in this document applies to any platform.

Purpose

Oracle Receivables (AR): Receipts Workbench Information Center > Note 1361075.1

Oracle provides several Application Program Interfaces (APIs) that enable users to create, apply, unapply and reverse receipts using PL/SQL code rather than manually entering them through the form or via Lockbox. There are public APIs to do the following:

Create a cash receipt or a miscellaneous receipt
Create a cash receipt and then apply it to a transaction
Create a cash receipt and then apply it to On-Account
Reverse a receipt
Apply and Unapply a receipt to:
- a transaction
- On-Account
- an Activity (e.g. Refund)
- Other Accounts (e.g. Claims)
- a receipt
Apply a Receipt to a transaction at the line level
Update a Receipt from Unidentified to Unapplied
Update refund attributes

Detailed information describing each API and its input/output parameters is available in the Oracle Receivables Reference Guide.

This note provides an overview of the Receipt APIs, sample scripts for each of the available procedures and tips on troubleshooting the API.

Introducing our Receipts and Lockbox Analyzer

EBS Oracle Receivables Lockbox Analyzer DocID 2323322.1

The EBS Oracle Receivables Lockbox Analyzer is a self-service health-check script that reviews Lockbox related data, analyzes current configurations and settings for the environment and provides feedback and recommendations on best practices. Analyzers may also be used as data collection tools by Support Engineers. Your application data is not altered in any way when you run this analyzer.

Oracle Receivables Receipt Analyzer DocID 2089720.1

Scope

This note provides sample scripts for a user with PL/SQL programming experience, to assist in developing their own code to use the following Receipt APIs: