When Try To Terminate One Transaction From Position Transaction Form Error Is Raised “Routine pqh_ptx_utl.set_status Encountered a Fatal Error ORA-20001:You Cannot Make This Transaction As Under Review, Because There Are Pending Transaction(s)..” (Doc ID 2939573.1)

Last updated on JULY 17, 2024

Applies to:

Symptoms

When attempting to terminate a position transaction from the transaction status form, the following error occurs:

ERROR
-----------------------
Routine pqh_ptx_utl.set_status encountered a fatal error ORA-20001: You
cannot make this transaction as Under Review, because there are pending
transaction(s) for this position. Contact System administrator or support representative.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. (N) Global Super HRMS Manager >> Transaction Maintenance>>Transaction Status (Position Transaction) form.
2. Click on Terminate -> Error is raised.

Changes

 N/A

Cause

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