Error INV INV_INVALID_ARG_NULL_VALUE
When an ECO being released from Agile PLM, getting below error in AIA PIP
Org Code MST ECO Name ECO00018 Err Msg INV INV_INVALID_ARG_NULL_VALUE
This could be because, category set which is being sent from Agile is not valid Oracle EBS.
You need check, if the category set is valid in Oracle EBS or not.
Use below code for the same,
SELECT (segment1)|| '.'
|| (segment2)|| '.'
|| (segment3)|| '.'
|| (segment4)|| '.'
|| (segment5)|| '.'
|| (segment6)|| '.'
|| (segment7) cat_set,
mc.segment1,
mc.segment2,
mc.segment3,
mc.segment4,
mc.segment5,
mc.segment6,
mc.segment7
FROM mtl_categories_b mc
WHERE enabled_flag = 'Y'
AND NVL (end_date_active, SYSDATE) >= SYSDATE
AND (segment1)
|| '.'|| (segment2)
|| '.'|| (segment3)
|| '.'|| (segment4)
|| '.'|| (segment5)
|| '.'|| (segment6)
|| '.'|| (segment7) LIKE '&p_cat_set';
Make sure you have the category defined in Oracle and try to resubmit the ECO from AIA queue.
When an ECO being released from Agile PLM, getting below error in AIA PIP
Org Code MST ECO Name ECO00018 Err Msg INV INV_INVALID_ARG_NULL_VALUE
This could be because, category set which is being sent from Agile is not valid Oracle EBS.
You need check, if the category set is valid in Oracle EBS or not.
Use below code for the same,
SELECT (segment1)|| '.'
|| (segment2)|| '.'
|| (segment3)|| '.'
|| (segment4)|| '.'
|| (segment5)|| '.'
|| (segment6)|| '.'
|| (segment7) cat_set,
mc.segment1,
mc.segment2,
mc.segment3,
mc.segment4,
mc.segment5,
mc.segment6,
mc.segment7
FROM mtl_categories_b mc
WHERE enabled_flag = 'Y'
AND NVL (end_date_active, SYSDATE) >= SYSDATE
AND (segment1)
|| '.'|| (segment2)
|| '.'|| (segment3)
|| '.'|| (segment4)
|| '.'|| (segment5)
|| '.'|| (segment6)
|| '.'|| (segment7) LIKE '&p_cat_set';
Make sure you have the category defined in Oracle and try to resubmit the ECO from AIA queue.