Using R12 MOAC in RDF reports

We can use standard value sets and MOAC tables (synonyms) to show correct data.

Value sets given  -

1) Reporting Level FND_MO_REPORTING_LEVEL

Values will be -
1000 Ledger
2000 Legal Entity
3000 Operating Unit

2) Reporting Context FND_MO_REPORTING_ENTITY
Values will come based on above value set

See some standard reports how they have used these value sets.
Ex - AR Reconciliation Report

How to do?

Create lexical parameter - P_MOAC

srw.user_exit('FND SRWINIT');

/* Multi Org Access Control*/
fnd_mo_reporting_api.initialize(:p_reporting_level,:p_reporting_entity_id, 'AUTO');
:P_MOAC := fnd_mo_reporting_api.get_predicate('acr', NULL,:P_REPORTING_ENTITY_ID );

'acr' -- Alias name of your main table where we have to add where condition.
Ex - acr.org_id = 710

Use lexi parameter in Query - &P_MOAC