Technology Stack - EBS (MOSC)

MOSC Banner

Restrict user report data based on flexfield segment value

Hi,

We are on R12.1.3 with only one Operating Unit.

We want to restrict report data based on users department which is maintained using second segment of accounting flexfeild. What is the best way to restrict data based on flexfield segments.

For ex:

We are segregating department data based on our second segment of general ledger flexfeild.

01-301-15000-00000-00000           -          301 - Construction Division

01-401-15000-00000-00000           -          401 - Lift Division

When a user of 301 division runs General Ledger (180 Char) char, report should not include any data for 401 segment.  I tried to implement value set security but this will  only work with a

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