 Tables behind Oracle E - Business 11.5.10 for using SQL-Load? [message #137107] |
Tue, 13 September 2005 05:20  |
stepheng
Messages: 12
Registered: August 2005
Location: Ireland
|
Junior Member |
|
|
Hi ,
We need to find out the name of every table/view behind forms in Oracle Forms on 11.5.10
Take HR for example , enter a new Employee...
If we are entering data via SQLLoader , how do we know what tables to user? Ive used Etrn on Metalink but its not obvious what tables and views are behind what Forms..
Anyone have any pointers?
Cheers!
Stephen
|
|
|
|
| Re: Tables behind Oracle E - Business 11.5.10 for using SQL-Load? [message #137114 is a reply to message #137107] |
Tue, 13 September 2005 05:54  |
adragnes
Messages: 241
Registered: February 2005
Location: Oslo, Norway
|
Senior Member |
|
|
It is not a good idea to load data straight into the base tables of the Oracle E-Business Suite, more likely than not it will result in corrupt or incorrect data. You should use the open interfaces and API's instead. In Oracle HR there are API's for just about everything. Another possible route, at least if it is not massive amounts of data, is to use a tool like DataLoad to automate the filling out of the forms.
--
Aleksander Dragnes
|
|
|
|
|
|
| Re: Tables behind Oracle E - Business 11.5.10 for using SQL-Load? [message #137173 is a reply to message #137172] |
Tue, 13 September 2005 10:12 |
stepheng
Messages: 12
Registered: August 2005
Location: Ireland
|
Junior Member |
|
|
So to confirm , Oracle will pull support if you insert data direct to tables?
We have been using dataload but our new Data Migration person is suggesting using perl scripts in the back end to insert data..
Validation could be done via Perl Scripts..
We have HR , all Finance , Inventory and many other modules...
Can you give me a link to all other APIS?
Will log tar also....
thanks!
|
|
|
|
| Re: Tables behind Oracle E - Business 11.5.10 for using SQL-Load? [message #137175 is a reply to message #137173] |
Tue, 13 September 2005 10:32 |
Art Metzer
Messages: 2480
Registered: December 2002
|
Senior Member |
|
|
MetaLink's down at the moment, but haven't you read the following text at the beginning of every Oracle Apps guide?| Quote from Oracle Documentation |
Do Not Use Database Tools to Modify Oracle Applications Data
Oracle STRONGLY RECOMMENDS that you never use SQL*Plus, Oracle Data Browser, database triggers, or any other tool to modify Oracle Applications data unless otherwise instructed.
Oracle provides powerful tools you can use to create, store, change, retrieve, and maintain information in an Oracle database. But if you use Oracle tools such as SQL*Plus to modify Oracle Applications data, you risk destroying the integrity of your data and you lose the ability to audit changes to your data.
Because Oracle Applications tables are interrelated, any change you make using Oracle Applications can update many tables at once. But when you modify Oracle Applications data using anything other than Oracle Applications, you may change a row in one table without making corresponding changes in related tables. If your tables get out of synchronization with each other, you risk retrieving erroneous information and you risk unpredictable results throughout Oracle Applications.
When you use Oracle Applications to modify your data, Oracle Applications automatically checks that your changes are valid. Oracle Applications also keeps track of who changes information. If you enter information into database tables using database tools, you may store invalid information. You also lose the ability to track who has changed your information because SQL*Plus and other database tools do not keep a record of changes.
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
