i working in oracle hcm fusion application. writing extract rule batch loader fast formula. in 1 of extract rule formula using dbi per_hist_asg_assignment_number returning 0, no values in dbi. problem dbi internally refer secured view per_assignment_secured_list_v. if query table bi publisher not getting rows. 1 suggest data role missing. can tell me exact datarole should add acces values dbi.
this view based on security profile added in employment bu,department,location etc. try retrieve records super user or implementation user not attached security profile, results.
Comments
Post a Comment