Why does Select * From Qp_secu_list_headers_v NOT return rows when pricing security is turned on? (Doc ID 2253468.1)

Last updated on APRIL 10, 2017

Applies to:

Oracle Advanced Pricing - Version 12 and later
Information in this document applies to any platform.

Goal


The following query returns no rows/records when pricing security is turned on:

       select * from qp_secu_list_headers_v;


Yet the query will return rows/records when pricing security is NOT turned on.
 

Why does the query return no row/records when pricing security is turned on?

Solution

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