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.
Subscribe to:
Post Comments (Atom)
Subscribe To
Posts
Comments
About Me
- Krishanu Bose
- India
- Krishanu's Oracle Applications Blog - Oracle Apps consulting services scenario in India. Also, an inside view of Oracle Apps outsource services in India. Also the blog features new developments in Oracle Apps and my learning's in this field. The views expressed are my own only and not of my employer Wipro Technologies. The views and opinions expressed by visitors to this blog are theirs and do not necessarily reflect mine.
10 comments:
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
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
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.
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
Hi:
Any luck on how to import Payments without impacting Support.
Thanks
Murali
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
Hi,
Any workaround to bring the paid invoices, Payments to AP.
Thanks
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
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
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
Post a Comment