STEPS TO REPRODUCE:
1. Create dynamic lookup
SELECT @SELECT:prt.prid:[email protected]
, @SELECT:ii.code || '/' || ii.name || '/' ||prt.prexternalid ||'/'||prt.prname:[email protected]
, @SELECT:prt.prexternalid:[email protected]
, @SELECT:TO_CHAR(prt.prstart, 'YYYY/MM/DD'):[email protected]
, @SELECT:TO_CHAR(prt.prfinish, 'YYYY/MM/DD'):[email protected]
FROM RIM_RISKS_AND_ISSUES chg
JOIN inv_investments ii ON 1 = 1
JOIN prtask prt ON prt.prprojectid = ii.id
WHERE @[email protected]
AND prt.pristask != 0
AND prt.prexternalid != 'TIMESHEETACCRUAL'
AND (
chg.ID = @WHERE:PARAM:USER_DEF:INTEGER:[email protected]
)
AND prt.prprojectid IN (SELECT ifh.child_id FROM inv_flat_hierarchies ifh where ifh.parent_id = chg.pk_id)
2. Create MVL attribute on lookup from step 1
ID: db_rsk_assoc_tsk
Multi Valued Lookup - Number
lookup: dependent lookup where OBJECT ATTRIBUTE ID is mapped to [--Object ID--]
3. Create a risk instance and populate values on the MVL attribute.
4. XOG OUT risk instance using default risk_read.xml
5. XOG IN Risk instance
Expected results: XOG IN to be successful.
Actual results: XOG IN fails with XOG-6010: Failed to import risk/issue/change request
Workaround: None (The argument to ignore custom attribute values not appearing to be good for Risk object) e.g, <args name="include_custom" value="false"/>
The issue cannot be replicated on the project object.
Clarity release : 15.9.2
This is caused by Defect DE60917
Defect is currently being reviewed by engineering.