My Oracle Support Banner

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:

Oracle Human Resources - Version 12.2 and later
Information in this document applies to any platform.

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

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
Symptoms
Changes
Cause
Solution
References


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