What is Base Tables and Interface Tables

[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

[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

[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

[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

[nadh.oracleapps@yahoo.com]

Thanks for Replies to nrao1981 and velichetiraghav

What are the Ways to Collect Data for Interfacing.

Thanks

[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

[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

[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

[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