I have ODI 18.104.22.168 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.
Can you change your target mapping to execute on Target ? , also check for Insert only (No Update).
Thats nornally how I use standalone sequences in ODI interfaces, not sure if the concatanation is causing the issue.