Hi Workflow Gurus,
We are upgrading from 12.1.3 to 12.2.6 and trying to migrate the customized (CUST_VERIFY_AUTHORITY_PROCESS) GLBATCH workflow. I applied the customizations to the 12.2.6 version of the seeded workflow, I was able to save it to the DB by setting access level to 100. However when I reopen it all the processes open a blank window even though I see contents in the tree structure. And the workflow isn't working either. Any idea what is going on here??
Clicking on Approve button from JE screen gives below error:
APPROVE_BATCH.start_approval raised unhandled exception.
Error I get when I try to reupload the workflow using WFLOAD command with FORCE option:
Activity
'CUST_VERIFY_AUTHORITY-1' has no out transition
Activity
'NOTIFY_PREPARER_OF_NO_APPROVER' has no out transition
Activity
'NO_MANAGER_PROBLEM_FIXED' has no out transition
Activity
'NOTIFY_PREPARER_OF_NO_APPROVER' has no out transition
Activity
'NO_MANAGER_PROBLEM_FIXED' has no out transition
Activity
'NO_MANAGER_PROBLEM_FIXED-2' has no out transition
Activity
'NOTIFY_PREPARER_OF_NO_APPROVER' has no out transition
Activity
'NO_MANAGER_PROBLEM_FIXED' has no out transition
Activity 'CC_DIR_MANAGER' has no
out transition
wferr:
- 382: Design Validation
generated 3 warning(s). You may save invalid definitions but they should
not be used in running process.
----
- 403: 'SAVE' validation
failed for subprocess tree under activity 'GLBATCH/GL_JE_APPROVAL_PROCESS'.
- 402: Should not reuse
process 'GL_REQUEST_APPROVAL_PROCESS'.
----
- 403: 'SAVE' validation
failed for subprocess tree under activity 'GLBATCH/GL_APPROVAL_PROCESS'.
- 402: Should not reuse
process 'GL_REQUEST_APPROVAL_PROCESS'.
----
- 354: 'SAVE' validation
failed for activity 'GLBATCH/CUST_VERIFY_AUTHORITY_PROCESS'.
- 362: Validation failed
for child activity 'GLBATCH/CUST_VERIFY_AUTHORITY'.
- 358: Activity result
code 'FAIL' has no transition defined for it. All valid result codes must
be modeled with specific transitions or a <Default> transition.
Access level: 20, Mode: FORCE
wferr:
- 1602: Could not save.
- 1400: Could not save to
database. MODE=FORCE EFFDATE=<null>
- 1401: Could not upload
ACTIVITY entity 'GLBATCH/CUST_VERIFY_AUTHORITY_PROCESS'.
- 210: Oracle Error:
ORA-00001: unique constraint (APPLSYS.WF_PROCESS_ACTIVITIES_U2) violated
ORA-01403: no data found
ORA-06512: at
"APPS.WF_LOAD", line 1974
ORA-06512: at line 1. SQL
text: BEGIN WF_LOAD.UPLOAD_PROCESS_ACTIVITY(:process_item_type, :process_name,
:process_version, :activity_item_type, :activity_name, :instance_id,
:instance_label, :protect, :custom, :start_end, :default_result,
:icon_geometry, :perform_role, :perform_role_type, :user_comment,
:level_error); END;
Really appreciate a quick response on this!
Thanks,
Srini