Format Payment Instructions - ccm starts but processing is delayed
So sometimes the concurrent request for the "Format Payment Instructions" will start running but, in looking at the log, it looks like there is an extended wait before the job can actually execute.
For example, concurrent request id 31342505 start at 10:33:41 but in the log I see:
IBY_FD_PAYMENT_FORMAT: Format Payment Instructions
+---------------------------------------------------------------------------+
Current system time is 31-JUL-2019 10:33:41
+---------------------------------------------------------------------------+
FDExtractAndFormatting->runProgram():TEST
RequestId:(TEST)31342505
Start time:(TEST) Wed Jul 31 10:39:53 CDT 2019
I am guessing there is some lock or incompatibility that kept the job from actually executing but my users are frustrated that the process sometimes takes 6-15 minutes.
Can someone help me understand what is going on and if there is a way to improve performance? We are on 12.2.5 of EBS