WFLOAD - Workflow Migration

WFLOAD Download Command

$ WFLOAD apps/${xx_appspassword} 0 Y DOWNLOAD AGWOCOMP.wft <Type Internal Name>
$ WFLOAD apps/***** 0 Y DOWNLOAD $AGCST_TOP/workflow/AGWOCOMP.wft AGWOCOMP

WFLOAD Upload Command

$ WFLOAD apps/${xx_appspassword} 0 Y UPGRADE $ROI_TOP/admin/NAME_ACC.wft

WFLOAD <apps/pwd> 0 Y {UPLOAD | DOWNLOAD | UPGRADE | FORCE} [@<appl-shortname>:]<filepath> [<item type>]

******************************************************

WFLOAD Upload Issue due to NLS_LANG Characterset:

  wferr:
  - 1300: Could not load.
  - 1223: Parse error in line 1141ׂÍA“Á’è‚̃wƒbƒ_[‚É‘®‚µ'.
  - 1203: Warning: line 1141: unescaped quote.
  - 1217: No equal siׂÍA“Á’è‚̃wƒbƒ_[‚É‘®‚µ' truncated to within 30 bytes.
Reason: The NLS_LANG environment variable was not appropriately set for the environment.
Solution: Once NLS_LANG was set to japanese_Japan.JA16SJIS, the .wft file loaded without error. for the file wrongly Arabic Language was set

*********************************************************

WFLOAD Issue ORA-01480 trailing null missing from STR bind value

$ WFLOAD apps/${xx_appspassword} 0 Y DOWNLOAD SERVEREQ.wft SERVEREQ
>>> Item type SERVEREQ
wferr:
  - 1114: Could not load from database.
  - 1115: Could not load all definitions referenced by 'SERVEREQ' item type.
  - 1115: Could not load contents of 'SERVEREQ' item type.
  - 1101: Could not load item types from database. FILTER=SERVEREQ
  - 210: Oracle Error: ORA-01480: trailing null missing from STR bind value.  SQL text: SELECT protect_level, custom_level, name, display_name, description, wf_selector, read_role, write_role, execute_role,        persistence_type, to_char(persistence_days) FROM   wf_item_types_vl WHERE  name like :itemtype ORDER BY name

There are possible three solutions for this issue, verify and implement, whichever is applicable to you:


Check#1: Workflow Internal Name is More than 7 Character Long?

Is it happening for longer than 7 Characters Long or All(Workflow Internal Name), try to down POAPPRV(PO Approval Workflow and Verify the same.
If Check#1 fails, check the Patch#11838073. This is applicable for 12.1.1, 12.1.2 and 12.1.3.
For release 12.0.x oneoff   12361895 - 1OFF:9440402:12.0.4:12.0.4:ORA-01480 WHEN TRYING TO DOWNLOAD 8-CHARACTER LONG
Apply Patch 12361895:R12.OWF.A and it's pre-reqs in a test environment.

Check#2: Protection Level of Workflow Definition are Different?

Is it happening for some workflows and some are going successful, Protection Level of Workflow Definition are Different?
If this is the case then the probable reason is mismatch in the protection level of the workflow definition

Successful:
WFLOAD apps/${xx_appspassword} 0 Y DOWNLOAD POAPPRV.wft POAPPRV
Failure:
WFLOAD apps/${xx_appspassword} 0 Y DOWNLOAD PAWFPPWP.wft PAWFPPWP

Verify the Protection Level of Workflow Definition using following command:
SELECT protect_level, custom_level, name, display_name, description, wf_selector, read_role, write_role, execute_role, persistence_type, to_char(persistence_days) FROM wf_item_types_vl WHERE name like 'PAWFPPWP' ORDER BY name;

Relinking the WFLOAD Executable would resolve the issue:
$ cd $AD_TOP/bin
$ adrelink force=y "fnd WFLOAD"

Check#3: Is it happening for OKSKPRCS ITEM_TYPE Only?

Check if the file versions are lesser than these:
wfdes.lc 120.3.12000000.2
wfldr.lc 120.3.12000000.2
If yes, Apply Patch 12361895:R12.OWF.A and it's pre-reqs in a test environment.