Creating workflow from scratch Part 2
Once the Process is created then we need to design the Process:
To Design any Process in Workflow it should start with One start Function and we get it from WFSTD. Just we need to drag and drop the start and end functions from the Standard Functions:
Even when we import the Start function go to its properties and we need to mention it should be a start:
Note: Any Process can have only one Start but can have any number of ends depending upon the Business logic’s complexity.
Similarly change the properties of the end function:
Click on OK button.
Now we need to create a Custom Function that has the business logic. You can have the Function call your plsql function or Java Class or any external application. We can mention the PLSQL Function Name in the Function Name field in the properties of the Function.
We can mention the result type if any Result is returned from the plsql Function:
Once the function is created just drag and drop the function between START and END Functions. Once the Function is placed just by using right click of the mouse draw the Flow how the process to be. Always The Process would be starting from Start and No Functions can be in the Process without coupling to another in the flow. Always the flow should end using and END function.
Now Verify the workflow and save in the data base or the (desktop and upload using wfload).
Once the workflow is saved in the data base which usually takes time we can test it using below queries:
WHERE name = 'XAOATEST';
NAME PROTECT_LEVEL CUSTOM_LEVEL WF_SELECTOR READ_ROLE WRITE_ROLE EXECUTE_ROLE PERSISTENCE_TYPE PERSISTENCE_DAYS SECURITY_GROUP_ID NUM_ACTIVE NUM_ERROR NUM_DEFER NUM_SUSPEND NUM_COMPLETE NUM_PURGEABLE
XAOATEST 1000 0 TEMP 0
WHERE process_item_type = 'XAOATEST';
PROCESS_ITEM_TYPE PROCESS_NAME PROCESS_VERSION ACTIVITY_ITEM_TYPE ACTIVITY_NAME INSTANCE_ID INSTANCE_LABEL PERFORM_ROLE_TYPE PROTECT_LEVEL CUSTOM_LEVEL START_END DEFAULT_RESULT ICON_GEOMETRY PERFORM_ROLE USER_COMMENT SECURITY_GROUP_ID
XAOATEST AOAMAIN_PROCESS 1 WFSTD START 803292 START CONSTANT 0 0 START -560,-160
XAOATEST AOAMAIN_PROCESS 1 WFSTD END 803294 END CONSTANT 0 0 END -208,-160
XAOATEST AOAMAIN_PROCESS 1 XAOATEST XXAOA_TEST_WF_FUNC 803296 XXAOA_TEST_WF_FUNC CONSTANT 0 0 -400,-160
XAOATEST ROOT 1 XAOATEST AOAMAIN_PROCESS 803291 AOAMAIN_PROCESS CONSTANT 1000 0
The data in WF_PROCESS_ACTIVITIES table explains the complete details of the workflow item type. Like how many Process, Functions, etc. with its versions.