This combination of segment values already exists. (ROUTINE=fdfvcc)

Error: Getting error while adding new item in item master in oracle apps r12. This combination of segment values already exists. (ROUTINE=fdfvcc)

Answer: If you have deleted the item from backend, then see no item exists in table ENI.ENI_OLTP_ITEM_STAR. If yes then remove it from there as well.

Find the dates for the given year using query in oracle

1. --Find the dates for the given year using the query in Oracle
2. --Find dates between given date ranges, the same query will be used just tweak the cal_year
3. --Just place year in the given: CAL_YEAR and execute the query to get your result set

SELECT daterange, 
       dayname 
FROM   (SELECT ( To_date(01 
                         ||' ' 
                         ||:CAL_YEAR, 'MM YYYY') - 1 + LEVEL ) 
               DateRange, 
               To_char(To_date(01 
                               ||' ' 
                               ||:CAL_YEAR, 'MM YYYY') - 1 + LEVEL, 'DAY') 
               DAYNAME 
        FROM   dual 
        WHERE  ( To_date(01 
                         ||' ' 
                         ||:CAL_YEAR, 'MM YYYY') - 1 + LEVEL ) <= Last_day( 
                      To_date(01 
                              ||' ' 
                              ||:CAL_YEAR, 'MM YYYY')) 
        CONNECT BY LEVEL <= 31 
        UNION 
        SELECT ( To_date(02 
                         ||' ' 
                         ||:CAL_YEAR, 'MM YYYY') - 1 + LEVEL ) 
               DateRange, 
               To_char(To_date(02 
                               ||' ' 
                               ||:CAL_YEAR, 'MM YYYY') - 1 + LEVEL, 'DAY') 
               DAYNAME 
        FROM   dual 
        WHERE  ( To_date(02 
                         ||' ' 
                         ||:CAL_YEAR, 'MM YYYY') - 1 + LEVEL ) <= Last_day( 
                      To_date(02 
                              ||' ' 
                              ||:CAL_YEAR, 'MM YYYY')) 
        CONNECT BY LEVEL <= 31 
        UNION 
        SELECT ( To_date(03 
                         ||' ' 
                         ||:CAL_YEAR, 'MM YYYY') - 1 + LEVEL ) 
               DateRange, 
               To_char(To_date(03 
                               ||' ' 
                               ||:CAL_YEAR, 'MM YYYY') - 1 + LEVEL, 'DAY') 
               DAYNAME 
        FROM   dual 
        WHERE  ( To_date(03 
                         ||' ' 
                         ||:CAL_YEAR, 'MM YYYY') - 1 + LEVEL ) <= Last_day( 
                      To_date(03 
                              ||' ' 
                              ||:CAL_YEAR, 'MM YYYY')) 
        CONNECT BY LEVEL <= 31 
        UNION 
        SELECT ( To_date(04 
                         ||' ' 
                         ||:CAL_YEAR, 'MM YYYY') - 1 + LEVEL ) 
               DateRange, 
               To_char(To_date(04 
                               ||' ' 
                               ||:CAL_YEAR, 'MM YYYY') - 1 + LEVEL, 'DAY') 
               DAYNAME 
        FROM   dual 
        WHERE  ( To_date(04 
                         ||' ' 
                         ||:CAL_YEAR, 'MM YYYY') - 1 + LEVEL ) <= Last_day( 
                      To_date(04 
                              ||' ' 
                              ||:CAL_YEAR, 'MM YYYY')) 
        CONNECT BY LEVEL <= 31 
        UNION 
        SELECT ( To_date(05 
                         ||' ' 
                         ||:CAL_YEAR, 'MM YYYY') - 1 + LEVEL ) 
               DateRange, 
               To_char(To_date(05 
                               ||' ' 
                               ||:CAL_YEAR, 'MM YYYY') - 1 + LEVEL, 'DAY') 
               DAYNAME 
        FROM   dual 
        WHERE  ( To_date(05 
                         ||' ' 
                         ||:CAL_YEAR, 'MM YYYY') - 1 + LEVEL ) <= Last_day( 
                      To_date(05 
                              ||' ' 
                              ||:CAL_YEAR, 'MM YYYY')) 
        CONNECT BY LEVEL <= 31 
        UNION 
        SELECT ( To_date(06 
                         ||' ' 
                         ||:CAL_YEAR, 'MM YYYY') - 1 + LEVEL ) 
               DateRange, 
               To_char(To_date(06 
                               ||' ' 
                               ||:CAL_YEAR, 'MM YYYY') - 1 + LEVEL, 'DAY') 
               DAYNAME 
        FROM   dual 
        WHERE  ( To_date(06 
                         ||' ' 
                         ||:CAL_YEAR, 'MM YYYY') - 1 + LEVEL ) <= Last_day( 
                      To_date(06 
                              ||' ' 
                              ||:CAL_YEAR, 'MM YYYY')) 
        CONNECT BY LEVEL <= 31 
        UNION 
        SELECT ( To_date(07 
                         ||' ' 
                         ||:CAL_YEAR, 'MM YYYY') - 1 + LEVEL ) 
               DateRange, 
               To_char(To_date(07 
                               ||' ' 
                               ||:CAL_YEAR, 'MM YYYY') - 1 + LEVEL, 'DAY') 
               DAYNAME 
        FROM   dual 
        WHERE  ( To_date(07 
                         ||' ' 
                         ||:CAL_YEAR, 'MM YYYY') - 1 + LEVEL ) <= Last_day( 
                      To_date(07 
                              ||' ' 
                              ||:CAL_YEAR, 'MM YYYY')) 
        CONNECT BY LEVEL <= 31 
        UNION 
        SELECT ( To_date(08 
                         ||' ' 
                         ||:CAL_YEAR, 'MM YYYY') - 1 + LEVEL ) 
               DateRange, 
               To_char(To_date(08 
                               ||' ' 
                               ||:CAL_YEAR, 'MM YYYY') - 1 + LEVEL, 'DAY') 
               DAYNAME 
        FROM   dual 
        WHERE  ( To_date(08 
                         ||' ' 
                         ||:CAL_YEAR, 'MM YYYY') - 1 + LEVEL ) <= Last_day( 
                      To_date(08 
                              ||' ' 
                              ||:CAL_YEAR, 'MM YYYY')) 
        CONNECT BY LEVEL <= 31 
        UNION 
        SELECT ( To_date(09 
                         ||' ' 
                         ||:CAL_YEAR, 'MM YYYY') - 1 + LEVEL ) 
               DateRange, 
               To_char(To_date(09 
                               ||' ' 
                               ||:CAL_YEAR, 'MM YYYY') - 1 + LEVEL, 'DAY') 
               DAYNAME 
        FROM   dual 
        WHERE  ( To_date(09 
                         ||' ' 
                         ||:CAL_YEAR, 'MM YYYY') - 1 + LEVEL ) <= Last_day( 
                      To_date(09 
                              ||' ' 
                              ||:CAL_YEAR, 'MM YYYY')) 
        CONNECT BY LEVEL <= 31 
        UNION 
        SELECT ( To_date(10 
                         ||' ' 
                         ||:CAL_YEAR, 'MM YYYY') - 1 + LEVEL ) 
               DateRange, 
               To_char(To_date(10 
                               ||' ' 
                               ||:CAL_YEAR, 'MM YYYY') - 1 + LEVEL, 'DAY') 
               DAYNAME 
        FROM   dual 
        WHERE  ( To_date(10 
                         ||' ' 
                         ||:CAL_YEAR, 'MM YYYY') - 1 + LEVEL ) <= Last_day( 
                      To_date(10 
                              ||' ' 
                              ||:CAL_YEAR, 'MM YYYY')) 
        CONNECT BY LEVEL <= 31 
        UNION 
        SELECT ( To_date(11 
                         ||' ' 
                         ||:CAL_YEAR, 'MM YYYY') - 1 + LEVEL ) 
               DateRange, 
               To_char(To_date(11 
                               ||' ' 
                               ||:CAL_YEAR, 'MM YYYY') - 1 + LEVEL, 'DAY') 
               DAYNAME 
        FROM   dual 
        WHERE  ( To_date(11 
                         ||' ' 
                         ||:CAL_YEAR, 'MM YYYY') - 1 + LEVEL ) <= Last_day( 
                      To_date(11 
                              ||' ' 
                              ||:CAL_YEAR, 'MM YYYY')) 
        CONNECT BY LEVEL <= 31 
        UNION 
        SELECT ( To_date(12 
                         ||' ' 
                         ||:CAL_YEAR, 'MM YYYY') - 1 + LEVEL ) 
               DateRange, 
               To_char(To_date(12 
                               ||' ' 
                               ||:CAL_YEAR, 'MM YYYY') - 1 + LEVEL, 'DAY') 
               DAYNAME 
        FROM   dual 
        WHERE  ( To_date(12 
                         ||' ' 
                         ||:CAL_YEAR, 'MM YYYY') - 1 + LEVEL ) <= Last_day( 
                      To_date(12 
                              ||' ' 
                              ||:CAL_YEAR, 'MM YYYY')) 
        CONNECT BY LEVEL <= 31);