Report is getting zero data
I have
created a report, instance it is working fine on TEST instance (show Data ) but
it is not showing any Data on the UAT instance
And I identified some views are not getting any data on the UAT instance (like
ex- csd_repairs_v) but it is getting data on the TEST instance. This is not
instance issue I guess this is since Row Level Security (we are using multiple
organizations)
I used MO_GLOBAL.SET_POLICY_CONTEXT ('S',101); (org id - 101 hard cored to test
the report ) in after parameter formtrigger (also Before Report trigger) on
report builder but still it is getting zero return in the report