My Oracle Support Banner

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

Last updated on MAY 06, 2022

Applies to:

Oracle Transportation Management - Version to [Release 5.5]
Information in this document applies to any platform.


-- Problem Statement:
On, 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 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


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

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