CREATE TABLE fnd_es_ingestion_int (
    INGESTION_INTERFACE_ID    NUMBER       ,
    TASK_ID                   VARCHAR2(256)    NOT NULL,
    INGESTION_STAGE           VARCHAR2(256)    NOT NULL,
    RETRIES                   NUMBER       ,
    PAYLOAD                   BLOB         ,
    BATCH_ID                  VARCHAR2(256),
    TASK_SEQUENCE_DATE        TIMESTAMP(6) ,
    TASK_DETAIL               CLOB         ,
    CREATED_BY                VARCHAR2(256)    NOT NULL,
    CREATION_DATE             TIMESTAMP(6) ,
    LAST_UPDATED_BY           VARCHAR2(256),
    LAST_UPDATE_DATE          TIMESTAMP(6) ,
    LAST_UPDATE_LOGIN         VARCHAR2(128),
    OBJECT_VERSION_NUMBER     NUMBER(9, 0) ,
    INGESTION_INTERFACE_ID    NUMBER       ,
    TASK_ID                   VARCHAR2(256)    NOT NULL,
    INGESTION_STAGE           VARCHAR2(256)    NOT NULL,
    RETRIES                   NUMBER       ,
    PAYLOAD                   BLOB         ,
    CREATED_BY                VARCHAR2(256)    NOT NULL,
    CREATION_DATE             TIMESTAMP(6) ,
    LAST_UPDATED_BY           VARCHAR2(256),
    LAST_UPDATE_DATE          TIMESTAMP(6) ,
    LAST_UPDATE_LOGIN         VARCHAR2(128),
    OBJECT_VERSION_NUMBER     NUMBER(9, 0) ,
    BATCH_ID                  VARCHAR2(256),
    TASK_SEQUENCE_DATE        TIMESTAMP(6) ,
    TASK_DETAIL               CLOB         ,
    CONSTRAINT pk_fnd_es_ingestion_int PRIMARY KEY (INGESTION_INTERFACE_ID, INGESTION_INTERFACE_ID)
);
