ORA-12801:Error Signalled In Parallel Query Server XXXX When Using Vpd

(Doc ID 958862.1)

Last updated on MAY 10, 2017

Applies to:

Oracle Transportation Management - Version 5.5 to 5.5 [Release 5.5]
Information in this document applies to any platform.
***Checked for relevance on 11-Mar-2014***

Symptoms

-- Problem Statement:
When Login as a service provider and Clicking on Shipment Status Maintenance menu item, then enter a valid order release id  and Begins With,

Get the following error :

java.sql.SQLException: ORA-12801:error signalled in parallel query server XXXX ORA-28113:policy
predicate has error

Note: If parallel query is turned off from the shipment table, executing the above steps does not
produce the error.

Extract from trace file showing the following to be causing the error:

Error information for ORA-28113:
Logon user : GLOGDBA
Table/View : GLOGOWNER.ORDER_RELEASE
Policy name : STATICXP_RULE_READ
Policy function: GLOGOWNER.VPD.EXTERNAL_PREDICATE_RULE_READ
RLS predicate :
shipment.servprov_gid IN( (SELECT user_association.user_association_value FROM user_association
WHERE user_association.gl_user_gid = sys_con
text('gl_user_ctx', 'gl_user_gid') AND user_association.user_association_qual = 'SERVPROV') UNION
(SELECT tcs.servprov_gid FROM user_associat
ion ua, tender_collab_servprov tcs WHERE ua.gl_user_gid = sys_context('gl_user_ctx',
'gl_user_gid') AND ua.user_association_value = tcs.dispa
tch_location_gid AND ua.user_association_qual = 'DISPATCH LOCATION') )
ORA-00904: "SHIPMENT"."SERVPROV_GID": invalid identifier

if sql after the union is removed, the application executes with no errors.

-- Steps To Reproduce:
1. Sign on as a service provider
2. Click on Shipment Status Maintenance menu item
3. Enter a valid order release id for e.g. 1223 and Begins With
4. java.sql.SQLException: ORA-12801:error signalled in parallel query server XXXX ORA-28113:policy
predicate has error

Note: If parallel query is turned off from the shipment table, executing the above steps does not
produce the error.

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