Protected by Copyscape Web Copyright Protection Software

Search This Blog

Thursday, June 20, 2013

Sample Error Table script

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
)