Workflow - Release Customer Order

Question

Hello All, I’m trying to build a simple workflow to Release a CO when a certain Order Type is used.Before starting with the workflow, I debugged the Release operation to know exactly which Projection to invoke:QuickOrderFlowHandling.svc/ProcessOrders{"Selection":"ORDER_NO=11691^","StartEvent":"20","CreateRentalTrans":null}I’ve built my Selection variable exactly as needed, but I still get an error even if I believe the arguments passed should be OK."ORA-20181: QuickOrderFlowHandling.ACCESS_FAILURE: Arguments used to execute current operation are not allowed.
ORA-06512: at "IFSAPP.ERROR_SYS", line 140
ORA-06512: at "IFSAPP.ERROR_SYS", line 685
ORA-06512: at "IFSAPP.QUICK_ORDER_FLOW_HANDLING_SVC", line 3647
ORA-06512: at "IFSAPP.QUICK_ORDER_FLOW_HANDLING_SVC", line 2952
ORA-06512: at "IFSAPP.QUICK_ORDER_FLOW_HANDLING_SVC", line 1423
ORA-06512: at line 2
",  The CO that I’m debugging with is Planned, so release is possible: I would really want this WF to work, otherwise I will create a custom event with a PL/SQL block of code.

kamnlk · Accepted Answer

There is an issue with the way you are referring the variables

you need to use execution.getVariable to get the reverent variable to the code. and since you are using Result variable and the code line seems to be a one liner, no need to declare the js variable using var key word.

for eg:

alternatively, you can also use execution.setVariable(<variable name>, <value variable>)l to set variables.

eg:

In the Projection delegate task you need to use expression language syntax to refer the variable

eg:

Marcel.Ausan · Answer

@kamnlkthanks for the response. I have managed to get further, but unfortunately there’s a rollback inside the routine and therefore I can’t use WF for this purpose. I guess I’m gonna stick with the PL/SQL event action."ORA-00034: cannot ROLLBACK in current PL/SQL session
ORA-06512: at "IFSAPP.CUSTOMER_ORDER_FLOW_API", line 2686
ORA-00034: cannot SET SAVEPOINT in current PL/SQL session
ORA-06512: at "IFSAPP.CUSTOMER_ORDER_FLOW_API", line 2318
ORA-06512: at "IFSAPP.CUSTOMER_ORDER_FLOW_API", line 2107
ORA-06512: at "IFSAPP.CUSTOMER_ORDER_FLOW_API", line 4890
ORA-06512: at "IFSAPP.CUSTOMER_ORDER_FLOW_API", line 2870
ORA-06512: at "IFSAPP.QUICK_ORDER_FLOW_HANDLING_SVC", line 2967
ORA-06512: at "IFSAPP.QUICK_ORDER_FLOW_HANDLING_SVC", line 1423
ORA-06512: at line 2
",

Workflow - Release Customer Order

2 replies

Reply

Reply

Did you find what you're looking for? If not:

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded