Category Archives: Templates
A new template is on its way. The template will load tax exemptions and legal messages. There is no API for this, so data is loaded directly into base tables. The template is validating all codes and getting the id’s needed. … Continue reading
Pls. chk: Update People
You can now extract concurrent request from one environment and restart concurrent request on any environment, as many times as needed. Excellent for perfomance or unit testing.
update organizations – posted 05-02-2010 update locations – posted 05-02-2010 update party site – posted 05-02-2010 update cust account site – posted 05-02-2010 update cust account site use – posted 05-02-2010 update cust account – posted 05-02-2010 Extract scripts is … Continue reading
The “update customer profile” and “update customer profile amounts” templates will enable you to extract profile and profile amounts (sql extracts included) – and do updates. The templates is using HZ_CUSTOMER_PROFILE_V2PUB.UPDATE_CUST_PROFILE_AMT and HZ_CUSTOMER_PROFILE_V2PUB.UPDATE_CUSTOMER_PROFILE procedures for update.
The update customers template has conformed sql for extract and update. On the sql sheet you will find: $cust_addr_su and $cust_rel_addr_su The $cust_addr_su will extract customer, address and site use info. The $cust_rel_addr_su will also extract relations. Some mappings is … Continue reading