I am trying to create a custom security profile in Oracle HRMS. So I went to the 'Security Profiles' screen -> Custom Security tab, check the 'custom restriction' check box and begin typing my SQL where clause. Here is my question:I type this:ASSIGNMENT.grade_id not in ( select grade_id from per_grades where PER_GRADES.NAME not like 'G%' or PER_GRADES.NAME not like 'M%') and it all works fine.However, if I type per_all_assignments_f instead of ASSIGNMENT,
How could that be possible when Flexfield Rules are in place.Also, if logging in to Global SOB with CI GL ARGENTINA MANAGER, are able to view all the Journals of say TAIWAN or CHILE or UK at the Header Level/choose batch for Reversing/Posting even if are not logged on to their specific Responsibility.
Is it feasible to delete an Exclude statement in order to resolve a Security Rule issue? Example of issue: A user in Argentina Entered a Journal Entry. Another User from Chile Posted the Argentina Entry in Global SOB. And later reversed it as well.
The Security rule should not be modified by deleting an exclude or include as it may corrupt the rule. One should try to delete all rule lines (include and excludes) save and redefine the include and exclude
In General Ledger,a security rule of a parent with children, was setup to include the parent and assigned to a responsibility however, it is not functioning properly.
System allows the account the customer wanted but doesn't disallow the ones that are children of the parent values excluded.
Forgot to check the security enabled flag for each segment and it is not updatable. How do I correct this?
Check your Accounting Flexfield Structure possibly it is frozen. Unfreeze the Structure and then you should be able to enable Security for the Segment.
Every Country has a Global Manager or User Responsibility to access Global SOB but it is supposed to limit users to their own Legal Entities. However, an Argentian journal can be posted by the Chilian user. How is this possible?
This is working as intended. Security rules will prohibit a responsibility from being able to enter in certain values as well as prohibit the viewing of those values as well. However security rules will
Can Security Rules prevent users in one organization in the same set of books from adding Cross Validation Rules to another organization?
There is not a way in the same set of books, to prevent users from one operating unit via security rules, from changing cross validation rules for another operating unit. The only way to do this would
Flexfield Value Security gives you the capability to restrict the set of values a user can use during data entry. With easy-to-define security rules and responsibility level control, you can quickly set
Security rules apply only with regards to creation/modification of lines within a journal. They do not apply when the journal is posted.
View page [1] 2 Next >>
Go Top
