DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Using per_people_f view in reports, does not fetch any data

536755Mar 12 2008

Hi All,

We have defined a dyanamic security profile with restriction based on logged in person.When we query people form, count of employees are correct based on restriction in security profile. but when I run a report for personal detail, it does not fetch any data.I have added SRW.USER_EXIT('FND SRWINIT') in before report trigger and SRW.USER_EXIT('FND SRWEXIT') in after report trigger. I have found that count(*) of per_people_f is 0 in the report using srw.message.

Can any one help me to resolve this issue ?

Thanks