Lets discuss here and learn ourselves. This space is dedicated for discussions where you can comment your thoughts, ideas, experiences, queries on topics like Siebel EIM, SQL etc.
Also you can mail your queries, ideas, experiences, or feedback's to 'eimtoolbox@gmail.com' and i will post them in blog on your behalf.
while importing products from csv file im getting this error while running job ."SBL-EIM-00412: Invalid ONLY/IGNORE BASE TABLES specification."
ReplyDeletelam pasting my IFB file here
[Siebel Interface Manager]
USER NAME = "SADMIN"
PASSWORD = "SADMIN"
PROCESS = IMPORT
[IMPORT]
TYPE = IMPORT
BATCH = 200
SET BASED LOGGING = TRUE
UPDATE STATISTICS = FALSE
TABLE = EIM_PROD_INT
ONLY BASE TABLES = S_PROD_INT, S_PARTY, S_ORG_EXT, S_BU
INSERT ROWS = S_PROD_INT,TRUE
CONTROL FILE:
OPTIONS (SKIP=1)
LOAD DATA
INFILE 'C:\EIM\Products.csv'
APPEND INTO TABLE SIEBEL.EIM_PROD_INT
FIELDS TERMINATED BY "|"
OPTIONALLY ENCLOSED BY '"'
TRAILING NULLCOLS
(
ROW_ID SEQUENCE(Max,1),
IF_ROW_STAT CONSTANT 'FOR_IMPORT',
IF_ROW_BATCH_NUM CONSTANT '300',
ACTIVE_FLG CONSTANT 'Y',
ADD_TO_QUOTE_FLG CONSTANT 'N',
PRODAPPLYECRULEFLG CONSTANT 'N',
APPROVAL_FLG CONSTANT 'N',
AUTO_UNGROUP_FLG CONSTANT 'N',
BILLABLE_FLG CONSTANT 'Y',
PROD_BI CONSTANT '0-R9NH',
PROD_BU CONSTANT 'Default Organization',
CG_COMPETITOR_FLG CONSTANT 'N',
CMPND_FLG CONSTANT 'N',
COMMISIONED_FLG CONSTANT 'N',
COMPENSATABLE_FLG CONSTANT 'Y',
CRT_AGREEMENT_FLG CONSTANT 'N',
CRT_AST_REC_FLG CONSTANT 'Y',
CRT_INST_FLG CONSTANT 'Y',
DESIGN_REG_FLG CONSTANT 'N',
ENTERPRISE_FLG CONSTANT 'N',
FEATURED_FLG CONSTANT 'N',
INCLSV_ELIG_RL_FLG CONSTANT 'N',
PRD_INCLALLCRSEFLG CONSTANT 'N',
LEAF_LEVEL_FLG CONSTANT 'N',
MODEL_PROD_FLG CONSTANT 'N',
NEED_PH_NUM_FLG CONSTANT 'N',
POSTN_BL_PROD_FLG CONSTANT 'Y',
SALES_PROD_FLG CONSTANT 'N',
SALES_SRVC_FLG CONSTANT 'Y',
SERVICE_FLG CONSTANT 'N',
SERV_INST_FLG CONSTANT 'N',
SHIP_FLG CONSTANT 'N',
TARGET_VRSN_FLG CONSTANT 'N',
TAX_SUBCOMP_FLG CONSTANT 'N',
TRANSFERABLE_FLG CONSTANT 'N',
TWOBARCODES_FLG CONSTANT 'N',
UNIQUE_ASSET_FLG CONSTANT 'N',
VENDR_ACCNT_BU CONSTANT 'Default Organization',
VENDR_ACCNT_LOC CONSTANT 'INTERNAL',
NAME "TRIM(:NAME)",
PART_NUM "TRIM(:PART_NUM)",
DETAIL_TYPE_CD "TRIM(:DETAIL_TYPE_CD)",
PROD_CATG_CD "TRIM(:PROD_CATG_CD)",
DESC_TEXT "TRIM(:DESC_TEXT)",
VENDR_ACCNT_NAME "TRIM(:VENDR_ACCNT_NAME)",
PRICE_TYPE_CD "TRIM(:PRICE_TYPE_CD)",
PROD_PROD_TYPE_CD "TRIM(:PROD_PROD_TYPE_CD)",
ORDERABLE_FLG "TRIM(:ORDERABLE_FLG)"
)
As mentioned in the post of this blog, i have given all the base table required columns in ctl file.
Modify ONLY BASE TABLES specification of your ifb as below and try,
DeleteONLY BASE TABLES = S_PROD_INT