1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

How to import 'Receipts' data in AR

Discussion in 'Oracle Financials' started by NASEER, Apr 13, 2009.

  1. NASEER

    NASEER Active Member

    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    55
    Location:
    Islamabad, Pakistan
    Dear all,

    I have inserted 'Invoice' data in Oracle Application (R12) thgough Interface tables by using Autoinvoice program. Now I want to insert/migrate 'Receipt' data against these invoices. Can anybody help me what is the best option for this purpose? Also give me an example in this case.
    Thanks in advance.
    Naseer
     
  2. apps_expert

    apps_expert Forum Expert

    Messages:
    325
    Likes Received:
    28
    Trophy Points:
    330
    Location:
    Chennai, India
    Hi Naseer

    Previously Lockboxes were used to import receipts against invoices and open/partially open invoices. However now (since 11i) there is the AR RECEIPTS_API through which you can import/create all your receipts. The receipts API for 11i are
    Code (Text):

    ar_receipt_api_pub.Create_cash
    ar_receipt_api_pub.Apply
    ar_receipt_api_pub.Unapply
    ar_receipt_api_pub.Reverse
    ar_receipt_api_pub.Apply_on_account
    ar_receipt_api_pub.Unapply_on_account
    ar_receipt_api_pub.Activity_application
    ar_receipt_api_pub.Activity_unapplication
    ar_receipt_api_pub.Apply_other_account
    ar_receipt_api_pub.Unapply_other_account
    ar_receipt_api_pub.create_misc
    ar_receipt_api_pub.set_profile_for_testing
    ar_receipt_api_pub.Apply_Open_Receipt
    ar_receipt_api_pub.Unapply_Open_Receipt
     
    If you search metalink by each of these api names you will get the code on how to use them. For example Metalink Note 790647.1 explains how to Use the AR_RECEIPT_API_PUB.apply_open_receipt API.

    Hope this helps
     
  3. VENKATESAN

    VENKATESAN Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
    Hi

    Any body know link between ipayment and Ar during Authorization process

    while i am place the order in OM and iStore at that time Refinfo value was optain in iby_tangible table but i am place the order in AR means Refinfo value as null so what is the reference between Ar and iPayment during authorization process replay soon.

    Thanks
    Venkatesan
     
  4. rgsenthilm74

    rgsenthilm74 Guest

    When you do Authroization from Istore or OM in the Iby_tangible refinfo column header_id will come.But if Authorization happens from AR receipt_id will be there in Refinfo column also tangible_id looks like AR_XXX if it is from OM it looks like ONT_XXX

    Hope this will help