Oracle E-Business Suite Blog

My OTL testing is nearly complete.  The only real issue encountered so far was a problem with workflow.  The test script I was executing required that the approver reject the timecard, sending it back for correction. Logged in as the approver, I rejected the timecard and then logged in as the submitter.  Unfortunately, when I logged in as the submitter, the timecard was still showing a status of "Submitted".  I waited a few minutes to be sure the background process had time to run, and checked again. The timecard remained in "Submitted" status, never showing the "Rejected" status I was expecting.

I logged back in as the approver and was able to see that an error had occured and that "Applsys.Wf_deferred_r" had errors.  I sent the error message over to our technical side and they were able to track down the issue, noted in Metalink document 577875.1.  I was then able to retest and everything worked as expected.

Running through OTL test scripts is not exactly exciting work, but the error showed why it is important to have good test scripts.  The submit and approve steps worked fine.  It was only when testing a submit/reject scenario that the issue with workflow appeared.  Take the time to test every possible combination of steps that might occur.  It is the only way you can be (mostly) sure of no big surprises once the applications goes into production.