Suppliers in TCA - A dive into Vendor Tables in R12 - TCA DataModel.
Prior to R12, creation of a vendor/supplier record in eBusiness suite largely meant insertion of records in PO_VENDORS.
However, from R12 onwards, records are inserted into at least half a dozen tables when a single Supplier record is created.
This is largely due to the fact that Suppliers have been moved into the TCA DataModel.
In this article, I would like to show you the set of tables that are effected when a Supplier record gets created in Release12.
I will also touch base upon Supplier Sites and changes to taxation related tables.
End User Step 1
To begin with, we need to create a Supplier. Lets name it Go4Gold [which also happens to be the name of my old company].
Simply enter name of the Supplier in organization name field and click on Apply. This will create a Supplier.
End User Step 2.
You can doublecheck the created Supplier, which has Supplier Number 20186.
This supplier number comes from a table named AP_SUPPLIERS.
For more details >>http://apps2fusion.com/technical-articles-mainmenu-27/41-r12/209-suppliers-in-tca-a-dive-into-vendor-tables-in-r12
Filed under: 11i, ERP, R12, TCA
Leave a Reply
You must be logged in to post a comment.