Useful Workflow Commands

 

WFLOAD apps/columbus789 0 Y DOWNLOAD APEXP_FINDEV.wft APEXP

Locations:

$PO_TOP/patch/115/import/US/porpocha.wft

$PO_TOP/patch/115/import/US/poxwfpag.wft

$PO_TOP/patch/115/import/US/poappame.wft

Actions:

porpocha.wft - Updated ACCESS_LEVEL from 20 to 0

poxwfpag.wft - Updated ACCESS_LEVEL from 20 to 0

poappame.wft - Updated ACCESS_LEVEL from 20 to 0

Command/Results should be:

$FND_TOP/bin/WFLOAD apps/apps_password 0 Y UPLOAD $PO_TOP/patch/115/import/US/porpocha.wft

$FND_TOP/bin/WFLOAD apps/apps_password 0 Y UPLOAD $PO_TOP/patch/115/import/US/poxwfpag.wft

$FND_TOP/bin/WFLOAD apps/apps_password 0 Y UPLOAD $PO_TOP/patch/115/import/US/poappame.wft

WFLOAD apps/columbus789 0 Y DOWNLOAD /u02/migrate/nagaraj/files/workflow/porpocha.wft porpocha

WFLOAD apps/columbus789 0 Y DOWNLOAD /u02/migrate/nagaraj/files/workflow/poxwfpag.wft poxwfpag

WFLOAD apps/columbus789 0 Y DOWNLOAD /u02/migrate/nagaraj/files/workflow/poappame.wft poappame

/u01/applmgr/fs1/EBSapps/appl/po/12.0.0/patch/115/import/US

cp porpocha.wft /u02/migrate/nagaraj/files/workflow

cp poxwfpag.wft /u02/migrate/nagaraj/files/workflow

cp poappame.wft /u02/migrate/nagaraj/files/workflow

cp poxwfnot.wft /u02/migrate/nagaraj/files/workflow

$FND_TOP/bin/WFLOAD apps/columbus789 0 Y UPLOAD /u01/applmgr/fs1/EBSapps/appl/po/12.0.0/patch/115/import/US/porpocha.wft

$FND_TOP/bin/WFLOAD apps/columbus789 0 Y UPLOAD /u01/applmgr/fs1/EBSapps/appl/po/12.0.0/patch/115/import/US/poxwfpag.wft

$FND_TOP/bin/WFLOAD apps/columbus789 0 Y FORCE /u01/applmgr/fs1/EBSapps/appl/po/12.0.0/patch/115/import/US/poappame.wft

$FND_TOP/bin/WFLOAD apps/columbus789 0 Y UPLOAD /u01/applmgr/fs1/EBSapps/appl/po/12.0.0/patch/115/import/US/poxwfnot.wft

WFLOAD apps/columbus789 0 Y FORCE /u02/migrate/nagaraj/files/workflow/access/poxwfnot.wft

DEBUG Log Script in WORKFLOW

This custom procedure which helps us to find the critical logs while working in WORKFLOW

Step 1: Create a Sequence

DROP SEQUENCE XX_DEBUG_S
/
CREATE SEQUENCE XX_DEBUG_S START WITH 1
/

Step 2: Create a Table

DROP TABLE xx_debug_log
/
CREATE TABLE xx_debug_log
(id        NUMBER
,log      VARCHAR2(1000)
,ldate   DATE
)
/

Step 3: Create a Custom Procedure

CREATE OR REPLACE PROCEDURE log_error(p_err_msg VARCHAR2)
IS
PRAGMA AUTONOMOUS_TRANSACTION;
BEGIN
     INSERT INTO xx_debug_log VALUES(XX_DEBUG_S.nextval,p_err_msg,sysdate);
     COMMIT;
END;
/

USAGE : Call the below statement in the workflow dependent package so we will understand the workflow node and it will list all the point it reached before getting stuck with any error !

BEGIN
log_error('Custom Message - Stage 1');
.....
<Some Logic>
.....
log_error('Custom Message - Stage 2');
END;

Select * from xx_debug_log;

Script to update Workflow Mail Address as NULL in TEST Instances to Avoid Triggering Mail to users.

update fnd_user set email_address=' ';

update per_people_f set email_address=' ';

update hz_parties set email_address = null where email_address is not null;

update hz_contact_points set email_address = null where email_address is not null;

update ap_supplier_sites_all   set email_address = null, remittance_email=null;

update ap_supplier_contacts set email_address = null;

update iby_ext_bank_accounts set contact_email = null;

update iby_external_payers_all set debit_advice_email = null;

update iby_external_payees_all set remit_advice_email = null;

update po_headers_all      set email_address = null;

update pon_bid_headers set email  = null;

update pon_bidding_parties set additional_contact_email  = null;

update per_all_people_f set email_address=null, attribute3=trim(attribute3), attribute4=trim(attribute4), attribute5=trim(attribute5), attribute6=trim(attribute6), attribute7=trim(attribute7), attribute8=trim(attribute8), attribute9=trim(attribute9), attribute10=trim(attribute10), attribute11=trim(attribute11), attribute12=trim(attribute12), attribute13=trim(attribute13),attribute14=trim(attribute14),attribute15=trim(attribute15);

update WF_LOCAL_USERS set email_address = null where email_address is not null ;

update WF_LOCAL_ROLES set email_address = null where email_address is not null;

update wf_notifications set mail_status='SENT' where mail_status in ('MAIL', 'ERROR', 'FAILED'); (under apps schema);

update wf_notifications set status='CLOSED', mail_status='SENT', end_date=sysdate where status='OPEN' and MESSAGE_TYPE='WFERROR';

update fnd_user set user_guid=null';

Workflow Notification Mail is in Unreadable Format in Outlook

All the workflow notification mails triggered from Oracle EBS are in unreadable format for user who view mails in outlook or mail box.

Issue : Users are not able to take any actions since mails are in unreadable format as shown below.

Solution : Execute the following steps:

1. Update System Profile option FND: Enable Rich Table Interactions
• Responsibility: System Administrator
• Navigation: Profiles > System
• Query and set the profile option FND: Enable Rich Table Interactions
• True at site level
• False at sysadmin user level (sysadmin is the default mailer user)
2. Clear the cache Using Functional Administrator.