Customer/Supplier Interface Tables in 12.0.0

This forum is to discuss different features/issues of Oracle Financials modules ( GL - General Ledger, AP - Accounts Payable, AR - Accounts Receivable, FA - Fixed Assets & CM - Cash Management ).
Post Reply
akhtarsial
Posts: 12
Joined: Wed Sep 05, 2007 3:10 am
Location: Pakistan

Customer/Supplier Interface Tables in 12.0.0

Post 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
admin
Posts: 2063
Joined: Fri Mar 31, 2006 12:59 am
Location: Pakistan
Contact:

Post by admin »

Use following tools to upload data directly in the forms,

http://www.dataload.net/downloads/sprea ... index.html
http://www.formsdataloader.com/
akhtarsial
Posts: 12
Joined: Wed Sep 05, 2007 3:10 am
Location: Pakistan

Post 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
admin
Posts: 2063
Joined: Fri Mar 31, 2006 12:59 am
Location: Pakistan
Contact:

Post 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
akhtarsial
Posts: 12
Joined: Wed Sep 05, 2007 3:10 am
Location: Pakistan

Post by akhtarsial »

Thanx a lot, can you please, give me table names for customers process.

Thanx again,

Akhtar
icahyd
Posts: 2
Joined: Mon Nov 10, 2008 5:04 pm
Location: India

Post 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>
Post Reply

Who is online

Users browsing this forum: No registered users and 2 guests