Page 1 of 1
What is Base Tables and Interface Tables
Posted: Tue Nov 24, 2009 3:42 pm
by nadh.oracleapps@yahoo.com
Version R12/11i? = R12
Instance PROD/TEST/VIS? = Prod
Module? = All
OS? = Any
Dear Members,
I am new to this Forum. What is Base Table and Interface Table. In What Cases these Tables are Used
Thanks
Posted: Tue Nov 24, 2009 4:46 pm
by velichetiraghav
Hi
The difference between the interface and base tables is as below
Interface table: is the table where the data gets validated before data get posted to the base tables. There are many interfaces which are seeded with Oracle. You can consider as the entry point of the data, and the interface checks the sanity of data.
Base tables: As told earlier once the data is validated will get updated in the base tables, and is considered as the data which is in the base table is accurate and used in many ways. (Reporting..etc..)
Thanks,
Raghav
Posted: Wed Nov 25, 2009 10:37 am
by nrao1981
[quote]Version R12/11i? = R12
Instance PROD/TEST/VIS? = Prod
Module? = All
OS? = Any
Dear Members,
I am new to this Forum. What is Base Table and Interface Table. In What Cases these Tables are Used
Thanks
<i><div align="right">Originally posted by
nadh.oracleapps@yahoo.com
Posted: Mon Nov 30, 2009 9:26 am
by nrao1981
[quote][quote]Version R12/11i? = R12
Instance PROD/TEST/VIS? = Prod
Module? = All
OS? = Any
Dear Members,
I am new to this Forum. What is Base Table and Interface Table. In What Cases these Tables are Used
Thanks
<i><div align="right">Originally posted by
nadh.oracleapps@yahoo.com
Posted: Mon Nov 30, 2009 1:38 pm
by nadh.oracleapps@yahoo.com
Thanks for Replies to nrao1981 and velichetiraghav
What are the Ways to Collect Data for Interfacing.
Thanks
Posted: Mon Nov 30, 2009 5:47 pm
by tgs100
All you need to do is to design the template in excel format. Make sure that all the mandatory fields are captured in the template. Optional fields can be included depending on the availability of the data. Then collect the data from the legacy or other systems as per the template.
Cheers,
Saravanan
Posted: Tue Dec 01, 2009 1:06 pm
by nadh.oracleapps@yahoo.com
Thanks Saravanan for Reply
Suppose Client wants to make maintain 5 Years of Data. Interfaced Data to Base Tables of Invoices. Now how to Map Payments to Invoice in Template.
Thanks
Posted: Thu Dec 03, 2009 9:56 am
by tgs100
What is the problem?
If you have designed the template, the same template is applicable to history data as well.
In the payment template, add one invoice column.
There are some templates available in the forum. Please search and go through the same.
Cheers,
Saravanan
Posted: Fri Dec 04, 2009 1:39 am
by Racle11i
In Receivables some tables prefixed with AR and some of them prefixed with RA Because :
Till 10.4 version Receivables called as "Revenue Accounting " (RA),therefore tables from that version were prefixed "RA".
Since 10.5 version it termed as "Accounting Receivables" (AR),since then some tables were prefixed "AR".
Hope this will help Beginners in FAQs.
Best Regards