This discussion is archived
0 Replies Latest reply: Dec 9, 2011 8:03 AM by user12957520 RSS

Set-up Business Unit Security - Business Unit Security Definition Revision

user12957520 Newbie
Currently Being Moderated
Hi,
I have created some business units and I want to setup the BU security.
I go into the form: Set-up Business Unit Security - Business Unit Security Definition Revision, on BU Type I fill the value: BS, on Business Unit Definition Table I fill the value: F0006, which coresponds to "Business Unit Master" table. On the field "Business Unit Definition Data Item" I fill the value MCDC, which is the column that contains the valid business unit values.
But there is displayed the error:

Invalid Table/Column combination.
     
CAUSE: The column is not included in the table.
RESOLUTION: Select a column that is included in the table.

I query from the database and I see that this column exists in the database.
Please help me to solve this problem.

select * from JDEDATA900.f0006

SQL> desc JDEDATA900.f0006
Name Null? Type
----------------------------------------- -------- ---------------------------

MCMCU NOT NULL NCHAR(12)
MCSTYL NCHAR(2)
MCDC                                               NCHAR(40)
MCLDM NCHAR(1)
MCCO NCHAR(5)
MCAN8 NUMBER
MCAN8O NUMBER
MCCNTY NCHAR(3)
MCADDS NCHAR(3)
MCFMOD NCHAR(1)
MCDL01 NCHAR(30)
MCDL02 NCHAR(30)
MCDL03 NCHAR(30)
MCDL04 NCHAR(30)
MCRP01 NCHAR(3)
MCRP02 NCHAR(3)
MCRP03 NCHAR(3)
MCRP04 NCHAR(3)
MCRP05 NCHAR(3)
MCRP06 NCHAR(3)
MCRP07 NCHAR(3)
MCRP08 NCHAR(3)
MCRP09 NCHAR(3)
MCRP10 NCHAR(3)
MCRP11 NCHAR(3)
MCRP12 NCHAR(3)
MCRP13 NCHAR(3)
MCRP14 NCHAR(3)
MCRP15 NCHAR(3)
MCRP16 NCHAR(3)
MCRP17 NCHAR(3)

.....................


Thank you.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points