My Oracle Support Banner

How Can One Set Value Since MO_GLOBAL.init('QP') Is Not Returning All Rows In the Pricing Table QP_LIST_HEADERS_B? (Doc ID 1673853.1)

Last updated on MARCH 28, 2018

Applies to:

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

Goal

When we run the MO_GLOBAL.init it does not retrieve all records from QP_LIST_HEADERS_B table.
First time running without MO_global.init we get back all records in the table

select count(*)
from qp_list_headers_b;

record count=1767

Then we run this

exec mo_global.set_policy_context ('S', 116);

select count(*)
from qp_list_headers_b;

record count=1124




then this:

exec mo_global.set_policy_context ('S', 7435);

select count(*)
from qp_list_headers_b

record count=282

Then we try to run this based on https://community.oracle.com/message/9973071

exec mo_global.init('QP');

select count(*)
from qp_list_headers_b

record count=1124


How do we get the process to return all rows regardless of what operating unit we are?
 

Solution

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
Goal
Solution
References


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