Wednesday, July 18, 2012

Discussion Forum

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.

2 comments:

  1. while importing products from csv file im getting this error while running job ."SBL-EIM-00412: Invalid ONLY/IGNORE BASE TABLES specification."

    lam 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.

    ReplyDelete
    Replies
    1. Modify ONLY BASE TABLES specification of your ifb as below and try,

      ONLY BASE TABLES = S_PROD_INT

      Delete