MOAC setup from SQL Plus/TOAD
Multi Organization Access Control(MOAC) is maintained using Virtual Private Database (VPD). VPD applies security policies to the tables, views and synonyms. VPD replaced views for operating unit access in R12. In R12, org-specific views are replaced with synonyms Setting operating unit context in R11i exec fnd_client_info.set_org_context(&org_id); Setting Operating Unit context in R12: Single Organization/Operating Unit … Read more