Distribution - JDE1 (MOSC)

MOSC Banner

Row Level Security on Inventory Transaction

edited Jan 24, 2014 10:12AM in Distribution - JDE1 (MOSC) 2 commentsAnswered
We are trying to implement row level security to restrict inventory transactions by Branch/Plant. We do not want users in one Branch/Plant to be able to transact inventory under another Branch/Plant.

The thought was to create a role that would only contain the row security and apply that to the users who need to be restricted.

The primary programs we are looking to limit are:

  • P4112
  • P4113
  • P4114
  • P4205
  • P4312

My inclination is to place the security on the F4111. Is this enough to catch prevent all these functions? My fear is that the transaction table might pass through some other tables before hitting the F4111 creating incomplete transactions and orphan records.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center