hai this is the sample script to create error table for Supplier interface in apps r12.
CREATE TABLE XXST_INT_ERROR_LOG
(
BATCH_ID NUMBER NOT NULL,
CONC_REQUEST_ID NUMBER NOT NULL,
DATE_RUN DATE NOT NULL,
TABLE_NAME VARCHAR2(100 BYTE) NOT NULL,
COLUMN_NAME VARCHAR2(100 BYTE) NOT NULL,
KEY_COLUMN VARCHAR2(100 BYTE),
KEY_COLUMN_ID VARCHAR2(100 BYTE),
KEY_COLUMN_VALUE VARCHAR2(100 BYTE),
ERROR_TEXT VARCHAR2(4000 BYTE) NOT NULL,
ROW_ID ROWID,
REC_NUMBER NUMBER(22),
LAST_UPDATE_DATE DATE,
LAST_UPDATED_BY NUMBER,
CREATION_DATE DATE,
CREATED_BY NUMBER,
LAST_UPDATE_LOGIN NUMBER
)
CREATE TABLE XXST_INT_ERROR_LOG
(
BATCH_ID NUMBER NOT NULL,
CONC_REQUEST_ID NUMBER NOT NULL,
DATE_RUN DATE NOT NULL,
TABLE_NAME VARCHAR2(100 BYTE) NOT NULL,
COLUMN_NAME VARCHAR2(100 BYTE) NOT NULL,
KEY_COLUMN VARCHAR2(100 BYTE),
KEY_COLUMN_ID VARCHAR2(100 BYTE),
KEY_COLUMN_VALUE VARCHAR2(100 BYTE),
ERROR_TEXT VARCHAR2(4000 BYTE) NOT NULL,
ROW_ID ROWID,
REC_NUMBER NUMBER(22),
LAST_UPDATE_DATE DATE,
LAST_UPDATED_BY NUMBER,
CREATION_DATE DATE,
CREATED_BY NUMBER,
LAST_UPDATE_LOGIN NUMBER
)
No comments:
Post a Comment