My Oracle Support Banner

Agile SDK/API Not Allowing Assigning Inactive List Value To List As In Web Client (Doc ID 2615554.1)

Last updated on NOVEMBER 27, 2019

Applies to:

Oracle Agile Product Collaboration - Version 9.3.6.0 and later
Information in this document applies to any platform.

Goal

Actual Behavior
Agile SDK/API not allowing to assign inactive List value to List as in Web Client

For example there is multilist attribute with list value : A, B, C.
On Item : TEST1, this multilist attribute has A,B set.
B has been latest set to inactive from Java Client side.
Now, on the Web Client side, when editing the multilist attribute,
A, B are both set, and can add C and save.

This operation cannot be performed in Agile API/SDK.

When attempting to add a list value using setValue API on a Mulitlist
attribute, which already has an Inactive List value, it ends with error.

Since there are inactive list values on the multilist attribute of the item,
the SDK code is failing to add new list values as it is using setValue API.

FACT
On 9.3.6, API no longer assign inactive list value to list from below bug.
<Bug:21379495> : API ALLOWS ASSIGNING INACTIVE LIST VALUE TO LIST


ERROR
Error code : 60092
Error message : List value [xxxxxx] is obsolete. You can not select obsolete values.

at com.agile.api.pc.Session.createError(Session.java:2043)
at com.agile.api.pc.APIObject.createError(APIObject.java:87)
at com.agile.api.pc.Row.verifyIsObsolete(Row.java:597)
at com.agile.api.pc.Row.verifyValues(Row.java:572)
at com.agile.api.pc.Row.processParam(Row.java:519)
at com.agile.api.pc.Row.setValue(Row.java:277)
at com.agile.api.pc.Row.setValue(Row.java:302)
at com.agile.api.pc.Cell.setValue(Cell.java:76)

STEP
1. Setup multilist attribute with list value : A, B, C
2. On Item : TEST1, set this multilist attribute with value: A,B set in web client
3. Inactivate list value : B from Java Client
4. On the Web Client side, when editing the multilist attribute, add new value C with existing value A and B.
5. Web Client can be saved.
6. Run same operation on Agile SDK code.


 

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
References


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