Copy Refnum from OB Line to OB

Summary:

Need to Make Schedule Process that runs every 10 min to copy refnum from order base line to order base

Content (please ensure you mask any confidential information):

I managed to make the schedule process that raise event and the action of the agent is just copy all refnum from OB_line to OB

The Setup is as follows

1- Create Automation agent with custom event and the action is copy refnum

2- Create Schedule Process on Order Base Line that runs every 10 min to copy the refnum

The Condition is as follows

SELECT ORDER_BASE_GID FROM OB_LINE WHERE OB_LINE_GID IN (SELECT ORDER_BASE_LINE_GID FROM OB_LINE_REFNUM WHERE INSERT_DATE > SYSDATE - INTERVAL '15' MINUTE)