Feb 10, 2014
Can the TCA Party of an Existing Customer be Used as the TCA Party for a Supplier?
The ability to query an existing TCA party and create them as a supplier is not yet available .If the TCA party is a SUPPLIER party , then we can query that party and create a CUSTOMER ACCOUNT for that party.
But on the other hand ,if TCA party is CUSTOMER party and we query the customer party and want to create a supplier Party then two parties will be created , reason is that unlike CUSTOMERS, most of the options and details that define a supplier are not stored in TCA tables, but in separate tables AP_SUPPLIERS and AP_SUPPLIER_SITES. In order to enter these details the Supplier form or Supplier Open Interface must be used.
Jan 13, 2014
Query to Connect Trading Partner header ( ecx_tp_header) table with TCA ( Suppliers) table
pv.vendor_name, pvsa.vendor_site_code, pvsa.ece_tp_location_code, hp.party_name, hps.party_site_name
WHERE HPS.PARTY_SITE_ID = pvsa.party_site_id
AND HPS.PARTY_ID = hp.PARTY_ID
AND HP.PARTY_ID = pv.party_id
AND eth.party_site_id = pvsa.vendor_site_id
AND eth.party_id = pv.vendor_id
AND pvsa.ece_tp_location_code is not null
AND pvsa.vendor_id = pv.vendor_id
Dec 30, 2013
To Enable an Org for Process Manufacturing
- Enable the Process Manufacturing Enabled Flag ( as shown below)
And to Associate an Enterprise Asset Management Org to Manage OPM Org resources assign an EAM Org to Process enabled Org as shown below .