My Oracle Support Banner

OBP Auto Jobs (PMSAJBPR) Not Updating JOB_EXEC_STATUS And Not Running. (Doc ID 3006118.1)

Last updated on FEBRUARY 27, 2024

Applies to:

Oracle Banking Payments - Version and later
Information in this document applies to any platform.


On : version, Production Support

OBP Auto Jobs (PMSAJBPR) not updating JOB_EXEC_STATUS and not running.

The job executes and Next Execution Date is updated, but the JOB_EXEC_STATUS in PMTB_JOB_RUN_MASTER stays in 'P' (Pending) status.

On further analysis, we could observe ACTIVE DB sessions from application that are trying to Update table PMTB_JOB_RUN_MASTER but are blocked by another INACTIVE session. Since the blocking session is inactive, we are unable to identify the last run sql. We can see the table PMZB_JOB_RUN_MASTER is locked in gv$locked_objects table as well.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.