I created a custom integrator in r12.2.3 and while loading I encountered an error, Cannot execute SQL statement.
I checked my setup in Interface attribute , the RUN_ID column has a default type SQL QUERY with a default value SELECT XXCONV_EAM_ASSET_NUM_S.NEXTVAL FROM DUAL.
If I have a right setup here, what can be the cause of this error?

