What would be a good approach if I want to update a field on Request A when Request B moves forward. Also how would I put a function in the Execution should I type the whole Function there or just the name of the Procedure.
Re: Updating a Field in RequestA when RequestB moves
There surely is more than one way. You could use an PL/SQL function (stored in the DB and called in the execution step), or you could a read-only field in RequestA that is populated by a rule that triggers on page-load. You cannot use stored procedures in execution steps because they don't have a return value. If you want to use a stored procedure to do the updates between RequestA and RequestB on a certain schedule, this can be done with a PPM report (command: ksc_run_plsql_procedure).