Wednesday 21 February 2018

FND_CONC_PP_ACTIONS Action Types

The table FND_CONC_PP_ACTIONS stores about post processing actions.  The action_type column shows type of action according to below values:
1 indicates printing
2 indicates Notification
4 PLSQL procedure
6 Output post processor log.

Wait for concurrent program (WAITFORCONCURRENTPROGRAM) node details


The Workflow activity "Wait For Concurrent Program" waits for the concurrent program to be complete before proceeding with the other actions, Internally the flow is like below:

The activity uses PLSQL pakcage fnd_wf_standard.Seed_CB to verify if the program is complete and waits for average program time and then checks if the program is complete. If complete it returns a value to continue with the workflow. If the program is not complete and not running then it seeds concurrent request post processor actions (FND_CONC_PP_ACTIONS) to notify the workflow back when the program is complete.  The concurrent post processor complete post processor action i.e  FND_WF_STANDARD.callback to notify the workflow and to continue further.