Skip to main content

Hi All,

We are using IFS apps 10. I have noticed that some of the jobs from below code is posted to background jobs screen 1 or 2 or more than two days later after the event action runs. But background jobs are executed ASAP after it gets posted. there is not much delay in that.

Due to this behaviour, we have lot of mismatches. How we can resolve this. 

In below code 'PURCHASE_API.PO_SAVE_NOTE' 

PURCHASE_API - custom package.

PO_SAVE_NOTE- custom procedure.

 

there is no problem with package or procedure, it is working as expected.

Below code is taken from event action.

Also, this behaviour is not occurring all the time, someday it happens for all records, some days for a few and some days running without any issues.

DECLARE
ATTR_ VARCHAR2(2000);
ROWKEY_ VARCHAR2(100) := '&NEW:ROWKEY';

PROCEDURE_ VARCHAR2(200) := 'PURCHASE_API.PO_SAVE_NOTE';
BEGIN
IFSAPP.CLIENT_SYS.CLEAR_ATTR(ATTR_);
IFSAPP.CLIENT_SYS.ADD_TO_ATTR('ROWKEY_', ROWKEY_, ATTR_);
IFSAPP.TRANSACTION_SYS.DEFERRED_CALL(PROCEDURE_, 'PARAMETER', ATTR_, 'Add notes');
END;

 

Best Regards,

Hari 

 @Harikrishnangr in order to start troubleshooting this I would:

  • create a new Batch Queue
  • add PURCHASE_API.PO_SAVE_NOTE to the new batch queue

That way you know that only this job runs on this queue and you could better observe if also this new batch queue will have the same issues.


Reply