18 Aug 2014

Err Msg INV INV_INVALID_ARG_NULL_VALUE

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.