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 SEPTEMBER 08, 2016

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***


Symptoms

-- Problem Statement:
On 5.5.04, When attempting to search for an Order Number in OTM, the following error occurs:

ERROR
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

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms