xla_transaction_entities Not able to see all sources data for Some users

How To See ALL Sources Data

 xla_transaction_entities: This table Comes with Some Data security policy applied to it that the reason we are not able to see all data.In Ebiz we use xla.xla_transaction_entities  table to see all data.

Now in Cloud, we need to provide data security Policy In the data model by using the Below PLSQL block.


DECLARE
type refcursor is REF CURSOR;
xdo_cursor refcursor;

 l_roleguids FND_TABLE_OF_VARCHAR2_4000 := FND_TABLE_OF_VARCHAR2_4000();
 l_rolenames FND_TABLE_OF_VARCHAR2_4000 := FND_TABLE_OF_VARCHAR2_4000();

BEGIN

--MO_GLOBAL.Init('AP_MANAGE_PAYABLES_INVOICE_DATA');
---MO_GLOBAL.Init('AR_VIEW_RECEIVABLES_ACTIVITIES_DATA');


  l_roleguids.extend(1);
  l_rolenames.extend(1);
  l_roleguids(1) := 'A38EFCFAA623F4C538B7F93159ED3614';
  l_rolenames(1) := 'GL_GENERAL_ACCOUNTANT';

--- fnd_global.initialize_session('A38EFCFAA623F4C538B7F93159ED3614','GL_GENERAL_ACCOUNTANT', l_roleguids, l_rolenames);

  xla_security_pkg.set_security_context(602);       -----To see XLA all Sources Data 
  
  
OPEN :xdo_cursor FOR
SELECT SYSDATE RUN_DATE
from dual;


END;




Just add this to your data model to see all kinds of data.

Thank you.