CNC, DB and Operating System - JDE1 (MOSC)

MOSC Banner

Cannot view receipt ledger records with row security of F4102

edited Feb 3, 2020 4:01AM in CNC, DB and Operating System - JDE1 (MOSC) 1 commentAnswered

Hi All,

I have set the row security of F4102 with column MCU to role SP_ROLE, only can view the BP = 74010.

At the P43260 , the receipt records has some records with MCU = 174010( The Finance BP, but this BP not item records in the Item Branch.)

SP_ROLE also need view records like 174010 MCU, I simulation the View of P43260 grid with SQL statement, the F4102 table return NULL.

After add security records like below, But cannot view either.

SP_ROLE    F4102    Item Branch File       7000074010    4    Row Security    CostCenter    MCU    Y    Y    Y    Y    41
SP_ROLE    F4102    Item Branch File        *BLANKS

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