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.


Gareth said...



Krishanu Bose said...

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.


Anonymous said...

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.

Krishanu Bose said...

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.


Murali said...

Any luck on how to import Payments without impacting Support.

Anonymous said...

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?


Anonymous said...


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


Sridevi Koduru said...

I am Sridevi Koduru, Senior Oracle Apps Trainer at With 8 Yrs Exp on Oracle Apps and 13 Yrs IT Exp Providing Online Training on Oracle Apps Technical, Oracle Apps Financial Functional, Oracle Apps SCM, Oracle Apps HRMS, Oracle Financial for Indian Localization, SQL, PL/SQL and D2K. I have Provided Training for 500+ Professionals Most of them are Working in Real Time now.

Contact for (One to One Personal Online Training) on Oracle Apps Technical, Oracle Apps Financial Functional, Oracle Apps SCM, Oracle Apps HRMS, Oracle Financial for Indian Localization, SQL, PL/SQL and D2K at | | +91-9581017828 |

Linkedin profile -

Tobin Joseph said...


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


Erptree Oracle said...

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

Sports education worldwide said...

Just found your post by searching on the Google, I am Impressed and Learned Lot of new thing from your post.

basha said...

Magnificent blog I visit this blog it's extremely wonderful. Interestingly, in this blog content composed plainly and reasonable. The substance of data is useful.
Oracle Fusion HCM Online Training
Oracle Fusion SCM Online Training
Oracle Fusion Financials Online Training
Big Data and Hadoop Training In Hyderabad
oracle fusion financials classroom training
Workday HCM Online Training
Oracle Fusion HCM Classroom Training
Workday HCM Online Training
oracle cpq online training / Oracle CPQ Class Room Training
Oracle Taleo Online Training

About Me

My photo
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.