Sporadic SQL Exceptions in User Interface - ORA-12001:error signalled in parallel query server P000 ORA-20113:policy predicate has error
(Doc ID 741121.1)
Last updated on FEBRUARY 03, 2019
Applies to:Oracle Transportation Management - Version 5.5 and later
Information in this document applies to any platform.
***Checked for relevance on 14-Nov-2013***
-- Problem Statement:
On 5.5.04, When attempting to search for an Order Number in OTM, the following error occurs:
java.sql.SQLException:ORA-12001:error signalled in parallel query server P000 ORA-20113:policy
predicate has error
-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. Log on to OTM and search for Orders using Order Number
2. See tthe parallel query error
-- Business Impact:
The issue has the following business impact:
Due to this issue, users cannot search for orders
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