Page 1 of 1

Customer/Supplier Interface Tables in 12.0.0

Posted: Wed Oct 22, 2008 12:43 am
by akhtarsial
Hi Gents,

We have implemented R12 GL, AR & AP and want to upload Suppliers & Customers through SQL Loder. Can you please, tell me the tables name for Customer and Customers Site, smiler for Supplier and Supplier site. We want to upload the following information for Customer: Customer Name, Customer Site Name, Address, City, Country, Phone, Fax, NTN, STR (sales tax registration).

Please help me, with the process. We are on R12 version 12.0.0.

Thanx in advance.

Akhtar

Posted: Wed Oct 22, 2008 2:05 am
by admin
Use following tools to upload data directly in the forms,

http://www.dataload.net/downloads/sprea ... index.html
http://www.formsdataloader.com/

Posted: Wed Oct 22, 2008 2:44 am
by akhtarsial
Dear Admin,

Thank you for replying. In R12 there are HTML based forms and I think we can't use dataloader here. If i'm wrong please, give me right way.

Regards

Akhtar Sial

Posted: Wed Oct 22, 2008 3:10 am
by admin
AP_SUPPLIERS_INT
AP_SUPPLIER_SITES_INT
AP_SUP_SITE_CONTACT_INT

then run requests from AP module,

Supplier Open Interface Import
Supplier Open Sites Interface Import
Supplier Sites Contact Interface Import

Posted: Wed Oct 22, 2008 3:21 am
by akhtarsial
Thanx a lot, can you please, give me table names for customers process.

Thanx again,

Akhtar

Posted: Mon Nov 10, 2008 5:08 pm
by icahyd
Hi,

You can visit www.formsdataloader.com they have launched a new tool to load the data in HTML forms. Try it.

Ashi

Dear Admin,

Thank you for replying. In R12 there are HTML based forms and I think we can't use dataloader here. If i'm wrong please, give me right way.

Regards

Akhtar Sial

<i><div align="right">Originally posted by akhtarsial - Oct 21 2008 : 10:44:44 PM</div id="right"></i>