I created a Workflow location. But it prompt "The connection was successful, but failed to retrieve workflow version.", when test the connection.
Does this problem affect execution of process flows? How to fix it?
You need to connect with the OWF_MGR user. To do that you need to run the Workflow Configuration Assistant. It is located in:
After completing the assistant you have to give the appropiate privileges to the user:
GRANT EXECUTE ANY PROCEDURE TO owf_mgr;
I know the thread is too old but I had the same issue and since this is the first result when searching for a solution, I wanted to share the solution.