Oracle Apps Security Interview Questions

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...

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...

I have defined a security rule and assigned it to my responsibilty, but is still does not work, why?

Make sure that you have enabled security at both the segemnt and value set levels, it must be enabled at both these levels to work. Also make sure you have switched out and back into the responsibility.

My security rules don't work for the account analysis and general ledger reports in release 11.0.3.

This functionality is available starting in release 11i. In releases 11 and lower, one cannot set security for standard reports. Security rules will only limit users from a few functions (e.G. Account inquiry, budgets, journal entries, and fsgs). In addition, in release 11i there is limited use of the...

In rel 11i with the intercompany segment being used, is it possible to have a security rule on the balancing segment (company) without it affecting the intercompany segment, since they share the same value...

Yes it is possible. You would enable security on the value set, but then on the flexfield segment (intercompany) you would not enable security.

Is there a way to assign different security rules to a responsibility  based on the user id?

You cannot apply different security rules to the same responsibility for different users based on the user id. You will have to create a new responsibility and define its own security rules. Then you can assign the new responsibility to one of the users.

Can security rules be used to control the posting of journal entries?

Security rules apply only with regards to creation/modification of lines within a journal. They do not apply when the journal is posted.

Security rules don't seem to work on all forms when performing a query.

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 up data entry security on your flexfield segments and report parameters. Flexfield value security...

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 to be create  a separate set of books for each operating unit. Since security rules prevent users...

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...

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 not prohibit the actions above because they are in the same set of books. The system does not determine...

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.  

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.

Is it feasible to delete an exclude statement in order to resolve a security rule issue?

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 the way that it should work and save. If the rule still doesn't work, it may be necessary to...

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...