AR Autoinvoice vs AR Invoice API vs AR Credit Memo API R12

A) AutoInvoice requires a batch of type Imported.

Batch sources define default information such as transaction type and automatic numbering. There are two types available: Manual and Imported.

AutoInvoice requires a batch of type Imported.

Autoinvoice interface table can be used for importing AR invoices as well as credit memo.

Ref : Support Doc Id 1067402.1 – Manage Transaction Sources

 

B) Invoice API’s : Invoice API requires a batch of type Manual.

The Invoice API can create the following transaction types:

  • Invoices
  • Debit Memos
  • On-account Credit Memos

Within AR_INVOICE_API_PUB, there are 2 methods to create Invoices:

  • CREATE_INVOICE – to create multiple invoices within one batch
  • CREATE_SINGLE_INVOICE – to create a single invoice

Batch sources define default information such as transaction type and automatic numbering. There are two types available: Manual and Imported.

AR Invoice API requires a batch of type Manual.

AR Invoice API can be used for importing AR invoices as well as On Account Credit memo.

Ref: Support Doc Id 1242202.1 – Manage Transaction Sources

 

C) Receivables Credit Memo API

  1. Main Package

The creation and application of a credit memo via an API is handled by 2 distinct APIs.

Request for credit memo and creation of a credit memo via an API is defined in the package AR_CREDIT_MEMO_API_PUB, contained within:

  • ARWCMAPS. pls – Package Specification
  • ARWCMAPB.pls – Package Body

Application of an existing credit memo to a Refund transaction via an API is defined in the package AR_CM_APPLICATION_PUB, contained within:

  • ARXPCMAS.pls – Package Specification
  • ARXPCMAB.pls – Package Body
  1. Types of Credit Memo APIs

Originally, the Credit Memo API was defined in AR_CREDIT_MEMO_API_PUB, 2 methods were provided:

  • CREATE_REQUEST – to initiate a request for a credit memo, this API provides the option of going through an approval process prior to creation of the credit memo. This API was originally created for use by Oracle iReceivables wherein a user can create a dispute, that goes through an approval process and when approved becomes a credit memo. A credit memo is created and applied to an invoice.
  • GET_REQUEST_STATUS – to check the status of CREATE_REQUEST to determine whether or not approval has been granted for the credit request.

The package AR_CM_APPLICATION_PUB provides 2 methods:

  • ACTIVITY_APPLICATION – to apply a credit memo to a particular activity/transaction
  • ACTIVITY_UNAPPLICATION – to unapply a credit memo from a particular activity/transaction

IMPORTANT: Currently, the only activity you can apply a Credit Memo to via this API is a Refund.

Later, an enhancement request was logged to request for the ability to create, apply and unapply On-account credit memos. This request was fulfilled in Patch 5257046.

This patch enhanced the Invoice API to allow creation of On-Account Credit Memos. Further, a new package AR_CM_API_PUB was created to allow  the Application/Unapplication of On-Account credit memos.

Ref : Support Doc Id 1272600.1

D) How to Troubleshoot Receivables API Issues

Ref : Support Doc Id 784317.1

 

Thanks Yogesh

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s