What privilege grants access to data in the Purchase Order Measures folder columns?

Selene Becerra

I have a user who is trying to use columns from the Purchase Order Measures folder in the Procurement - Procure to Pay Real Time subject area. I've created a custom role so that the user can report on Purchase Order data in OTBI and so far all the other columns are working as expected. I'm not sure what area (e.g. Payables, Receivables, Subledger Accounting, etc…) the "Open Ordered Amount" or "Ordered Amount" columns are pulling data from, but the columns are coming up blank in his analysis. Any ideas what privileges or data access are needed? Please keep in mind that I'm purposely not asking what "role" would grant this access because I don't want to assign a delivered role with too much access, like "Buyer" or "Procurement Manager".

RVohra

If I correctly understood the question these two columns come from Purchasing transactional tables, but are secured by Procurement Data Security, NOT by AP, AR, or SLA privileges.

The user’s custom role does not have the required data security policies, so the measures return blank (not even 0 just empty),

Hope it helps!

Bhaskar Konar

https://community.oracle.com/products/oracleanalytics/discussion/27489/what-privilege-grants-access-to-data-in-the-purchase-order-measures-folder-columns

Hi @Selene Becerra,

Welcome to the Oracle Analytics Community!

If you are looking for the subject area: Procurement - Procure To Pay Real Time, use the following:

Duty Role Name: Spend Transaction Analysis Duty Role

Code Name: FBI_SPEND_TRANSACTION_ANALYSIS_DUTY

Hope this help.

Thank you.

Bhaskar Konar

Hi @Selene Becerra,

Please find below the Oracle doc which might be useful for the understanding

https://docs.oracle.com/en/cloud/saas/procurement/24b/faopb/Spend-Transaction-Analysis-Duty-Role-DR-4.html#Spend_Transaction_Analysis_Duty_Role_DR_4_d1e22503

Hope this help.

Thank you.