- OracleApps Epicenter - http://www.oracleappshub.com -
Quick note for Supplier in EBS
Posted By Sanjit Anand On September 9, 2007 @ 8:54 am In Beginner,Oracle Payable | 9 Comments
In Oracle supplier can be entered from three different place.These are the Setup required to perform for a suppliers.
In Oracle these are the important features through the screen:
Supplier Data Entry
and these are the optional field
Important Table that holds supplier
Some important columns:
How they connected
These are typically connected as:
Take a note Segment1 is holding suppliers Number.
Quick query for new babies
select * from po_vendors
where segment1 = '1001â€˜;
from po_vendor_sites pvs,
where pov.segment1 = '1001'
and pov.vendor_id = pvs.vendor_id;
from po_vendor_contacts pvc,
where pov.segment1 = '1001'
and pov.vendor_id = pvs.vendor_id
and pvs.VENDOR_SITE_ID = pvc.vendor_site_id;
Yes, that was one of the enhancement in oracle 11.5.10 release. Prior to that version, there was no interface or Public exist for supplliers, thus it was a tricky to handle supplier. As we have already seen AP availability of AP  some time back.
If you are having 11.5.10+ version,and if you have requirement to create supplier from your legacy data than use Supplier Interface, life will be easier. Is n't.
How we start
This consist in 2 steps process:
Step 1. Populate the new interface tables with data. This can be done via SQL*Loader or typically used to load data in a table.
Step 2. Run the Supplier Open Interface Request Set (FNDRSSUB1703)
Alternatively, run the individual import programs to load one table at a time
Some important notes for suppliers Interface
The entire flow can be shown as:
A Note with R12 for Suppliers
As we know in R12 Supplier is part of TCA , thus the link between PO_VENDORS and HZ_PARTIES is PO_VENDORS.party_id. The link between
PO_VENDOR_SITES_ALL and HZ_PARTY_SITES is PO_VENDOR_SITES_ALL.party_site_id.
When a Supplier is created Record will be Inserted in HZ_PARTIES. When the Supplier Site is created Record will be Inserted in HZ_PARTY_SITES. When Address is created it will be stored in HZ_LOCATIONS.
Article printed from OracleApps Epicenter: http://www.oracleappshub.com
URL to article: http://www.oracleappshub.com/account-payable/quick-note-for-supplier-in-ebs/
URLs in this post:
 AP availability of AP : http://www.oracleappshub.com/account-payable/oracle-api-availability-oracle-payables-ap/
 : http://www.oracleappshub.com/account-payable/quick-note-for-supplier-in-ebs/
Disclaimer The opinions expressed here represent solely my own represent personal conjecture based upon experience, practice and observation and does not represent the thoughts, intentions, plans or strategies of my current & previous employers and their clients. Copyright © 2007-2010 OracleApps Epicenter. All rights reserved.