My Oracle Support Banner

Pricing Security Privileges Setup In R12 (Doc ID 827703.1)

Last updated on JUNE 21, 2023

Applies to:

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

Symptoms

 

 

Note: In the images bellow and/or the attached document, user details / company name / address / email / telephone number represents fictitious sample (based upon made up data used in the Oracle Demo Vision instance). Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

 

In R12, after setting the privilege 'view only' for global, the global user when trying to update the price list attribute
and save it it shows "transaction applied and saved" . On re-querying the price list the changes are not saved.

Steps To Reproduce:

1) Login to the application as <user_1>/<user_1_password>
2) Go to Oracle Pricing Administrator Setup : Security
3) Go to Privileges
4) Express Create Privilege
5) Entity type: Standard price List
Price List Name : Corporate
Grantee type : User
Grantee name : <user_1>
Access Level - Maintain
Apply
6)Go to Privileges
7) Express Create Privilege
8) Entity type: Standard price List
Price List Name : Corporate
Grantee type : Global
Grantee name :
Access Level - View Only
Apply

Log off, login as <user_2>/<user_2_password>
Queried the price list .
Changed the description.
Save it. Transaction Applied Ad Saved.
Close the form , again re-query it the item description showed as saved but doesn't change.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
 Warnings:
BEFORE turning on pricing security, you must create privileges for existing pricing entities.
References

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