What is Base Tables and Interface Tables
-
- Posts: 63
- Joined: Sat Nov 21, 2009 6:59 am
- Location: India
What is Base Tables and Interface Tables
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
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
-
- Posts: 2
- Joined: Wed Aug 19, 2009 3:20 pm
- Location: USA
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
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
[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
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
[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
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
-
- Posts: 63
- Joined: Sat Nov 21, 2009 6:59 am
- Location: India
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
Cheers,
Saravanan
-
- Posts: 63
- Joined: Sat Nov 21, 2009 6:59 am
- Location: India
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
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
Who is online
Users browsing this forum: No registered users and 0 guests