My Oracle Support Banner

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

Last updated on MAY 12, 2020

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:

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:

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Scope
Details
 1. How do APIs work?
 2. Features of APIs
 3. Alternatives to Receipt APIs
 4. Receipt API Programs
 5. Receipt API Procedures
 6. Setup Requirements
 7. Sample Code
    a. AR_RECEIPT_API_PUB.CREATE_CASH
    b. AR_RECEIPT_API_PUB.APPLY
    c. AR_RECEIPT_API_PUB.CREATE_AND_APPLY
    d. AR_RECEIPT_API_PUB.UNAPPLY
    e. AR_RECEIPT_API_PUB.APPLY_ON_ACCOUNT
    f. AR_RECEIPT_API_PUB.UNAPPLY_ON_ACCOUNT
    g. AR_RECEIPT_API_PUB.REVERSE
    h. AR_RECEIPT_API_PUB.ACTIVITY_APPLICATION
    i. AR_RECEIPT_API_PUB.CREATE_MISC
    j. AR_RECEIPT_API_PUB.APPLY_OTHER_ACCOUNT
    k. AR_RECEIPT_API_PUB.UNAPPLY_OTHER_ACCOUNT
    l. AR_RECEIPT_API_PUB.APPLY_OPEN_RECEIPT
    m. AR_RECEIPT_API_PUB.CREATE_APPLY_ON_ACC
    n. AR_RECEIPT_API_PUB.APPLY_IN_DETAIL
    o. AR_RECEIPT_UPDATE_API_PUB.UPDATE_RECEIPT_UNID_TO_UNAPP
 7. Running APIs
 8. Reviewing the Receipt Created by the API
 9. Calling the Receipt APIs from a Concurrent Program
 10. Troubleshooting & Tips
 11.  Known Issues and Patches
 Still Have Questions?
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.