tag:blogger.com,1999:blog-7433852043797904257.post1367745010351709603..comments2023-03-01T14:23:04.570+05:30Comments on EIM TOOL BOX: Discussion ForumVarun Babuhttp://www.blogger.com/profile/15898496187876291570noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-7433852043797904257.post-22013350497022102992014-06-12T14:51:17.085+05:302014-06-12T14:51:17.085+05:30Modify ONLY BASE TABLES specification of your ifb ...Modify ONLY BASE TABLES specification of your ifb as below and try,<br /><br /> ONLY BASE TABLES = S_PROD_INTVarun Babuhttps://www.blogger.com/profile/15898496187876291570noreply@blogger.comtag:blogger.com,1999:blog-7433852043797904257.post-24665817842024094272014-05-20T18:06:42.179+05:302014-05-20T18:06:42.179+05:30while importing products from csv file im getting ...while importing products from csv file im getting this error while running job ."SBL-EIM-00412: Invalid ONLY/IGNORE BASE TABLES specification." <br /><br />lam pasting my IFB file here <br />[Siebel Interface Manager] <br /><br /> USER NAME = "SADMIN" <br /> PASSWORD = "SADMIN" <br /> PROCESS = IMPORT<br /><br />[IMPORT]<br /><br /> TYPE = IMPORT <br /> BATCH = 200 <br /> SET BASED LOGGING = TRUE <br /> UPDATE STATISTICS = FALSE <br /> TABLE = EIM_PROD_INT<br /> ONLY BASE TABLES = S_PROD_INT, S_PARTY, S_ORG_EXT, S_BU<br /> INSERT ROWS = S_PROD_INT,TRUE<br /><br /><br />CONTROL FILE:<br />OPTIONS (SKIP=1)<br /><br />LOAD DATA<br />INFILE 'C:\EIM\Products.csv'<br />APPEND INTO TABLE SIEBEL.EIM_PROD_INT<br />FIELDS TERMINATED BY "|"<br />OPTIONALLY ENCLOSED BY '"'<br />TRAILING NULLCOLS<br />(<br />ROW_ID SEQUENCE(Max,1),<br />IF_ROW_STAT CONSTANT 'FOR_IMPORT',<br />IF_ROW_BATCH_NUM CONSTANT '300',<br />ACTIVE_FLG CONSTANT 'Y',<br />ADD_TO_QUOTE_FLG CONSTANT 'N',<br />PRODAPPLYECRULEFLG CONSTANT 'N',<br />APPROVAL_FLG CONSTANT 'N',<br />AUTO_UNGROUP_FLG CONSTANT 'N',<br />BILLABLE_FLG CONSTANT 'Y',<br />PROD_BI CONSTANT '0-R9NH',<br />PROD_BU CONSTANT 'Default Organization',<br />CG_COMPETITOR_FLG CONSTANT 'N',<br />CMPND_FLG CONSTANT 'N',<br />COMMISIONED_FLG CONSTANT 'N',<br />COMPENSATABLE_FLG CONSTANT 'Y',<br />CRT_AGREEMENT_FLG CONSTANT 'N',<br />CRT_AST_REC_FLG CONSTANT 'Y',<br />CRT_INST_FLG CONSTANT 'Y',<br />DESIGN_REG_FLG CONSTANT 'N',<br />ENTERPRISE_FLG CONSTANT 'N',<br />FEATURED_FLG CONSTANT 'N',<br />INCLSV_ELIG_RL_FLG CONSTANT 'N',<br />PRD_INCLALLCRSEFLG CONSTANT 'N',<br />LEAF_LEVEL_FLG CONSTANT 'N',<br />MODEL_PROD_FLG CONSTANT 'N',<br />NEED_PH_NUM_FLG CONSTANT 'N',<br />POSTN_BL_PROD_FLG CONSTANT 'Y',<br />SALES_PROD_FLG CONSTANT 'N',<br />SALES_SRVC_FLG CONSTANT 'Y',<br />SERVICE_FLG CONSTANT 'N',<br />SERV_INST_FLG CONSTANT 'N',<br />SHIP_FLG CONSTANT 'N',<br />TARGET_VRSN_FLG CONSTANT 'N',<br />TAX_SUBCOMP_FLG CONSTANT 'N',<br />TRANSFERABLE_FLG CONSTANT 'N',<br />TWOBARCODES_FLG CONSTANT 'N',<br />UNIQUE_ASSET_FLG CONSTANT 'N',<br />VENDR_ACCNT_BU CONSTANT 'Default Organization', <br />VENDR_ACCNT_LOC CONSTANT 'INTERNAL', <br /><br />NAME "TRIM(:NAME)",<br />PART_NUM "TRIM(:PART_NUM)",<br />DETAIL_TYPE_CD "TRIM(:DETAIL_TYPE_CD)",<br />PROD_CATG_CD "TRIM(:PROD_CATG_CD)",<br />DESC_TEXT "TRIM(:DESC_TEXT)",<br />VENDR_ACCNT_NAME "TRIM(:VENDR_ACCNT_NAME)",<br />PRICE_TYPE_CD "TRIM(:PRICE_TYPE_CD)",<br />PROD_PROD_TYPE_CD "TRIM(:PROD_PROD_TYPE_CD)",<br />ORDERABLE_FLG "TRIM(:ORDERABLE_FLG)" <br /><br />)<br /> As mentioned in the post of this blog, i have given all the base table required columns in ctl file.<br />Krishnahttps://www.blogger.com/profile/04370183225178479160noreply@blogger.com