Posted on November 26th, 2007 by Sanjit Anand |
Print This Post
|
Email This Post
Read this :
http://www.oracleappshub.com/account-payable/quick-note-for-supplier-in-ebs/
In earlier post,we have seen supplier has been moved into TCA model. Comparing to 11i version, three new AP tables containing supplier unique data been introduced. They have the links to TCA tables:
-
AP_SUPPLIERS
-
AP_SUPPLIER_SITES_ALL
-
AP_SUPPLIER_CONTACTS
And more important we understood three old PO Vendors tables obsolete, by Views provided for backward compatibility
Here is data model .This will really helps to understand while designing integration with EBS R12.
February 27th, 2008 at 5:34 am
I wanted to know which API can be used to update the supplier name.
As I understand you can create a supplier using POS_VENDOR_PUB_PKG.create_vendor.
However, when I use POS_VENDOR_PUB_PKG.update_vendor to update supplier name. IT’s not happening.
Any suggestions?
March 1st, 2008 at 1:50 am
which version you are doing
More over R12 this API is not supporting by oracle.
i am not sure , for supplier name,I have used direct base table(po_vendors) update in one of such requirement.
Check POS_VENDOR_PUB_PKG.update_vendor in irep.
April 18th, 2008 at 10:34 pm
This is giving brief idea about r12. It is very nice.
May 1st, 2008 at 11:49 pm
Use HZ_PARTY_V2PUB.update_organization.
Since TCA architecture is involved the above procedure can be used.
please let me know if this works.
May 29th, 2008 at 10:38 pm
do you have interface/api to import vendors, banks in AP in R12.