OE_ORDER_PUB.process_order Split issue.
Happy Saturday!!!
Thank you in advance for any advice!!!
I am customizing the OEOL workflow, the WF have an activity (PL/SQL) that verifies if the item quantity in the line is allowed (Allowed quantity is a DFF attribute)
The condition is something like this:
IF item.attribute1 > order_line.quantity then
Split_Line()
End If
The split line process is a call to the API OE_ORDER_PUB.process_order. The API is working fine and the WF OEOL for the original line is working as expected.
The issue I found is in second line (split line), the workflow is starting but since is using the same workflow, is also calling to the SPLIT_LINE process, the logic inside is preventing the line to be split again but the WF activity is not processing, it get stuck in the with a NOTIFIED status.