EIM error SBL-EIM-00413 SBL-EIM-00412 (Doc ID 530991.1)

Last updated on AUGUST 24, 2017

Applies to:

Siebel Enterprise Integration Manager - Version 7.5.3 SIA [16157] to 8.2.2 SIA[22320] [Release V7 to V8]
z*OBSOLETE: Microsoft Windows 2000

Symptoms

User has inserted in the Base Table S_INVOICE_ITEM (X_FLG_OMAGGIO, X_FLG_PACCHETTO) and in the EIM table S_INVC_ITEM 2 new field when execute the DTS for import reurn this errror


this is the IFB

[Siebel Interface Manager]
      USER NAME = "<Username>"
      PASSWORD = "<Password>"
      PROCESS = IMPORTA RIGHE FATTURA

[IMPORTA RIGHE FATTURA]
    TYPE = SHELL
    INCLUDE = DELETE EIM_INVC_ITEM
    INCLUDE = IMPORT EIM_INVC_ITEM

[DELETE EIM_INVC_ITEM]
    TYPE = DELETE
    BATCH = 2401
    TABLE = EIM_INVC_ITEM
    DELETE EXACT = TRUE
    ONLY BASE TABLES = S_INVOICE_ITEM

[IMPORT EIM_INVC_ITEM]
      TYPE = IMPORT
      BATCH = 2400
      TABLE = EIM_INVC_ITEM
      ONLY BASE TABLES = S_INVOICE_ITEM, CX_INV_ITEM_REL
      NET CHANGE = TRUE
    INSERT ROWS = S_INVOICE, FALSE
    UPDATE ROWS = S_INVOICE, FALSE
    ONLY BASE COLUMNS = S_INVOICE_ITEM.INVOICE_ID, \
    S_INVOICE_ITEM.LN_NUM, \
    S_INVOICE_ITEM.ITEM_AMT, \
    S_I...

 

===========================================

Reproduced the below error in EIM_0050_52428802.log 8.2.2.2 SIA [23016] ENU

EIMTrace EIMTraceSubEvent 3 0000026051782a1c:0 2013-04-25 20:49:33 4/25/13 20:49 Error SBL-EIM-00412: Base table CX_CATEG_LOCAT not available
EIMTrace EIMTraceSubEvent 3 0000026051782a1c:0 2013-04-25 20:49:33 through EIM_CTLG_CAT

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms