Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Help with Person Security Profile — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Help with Person Security Profile

Received Response
93
Views
7
Comments
edited Jan 27, 2017 7:55PM in Applications Security 7 comments

Summary

Sql on custom criteria on person security profile

Content

Please see below SQL I have created for Security Profile - it's throwing out a "ORA-28113: policy predicate has error" message Can anyone help? &TABLE_ALIAS.person_id IN (SELECT PAA.PERSON_ID FROM PER_ALL_ASSIGNMENTS_M PAA, PER_JOBS PJ, PER_PERSON_TYPES_TL PPT, PER_PERIODS_OF_SERVICE PPS WHERE ppt.person_type_id = paa.person_type_id AND pj.job_id = paa.job_id AND ( ppt.user_person_type IN ('Retail Management Employee','Retail Employee') OR pj.name IN ('Deputy Store Manager','Store Manager','Store Manager Designate','Senior Store Manager', 'General Manager') ) AND paa.assignment_type in ('E','C') AND paa.period_of_service_id = pps.period_of_service_id AND pl.per_locations = paa.Location_id AND ((pps.date_start = (select max(pps1.date_start) from per_periods_of_service pps1 where pps1.person_id = paa.person_id) and trunc(sysdate) between paa.effective_start_date and paa.effective_end_date) OR pps.date_start > sysdate) AND PAA.LEGISLATION_CODE = 'IE' OR PL.INTERNAL_LOCATION_CODE in ('NEWRY', 'BALLYMENA', 'RUSHMERE', 'FOYLESIDE', 'BELFAST - OSW', 'BELFAST'))
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!