Employee National identifier

Hi,

This could happen if you have a custom database policy created on that table column.
Maybe someone has used the Blitz Report VPD feature to prevent users from seeing the national identifier data?
In that case, you can use the profile option ‘Blitz Report VPD Policy Rule’ to individually grant access to that data through Blitz Report.

Can you please run the following query and let us know the results:
select dp.* from dba_policies dp where dp.object_name=’PER_ALL_PEOPLE_F’

Thanks and regards,
Andy

Hi,

This means that someone ran the VPD policy creation program for Blitz Report in your environment.
Could you find out who ran it and for which purpose?

If you keep your concurrent request history in an archive table somewhere, you could query it for the concurrent program ‘Blitz Report Update VPD Policies’.
Or you could check if someone has updated the example records in lookup type XXEN_REPORT_VPD_POLICY_TABLES via report FND Lookup Values.

In case this was done by mistake, we can easily remove the Blitz Report policies by running the program ‘Blitz Report Remove VPD Policies’.

Regards,
Andy