EBS Customizations (MOSC)

MOSC Banner

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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center