My Oracle Support Banner

Oracle Transportation Management VPD May Not Return Expected Number of Rows within PL/SQL Stored Procedure (Doc ID 2497493.1)

Last updated on JULY 20, 2024

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
 Further Reference

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