Sunday, July 12, 2009

wferr: - 1602: Could not save. - 1400: Could not save to database. MODE=UPGRADE EFFDATE=

While Applying the 8310984 - May 2009, Order Management R12 Cumulative Patch on R12.0.6, worker is failed with the below mentioned error:

ATTENTION: All workers either have failed or are waiting:
FAILED: file oexwford.wft on worker 1.
Worker Log file:
wferr:
- 1602: Could not save.
- 1400: Could not save to database. MODE=UPGRADE EFFDATE=
- 1404: Please first load this entity or check protect and custom level of ACTIVITY 'WFSTD/FED_BUILD_PA_AP_INVO_ACCT_GEN'.
Oracle Workflow Definition Loader 2.6.4.0.
Access level: 20, Mode: UPGRADE
ITEM_TYPE 'WFSTD' is protected, no changes were saved.
ITEM_ATTRIBUTE 'WFSTD/EVENTNAME' is protected, no changes were saved.
ITEM_ATTRIBUTE 'WFSTD/REQUESTOR_USERNAME' is protected, no changes were saved.
ITEM_ATTRIBUTE 'WFSTD/OWNER_ROLE' is protected, no changes were saved.
ITEM_ATTRIBUTE 'WFSTD/FORWARD_FROM_DISPLAY_NAME' is protected, no changes were saved.
ITEM_ATTRIBUTE 'WFSTD/N' is protected, no changes were saved.

Solution:
Change the Patch driver file related WFLOAD command from UPGRADE to FORCE.

Before Modify:
# file-version-parsed ont patch/115/import/US oexwford.wft 120.8.12000000.10

exec fnd bin WFLOAD bin &phase=daa+52 checkfile:ont:patch/115/import/US:oexwford.wft &ui_apps 0 Y UPGRADE @ONT:patch/115/import/US/oexwford.wft

After Modify:
# file-version-parsed ont patch/115/import/US oexwford.wft 120.8.12000000.10

exec fnd bin WFLOAD bin &phase=daa+52 checkfile:ont:patch/115/import/US:oexwford.wft &ui_apps 0 Y FORCE @ONT:patch/115/import/US/oexwford.wft

4 comments:

  1. From the menu in Workflow Builder, choose Help > About Oracle Workflow Builder 2.6.
    Change the Access Level to 0 and select allow modifications of customized objects.

    ReplyDelete