SQL Requirements for Interface Table Upload

For Interface Table based uploads, your main extraction SQL is required to contain four specific columns in the first four positions , . These columns must be: `action_`, `status_`, `message_`, and `row_id_` , . You typically initialize these columns with `null` values, for example: `null action_, null status_, null message_,

The `row_id_` column must explicitly identify the row in the underlying interface table . You derive it using the syntax: `

For API based uploads, the SQL requirements are slightly simpler, requiring only the first three columns . The SQL must contain `action_`, `status_`, and `message_` columns in the first three positions . The format is typically `null action_, null status_, null message_` . The `row_id_` column is not mandatory in this scenario .

You configure the submission of the standard Oracle import concurrent request using the Post Procedure feature . Under the Upload setup tab, you define a post procedure that is executed after the primary upload processing is complete, typically responsible for submitting the subsequent concurrent request that consumes the data from the interface table , .