Copying/Editing an Order Release Causes java.sql.SQLException: ORA-00904 (Doc ID 744423.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

Oracle Transportation Management - Version 5.5.04.03 to 5.5.04.04 [Release 5.5]
Information in this document applies to any platform.
***Checked for relevance on 02-Apr-2012***


Symptoms

-- Problem Statement:
On 5.5.04.03, When attempting to Update or Copy an order release by an user who is set with a VPD
to restrict the Order Release on source location GID, the following error occurs:

ERROR
ERROR at line 1:
ORA-00904: "SOURCE_LOCATION_GID": invalid identifier
ORA-06512: at "GLOGOWNER.VPD", line 26

-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1.Set up a VPD that is set with a predicate on the order release tp restrict it based on
SOURCE_LOCATION_GID with the Access being set to read and update
2. Set a user with an user role that is attached to this VPD
3. Log on as that user and try to update the Order or copy the order and see that the error appears

-- Business Impact:
The issue has the following business impact:
Due to this issue, users with VPD s cannot update or copy order releases

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