Hi,
We have implemented workflow using parallel task plugin where plugin creates 2 different tasks, we are currently utilizing workflow using APEX DB Objects/API for Workflow and Tasks.
I want to know best practice or what oracle recommends for internal DB tables:
- Should we create new entry of Workflow and Task Data in a separate DB tables or we can continue using APEX_WORKFLOWS and APEX_TASKS as master source and store WORKFLOW_ID and TASK_ID where required?
- Will data of APEX_WORKFLOWS and APEX_TASKS table gets purged after some period?
- For APEX_TASKS we have DETAIL_PK column, is it recommended to use multiple values and store it in JSON?
- What are the recommendations for Backup/Restore if we continue to use APEX_WORKFLOWS, APEX_TASKS and many other supported tables such as APEX_WORKFLOW_PARTICIPANTS, APEX_TASK_PARTICIPANTS etc.?
Thanks.
Sohilkumar Bhavsar.