【Phenomenon】
　Error occur when IM-Common master "Evacuation" job  is executed in the  environment migrated from intra-mart WebPlatform/AppFramework Ver7.2  to the following update version of intra-mart Accel Platform.
　・intra-mart Accel Platform 2012 Autumn(Alba)
　・intra-mart Accel Platform 2012 Winter(Bourbon)
　・intra-mart Accel Platform 2013 Spring(Climbing)
　・intra-mart Accel Platform 2013 Summer(Damask)

【Cause】
　It occur as evacuation destination table of corporation attached information （bk_imm_corporation_ath） is not created in migrate process.

【Handling method】
   Please execute the following SQL in according to using tenant database.

■ For Oracle

create table bk_imm_corporation_ath
(
    company_cd                     varchar2(100)   not null,
    corporation_cd                 varchar2(100)   not null,
    customer_cd                    varchar2(100)   not null,
    term_cd                        varchar2(50)    not null,
    start_date                     date            not null,
    end_date                       date            not null,
    delete_flag                    varchar2(1)     not null,
    sort_key                       number(15,0)    not null,
    create_user_cd                 varchar2(100)   not null,
    create_date                    timestamp       not null,
    record_user_cd                 varchar2(100)   not null,
    record_date                    timestamp       not null,
    primary key (company_cd, corporation_cd, customer_cd, term_cd)
);


■ For DB2 or PostgreSQL

create table bk_imm_corporation_ath
(
    company_cd                     varchar(100)    not null,
    corporation_cd                 varchar(100)    not null,
    customer_cd                    varchar(100)    not null,
    term_cd                        varchar(50)     not null,
    start_date                     date            not null,
    end_date                       date            not null,
    delete_flag                    varchar(1)      not null,
    sort_key                       decimal(15,0)   not null,
    create_user_cd                 varchar(100)    not null,
    create_date                    timestamp       not null,
    record_user_cd                 varchar(100)    not null,
    record_date                    timestamp       not null,
    primary key (company_cd, corporation_cd, customer_cd, term_cd)
);


■ For SQLServer

create table bk_imm_corporation_ath
(
    company_cd                     nvarchar(100)   not null,
    corporation_cd                 nvarchar(100)   not null,
    customer_cd                    nvarchar(100)   not null,
    term_cd                        nvarchar(50)    not null,
    start_date                     datetime2       not null,
    end_date                       datetime2       not null,
    delete_flag                    nvarchar(1)     not null,
    sort_key                       decimal(15,0)   not null,
    create_user_cd                 nvarchar(100)   not null,
    create_date                    datetime2       not null,
    record_user_cd                 nvarchar(100)   not null,
    record_date                    datetime2       not null,
    primary key (company_cd, corporation_cd, customer_cd, term_cd)
);

※ This phenomenon is dealed with in the following requirements of  "2013 Autumn"
　　https://issue.intra-mart.jp/issues/3731

-- Target ------------------------------------------------------------------------
iAP/Accel Platform/2012 Autumn(Alba)
iAP/Accel Platform/2012 Winter(Bourbon)
iAP/Accel Platform/2013 Spring(Climbing)
iAP/Accel Platform/2013 Summer(Damask)
--------------------------------------------------------------------------------



FAQID:26