Sunday, August 31, 2008

Importing Payments and Paid Invoices into Oracle - Oracle needs to provide an API

How many of us had a requirement of importing paid invoices and their corressponding payment details to Oracle? I would say many. But strangely till date there in no straight forward method to import payments into Oracle. I feel its time that Oracle comes up with a standard process like an API to handle this business need.
There are a few workarounds to this scenario. A direct update of Oracle base table is one but this comes with the risk of losing support from Oracle.
The other, more robust way would be to use the manual payment feature of Oracle to record such payments that have been already done in the earlier system. However, automating this process using a batch program is a challenge.
Do put in your comments in case you have a soultion to this problem which would help a lot of people out there.

10 comments:

  1. GarethSeptember 03, 2008 4:56 AM

    Hi,
    Try private API AP_PAY_SINGLE_INVOICE_PKG.AP_PAY_INVOICE_IN_FULL, some info here:
    http://forums.oracle.com/forums/message.jspa?messageID=2358519

    Regards,
    Gareth
    http://garethroberts.blogspot.com

    ReplyDelete
  2. Krishanu BoseSeptember 03, 2008 11:54 AM

    Thanks Gareth. I had seen your posting in the forum. But this is a standard procedure, and my feeling is Oracle should try and put in a place a public API to address this generic needs faced by most of us when we go in for payments conversion.

    Krishanu

    ReplyDelete
  3. AnonymousSeptember 30, 2008 1:26 PM

    Can XML gateway interface used for this scenario? I am not an expert but was under the impression that XML Gateway provides rich interface to integrate with other systems (including custom programs) using xml messaging.

    ReplyDelete
  4. Krishanu BoseOctober 01, 2008 10:29 AM

    XML invoices that are sent electronically from supplier can be processed through the Oracle XML Gateway. However, by using this gateway you do not get any additional API's for invoice import.

    Krishanu

    ReplyDelete
  5. AnonymousMarch 16, 2009 5:37 AM

    Hi:
    Any luck on how to import Payments without impacting Support.
    Thanks
    Murali

    ReplyDelete
  6. AnonymousApril 30, 2010 5:59 PM

    Hi Krishanu Bose,

    We have the same requirement to load paid invoices to AP. Can you give us some ideas on how to solve this?

    Thanks

    ReplyDelete
  7. AnonymousApril 18, 2012 2:25 PM

    Hi,

    Any workaround to bring the paid invoices, Payments to AP.

    Thanks

    ReplyDelete
  8. Tobin JosephJuly 13, 2015 3:56 AM

    Hi,

    Please let me know if there is any workaround like custom API to bring the paid invoices, Payments to AP.

    Email: tobin.consultant@gmail.com

    ReplyDelete
  9. AnonymousMay 17, 2018 2:45 AM

    Thanks for sharing nice information, Hope you will share many more articles like this so that it will be helpful for many of us Oracle R12 Financials Training

    ReplyDelete
  10. 12345August 04, 2019 2:55 AM

    Nice blog I visit this blog it's really awesome. The important thing is that in this blog content written clearly and understandable. The content of information is very informative.
    Workday Online Training
    Oracle Fusion HCM Online Training
    Oracle Fusion SCM Online Training
    Oracle Fusion Financials Online Training
    Big Data and Hadoop Training In Hyderabad

    ReplyDelete