Oracle Transportation Management VPD May Not Return Expected Number of Rows within PL/SQL Stored Procedure
(Doc ID 2497493.1)
Last updated on MAY 06, 2022
Applies to:Oracle Logistics Inventory Visibility - Version 6.4.3 and later
Oracle Customs Management - Version 6.4.3 and later
Oracle Fusion Transportation Intelligence - Version 6.4.3 and later
Oracle Transportation Sourcing - Version 6.4.3 and later
Oracle Forwarding and Brokerage Operations - Version 6.4.3 and later
Information in this document applies to any platform.
VPD may not return expected number of rows within PL/SQL stored procedure if procedure code changes application user context from previous user by executing vpd.set_user(_r) in the same database session and expect different number of rows from previous user. Stored procedure returns expected number of rows if executed in different database session.
This applies to PL/SQL packages and function too. These symptoms appears on database version 12c and above.
This does not apply to JDBC SQL calls originating from the application.
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