Sub ledger Account table - Data Visibility

Summary

Sub ledger Account tabl: Data Visibility for XLA_TRANSACTION_ENTITIES table.

Content

We are trying to build a BI Publisher report for extracting data for Sub ledger Account tables.

 

XLA_EVENTS,

XLA_AE_HEADERS,

XLA_AE_LINES,

XLA_DISTRIBUTION_LINKS and

XLA_TRANSACTION_ENTITIES

 

While building SQL query/Data model, we don’t see data for one of the table ‘XLA_TRANSACTION_ENTITIES’

 

Looks like this is a secured table and it requires certain roles like ‘Accounts Payable Manager’ etc… with right context for BU’s for data visibility.

 

Have any one come across this issue?

 

Where can I get the complete list of Roles that can be added to an user for extracting the entire data from this table.