1 Reply Latest reply: Oct 8, 2013 3:51 AM by PeakIndicators_Alastair RSS

    Sequence not allowed in ODI 11g

    Orv-Oracle

      Hi guys,

       

      I have ODI 11.1.1.7 and various developments use the load of an integration_id item with the item's of sources concatenated with  th conversion to character of the nextval of a sequence.

       

      So when I execute the interface I got the error ORA-02287: sequence number not allowed here. The KM used id IKM SQL Control Append.

       

      Any help will be appreciated.

       

      Thanks in advance.