2011年1月25日星期二

Customization of Oracle Workflow (AP Remittance advice workflow APPEWF)

The first thing before any action is amend Oracle workflow access in Workflow builder in order to amend the standard workflow APPEWF.wft :

Menu : Help -> About Oracle Workflow Builder XXXXXX

In the opening window, modify the access level to 20 and enable the Allow modifications of customized objects case.

Then we can modify the standard workflow file APPEWF.wft

Example of modification : add cc list for workflow email(AP remittance advice email).

Step 1 - Add a new global attribute in workflow : XX_CC_NAME

Step 2 - Create a new attribute #WFM_CC in message level, and attached to the global attirbute created previously

Step 3 - Initialize the global attribute XX_CC_NAME in PL/SQL package, in our case here, in AP_PAYMENT_EVENT_WF_PKG.get_check_info, add the following lines :

BEGIN
SELECT NVL(fpov.profile_option_value, '')
INTO l_se_cc
FROM fnd_profile_options fpo, fnd_profile_option_values fpov
WHERE fpo.application_id =20003
AND fpo.profile_option_name = 'XXXXXXX' -- XXXXXX is the profil option's name
AND fpo.profile_option_id = fpov.profile_option_id
AND fpov.level_id = 10006
AND fpov.level_value = l_org_id;
EXCEPTION
WHEN OTHERS THEN
l_se_cc := '';
END;
wf_engine.setitemattrtext(p_item_type,
p_item_key,
'XX_CC_NAME',
l_se_cc);

Step 4 - Upload the new workflow, restart the GTS.

没有评论:

发表评论