My Oracle Support Banner

When Adding Over 100 Value To User Customer Attribute AGILEUSER.CUSTOMER Does Not Store Over 100 Value (Doc ID 2352330.1)

Last updated on JANUARY 23, 2018

Applies to:

Oracle Agile PLM Framework - Version 9.3.4.0 and later
Information in this document applies to any platform.

Goal

ACTUAL BEHAVIOR
When adding over 100 values to Customer attribute of User object,
AGILEUSER.CUSTOMER does not add all customer id, but 32 values only.
On the Web Client, customer field shows over 100 values.

STEPS
The issue can be reproduced at will with the following steps:

  1. Login to Java Client
  2. Go to Admin > Data Settings > Lists
  3. Search Customer List
  4. Go to List and add more then 100 values such as.

    1
    2
    3
    ....

    150
  5. Login to Agile Web Client in user:USER1
  6. Go to My settings and assign 3 values to customer attribute

    Customer : 100, BMW, IBM

  7. Run following SQL in agile user

    select customer from agileuser where loginid = 'USER1';

    CUSTOMER
    ----------------
    ,3798038,3,8,

  8. Go back to Web Client and press Edit button
  9. Add more then 150 customer value

    Customer : 1; 10; 100; 101; 102; 103; 104; 105; 106; 107; 108; 109; 11; 110; 111; 112; 113; 114; 115; 116; 117; 118; 119; 12; 120; 121; 122; 123; 124; 125; 126; 127; 128; 129; 13; 130; 131; 132; 133; 134; 135; 136; 137; 138; 139; 14; 140; 141; 142; 143; 144; 145; 146; 147; 148; 149; 15; 150; 16; 17; 18; 19; 2; 20; 21; 22; 23; 24; 25; 26; 27; 28; 29; 3; 30; 31; 32; 33; 34; 35; 36; 37; 38; 39; 4; 40; 41; 42; 43; 44; 45; 46; 47; 48; 49; 5; 50; 51; 52; 53; 54; 55; 56; 57; 58; 59; 6; 60; 61; 62; 63; 64; 65; 66; 67; 68; 69; 7; 70; 71; 72; 73; 74; 75; 76; 77; 78; 79; 8; 80; 81; 82; 83; 84; 85; 86; 87; 88; 89; 9; 90; 91; 92; 93; 94; 95; 96; 97; 98; 99; BMW; IBM

  10.  save
  11. Run following SQL in agile user. Only 32 value is added.

    select customer from agileuser where loginid = 'USERA';

    CUSTOMER
    --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    ,3797934,3797943,3798038,3798039,3798040,3798041,3798042,3798043,3798044,3798045,3798046,3798047,3797944,3798048,3798049,3798050,3798052,3798053,3798054,3798055,3798056,3798057,3798058,3797945,3798059,3798060,3798061,3798062,3798063,3798064,3798065,379806

  12. Logout and Login Web Client in USERA.
  13. Go to My settings
  14. Customer value is still showing 150 customer value

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.