Solved

Connecting web application to Oracle ERP

Posted on 2010-08-29
5
1,119 Views
Last Modified: 2013-12-19
I have an Oracle database driven web application running on JBOSS AP. It has its own database. This applicaiton requires to fetch/update few tables in Oracle ERP database. Some of the data that need to be updated has to be in real time and some data can be updated in batch mode on weekly basis. One approach to fetch/update the data in Oracle ERP is via DB links, but this approach is not feasible for our application for number of reasons for e.g. what will happen when the Oracle ERP database is down. I am trying to find what's the best way for my web applcation to be able to fetch data from Oracle ERP and also update the data in Oracle ERP? I would like to initiate the discussion at this forum and I'm sure it is going to be a long and interesting discussion.
0
Comment
Question by:javaCaravan0
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 2

Expert Comment

by:j_coreil
ID: 33560388
Oracle recommends that you use the standard interface tables and APIs to interact with the Oracle EBS instances. Do you have a metalink account? If so you can go to the ETRM and find the tables that you are looking for or post on here which pieces of information you need and I'll provide some content.

If you google Oracle EBS Payables API or Oracle EBS Payables interface tables, you'll find examples of PL/SQL and regular SQL to pull information. It is STRONGLY recommended that any information that flows INTO Oracle EBS instances go through the interface tables. The data that flows out of Oracle EBS can come directly from the base tables but this is not usually recommended.
0
 

Author Comment

by:javaCaravan0
ID: 33576694
Thanks for the reply.

I don't have metalink account.
I'll need to use Inventory related tables in Oracle ERP for example: Material Usage Type, Check for on-hand quantity etc.
0
 
LVL 2

Expert Comment

by:j_coreil
ID: 33576844
Here are a few public links to Oracle's documentation on the supply chain APIs.

http://download.oracle.com/docs/cd/A85683_01/acrobat/115mfgoim.pdf - Manufacturing Related
http://download-west.oracle.com/docs/cd/A89549_01/acrobat/115omapi.pdf - Order Management Related

If you google "Oracle EBS APIs" or "Oracle Inventory Open Interfaces" or something similar you can find more. If you have a specific question when starting your development project let me know, otherwise there is a lot you need to start reading and getting familiar with such as which API to use. If inventory costs, on hand qty, available to transaction, and item information is what you need currently, I would focus on the APIs that start with "mtl". Get familiar with the mtl_systems_items_b table as well, that is a base table that stores a lot of item attribute information.
0
 

Author Comment

by:javaCaravan0
ID: 33591399
Thank for the valuable input.
I still need to read the pdf file but another related question that I have is:

What would happen when the Oracle ERP DB is not accessible to my web application for any reason, eg. DB is down or network is down etc.... how can such scenarios be taken care of.
0
 
LVL 2

Accepted Solution

by:
j_coreil earned 500 total points
ID: 33591697
If your intent is to build a web application that has necessary metadata inside the Oracle database, you will always have that issue. What most people do is cache the metadata locally within the web application. Oracle's application server as well as JBOSS have some pretty good web caches that can take care of this for you.

If you are asking about just business data that will need to be accessible from the Oracle database, you can handle this again by storing some of the data in a local data repository and only access it if the connectivity to the database is down. That would be a poor man's data failover.
0

Featured Post

Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In our personal lives, we have well-designed consumer apps to delight us and make even the most complex transactions simple. Many enterprise applications, however, are a bit behind the times. For an enterprise app to be successful in today's tech wo…
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
This video shows how to recover a database from a user managed backup
Suggested Courses

632 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question