R12.2_Long running custom concurrent program Supplier closing Balance

R12.2_Long running custom concurrent program Supplier closing Balance

EBS Release 12.2.9

Database Version 19.6

Program is inactive with below running in background for hours.

/* Formatted on 6/22/2024 3:46:59 PM (QP5 v5.336) */
DECLARE
PRAGMA AUTONOMOUS_TRANSACTION;
BEGIN
UPDATE fnd_concurrent_processes
SET process_context = :pc
WHERE session_id = USERENV ('sessionid')
AND process_status_code = 'A'
AND os_process_id = :op
AND manager_type = '1';

COMMIT;

END;

—————-