Oracle Cloud offers a broad portfolio of software as a service applications, platform as a service, and social capabilities, all on a subscription basis. Oracle Cloud delivers instant value and productivity for end users, administrators, and developers alike through functionally rich, integrated, secure, enterprise cloud services.
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Subscribe to the OracleAppsHub to receive notifications when there are new posts:

 get RSS feed
 Oracle Fusion Applications (OFA) is a portfolio of next generation suite of software applications from Oracle Corporation. It is distributed across various product families; including financial management, human capital management, customer relationship management, supply chain management, procurement, governance, and project portfolio management
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Step by Step :Using Receipt API ->Apply /Unapply Activity Application (Receipt Writeoff API’s) (Scenario 5)

Posted on May 7th, 2009 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today

Previous tutorial

dgreybarrow What is senarios here

The senario which going to discuss here is apply receipt with some receivable application .

Such applications include Short Term Debit (STD) and Receipt Write-off applications.

In this senario's what you need to offset some balance amount of receipt from collection point of view.Such kind of program you can develop and integrate either in real mode or may be used in batch mode depending upon business need.

dgreybarrowWhich API is being used

This routine call Ar_receipt_api_pub.activity_application to do an activity application on a cash receipt.

dgreybarrow Step to use the API

You have to perform these steps in order to get API executed

Step 1 : Identification of some mandatory and key column of API

Once you identify the key and mandatory column , you have 50% done. What is recomended for you to check the API version in irep with your EBS version.

Here is the example.

First you need to create a Cash Receipt .Let say you did created 5000.5

then you need to create a application activity for 5. The other Information yoy need to use are here:

5h

Step 2 : Idetify and the mandatory column and must do pre-requsite setup for receipt.

Your Payment method , underline bank, respective accounting details must be pre-requiste step up for creating a receipt in Oracle.

The mandatory requirement is Customer master with valid bill to and a valid transaction that must be open.

The other functional setup required is

  1. Approval Limit for the person who is going to do.
  2. An activity with valid GL account as type Receipt Write-off.

4e

5e

 

Input from these two screens are used to pass the value in the API's.5h

Step 3: You need to initialize the apps_initialize pacakge

For this you have to follow these steps:

Run the query 1

  1.  
  2. SELECT USER_ID FROM FND_USER
  3. WHERE USER_NAME='USER_NAME';
  4.  

Run the query 2

  1.  
  2. SELECT application_id FROM fnd_application
  3. WHERE application_short_name LIKE 'APPL_SHRT_NAME';
  4.  

Run the query 3

  1.  
  2. SELECT RESPONSIBILITY_ID
  3. FROM FND_RESPONSIBILITY
  4. WHERE APPLICATION_ID=222;
  5.  

Run the query 4

Run this script in your Toad or Sql*Plus Client , this will initialize the apps.

Alternatively you can use fnd_global.apps_initialize(1290,51118,222) before calling API.

Step 4: You can use the following script which applies to an activity, such as Receipt Write-off.

Assuming You have already first with a receipt of 5000 and then you need to create a writeoff of 5

When you are running this query, you need to find and pass the value of CashReceiptID an identifier for a receipt number that you are going to do application and PaymentScheduleID.

dgreybarrow Final Verification

Final verifictaion here is two steps , you need to verify first after creating cash Receipt of 500 and then you need to reverse this.

Steps 1 : Query for Receipt Number 'HUB-TEST5'(As Example discussed above). The below screen shows the created cash receipt of 5000.

5a

Steps 2 : Once you run the API Query for Receipt Number 'HUB-TEST5'(As Example discussed above). The below screen shows the entry after application activity apply. You can see the details in Receipt History.

5g

Here are the details after applying a application which is as writeoff.

5g

dgreybarrow Activity Unapplication

You can use Ar_receipt_api_pub.activity_unapplication to do a reversal of an activity application on a cash receipt.

This way you can do integration with External system for Collection.Now its time for questions ,comment .

Related Posts

Posted in Oracle Receivable | 6 Comments »Email This Post Email This Post | Print This Post Print This Post

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today
6 Responses
  1. Step by Step :Using Receipt API for Miscellaneous Receipt (Scenario 6) | OracleApps Epicenter Says:

    […] Step by Step :Using Receipt API ->Apply /Unapply Activity Application (Receipt Writeoff API’s) … […]

  2. Batch Control is not showing Decimal place (Rounding issue) | OracleApps Epicenter Says:

    […] Step by Step :Using Receipt API ->Apply /Unapply Activity Application (Receipt Writeoff API’s) … […]

  3. punit Says:

    For the API AR_RECEIPT_API_PUB.Activity_application
    I have few receivable activities ( adjustments/ writeoffs)like
    1 Bank Charges
    2. Under payments
    3. Over Payments
    4. Writeoffs

    For a given value of p_receivables_trx_id, what is the value of p_applied_payment_schedule_id.
    Please tell me how do we determine the mapping for p_applied_payment_schedule_id and p_receivables_trx_id.

  4. d singh Says:

    i like this post. great work

  5. Raj Says:

    Hi Sanjit,

    I have a doubt. I have to move the amount from the unapplied account code to On account code with Sysdate as GL Date instead of Receipt date.

    How to satisfy this requirement.

    Regards,
    Raj

  6. George Michael Bluth Says:

    When using the script:
    http://www.oracleappshub.com/wp-content/uploads/2008/2.5.1/receiptcase5.txt

    In 11.5.8 I see the errors:

    Error report:
    ORA-06550: line 33, column 67:
    PLS-00302: component ‘SECONDARY_APPLICATION_REF_TYPE’ must be declared
    ORA-06550: line 33, column 40:
    PL/SQL: Item ignored
    ORA-06550: line 34, column 67:
    PLS-00302: component ‘SECONDARY_APPLICATION_REF_NUM’ must be declared
    ORA-06550: line 34, column 40:
    PL/SQL: Item ignored
    ORA-06550: line 78, column 44:
    PLS-00320: the declaration of the type of this expression is incomplete or malformed
    ORA-06550: line 47, column 1:
    PL/SQL: Statement ignored
    06550. 00000 – “line %s, column %s:\n%s”
    *Cause: Usually a PL/SQL compilation error.

Leave a Comment

Please note: Comment moderation is enabled and may delay your comment. There is no need to resubmit your comment.