WebADI how to populate value from sequence to a Line level column
Hi,
we are using R12.1.3 and I am creating a custom integrator to load journals with some DFF attributes, I am creating the integrator as per the note 1475566.1.
my interface is Table based and the table has a Line_ID column which I want to populate with a value from a database sequence, so that I can identify uniquely each line being loaded using WebADI and show errors if there are any for that specific line(s).
I have PL/SQL type Importer which validates the data and update the error_status and error_message columns in the interface table, which I want to show on the excel template for the error rows.