TRUNCATE TABLE act_business_info;
TRUNCATE TABLE act_evt_log;
-- TRUNCATE TABLE act_ge_bytearray;
-- TRUNCATE TABLE act_ge_property;
TRUNCATE TABLE act_hi_actinst;
TRUNCATE TABLE act_hi_attachment;
TRUNCATE TABLE act_hi_comment;
TRUNCATE TABLE act_hi_detail;
TRUNCATE TABLE act_hi_identitylink;
TRUNCATE TABLE act_hi_procinst;
TRUNCATE TABLE act_hi_taskinst;
TRUNCATE TABLE act_hi_varinst;
-- TRUNCATE TABLE act_id_group;
-- TRUNCATE TABLE act_id_info;
-- TRUNCATE TABLE act_id_membership;
-- TRUNCATE TABLE act_id_user;
TRUNCATE TABLE act_make_copy;
-- TRUNCATE TABLE act_procdef_info;
-- TRUNCATE TABLE act_re_deployment;
-- TRUNCATE TABLE act_re_model;
-- TRUNCATE TABLE act_re_procdef;
TRUNCATE TABLE act_ru_event_subscr;
TRUNCATE TABLE act_ru_execution;
TRUNCATE TABLE act_ru_identitylink;
TRUNCATE TABLE act_ru_job;
TRUNCATE TABLE act_ru_task;
TRUNCATE TABLE act_ru_variable;
TRUNCATE TABLE bam_file_group;
TRUNCATE TABLE bam_file_grp_detail;
TRUNCATE TABLE bam_file_store;
TRUNCATE TABLE bam_file_store_his;
TRUNCATE TABLE bam_file_type;
TRUNCATE TABLE bank_no_info;
TRUNCATE TABLE batch_job_execution;
TRUNCATE TABLE batch_job_execution_context;
TRUNCATE TABLE batch_job_execution_params;
TRUNCATE TABLE batch_job_execution_seq;
TRUNCATE TABLE batch_job_instance;
TRUNCATE TABLE batch_job_seq;
TRUNCATE TABLE batch_step_execution;
TRUNCATE TABLE batch_step_execution_context;
TRUNCATE TABLE batch_step_execution_seq;
TRUNCATE TABLE biz_adv_fee;
TRUNCATE TABLE biz_adv_fee_app;
TRUNCATE TABLE biz_agr_tmpl;
TRUNCATE TABLE biz_bm_rate;
TRUNCATE TABLE biz_bm_rate_chg;
TRUNCATE TABLE biz_cfg_audit;
TRUNCATE TABLE biz_channel;
TRUNCATE TABLE biz_channel_approve;
-- TRUNCATE TABLE biz_cont_signer_config;
-- TRUNCATE TABLE biz_cont_tmpl;
-- TRUNCATE TABLE biz_cont_tmpl_app;
TRUNCATE TABLE biz_coop_account;
TRUNCATE TABLE biz_coop_account_info;
TRUNCATE TABLE biz_coop_account_info_copy1;
TRUNCATE TABLE biz_coop_asset_config;
TRUNCATE TABLE biz_coop_check;
TRUNCATE TABLE biz_coop_config;
TRUNCATE TABLE biz_coop_config_ref;
TRUNCATE TABLE biz_coop_config_staging;
TRUNCATE TABLE biz_coop_credit_config;
TRUNCATE TABLE biz_coop_fee_adj;
TRUNCATE TABLE biz_coop_fee_clr;
TRUNCATE TABLE biz_coop_fee_file;
TRUNCATE TABLE biz_coop_fund_config;
TRUNCATE TABLE biz_coop_prd_config;
TRUNCATE TABLE biz_coop_tran_info;
TRUNCATE TABLE biz_cus_acct;
TRUNCATE TABLE biz_dvt_app;
TRUNCATE TABLE biz_dvt_detail;
TRUNCATE TABLE biz_dvt_err_chk;
TRUNCATE TABLE biz_ext_agr;
TRUNCATE TABLE biz_ext_app;
TRUNCATE TABLE biz_flow_audit;
TRUNCATE TABLE biz_info_backup;
TRUNCATE TABLE biz_loan_voucher;
TRUNCATE TABLE biz_prd_nplr;
-- TRUNCATE TABLE biz_seq_no_tmpl;
TRUNCATE TABLE biz_sgl_sts_reg;
TRUNCATE TABLE biz_sub_tran_record;
-- TRUNCATE TABLE biz_tran_config;
TRUNCATE TABLE biz_tran_record;
TRUNCATE TABLE biz_warn_common;
TRUNCATE TABLE biz_warn_common_multil;
TRUNCATE TABLE biz_warn_coop_acct;
TRUNCATE TABLE biz_warn_coop_file;
TRUNCATE TABLE biz_warn_coop_file_dtl;
TRUNCATE TABLE biz_warn_coop_repay;
TRUNCATE TABLE biz_warn_coop_sign;
TRUNCATE TABLE biz_warn_duebill_check;
TRUNCATE TABLE biz_warn_lmt;
TRUNCATE TABLE biz_warn_notice_config;
TRUNCATE TABLE biz_warn_payout_cancel;
TRUNCATE TABLE biz_warn_payout_check;
TRUNCATE TABLE biz_warn_prd_nplr;
TRUNCATE TABLE biz_warn_repay_check;
TRUNCATE TABLE biz_warn_repay_plan_dtl;
TRUNCATE TABLE bth_file_exception;
TRUNCATE TABLE bth_job_detail;
TRUNCATE TABLE bth_job_status;
TRUNCATE TABLE ctr_lmt_cont;
TRUNCATE TABLE ctr_loan_cont;
TRUNCATE TABLE ctr_loan_cont_exp;
TRUNCATE TABLE ctr_loan_cont_sign;
TRUNCATE TABLE ctr_loan_cont_sign_exp;
TRUNCATE TABLE cus_addr;
TRUNCATE TABLE cus_approve_list;
TRUNCATE TABLE cus_base_info;
TRUNCATE TABLE cus_business_entity;
TRUNCATE TABLE cus_ent;
TRUNCATE TABLE cus_ent_addr;
TRUNCATE TABLE cus_ent_benefit;
TRUNCATE TABLE cus_ent_fina_bond;
TRUNCATE TABLE cus_ent_fina_stock;
TRUNCATE TABLE cus_ent_house;
TRUNCATE TABLE cus_ent_mgr;
TRUNCATE TABLE cus_ent_relate;
TRUNCATE TABLE cus_ent_shr;
TRUNCATE TABLE cus_ent_staging;
TRUNCATE TABLE cus_ent_veh;
TRUNCATE TABLE cus_ext_info;
TRUNCATE TABLE cus_fam_liabilities;
TRUNCATE TABLE cus_house_info;
TRUNCATE TABLE cus_ind_social;
TRUNCATE TABLE cus_ind_work;
TRUNCATE TABLE cus_indiv;
TRUNCATE TABLE cus_info_staging;
TRUNCATE TABLE cus_list;
TRUNCATE TABLE cus_veh_info;
-- TRUNCATE TABLE efs_para_cfpar9;
TRUNCATE TABLE fac_accounting_duebill;
TRUNCATE TABLE fac_loan_duebill;
TRUNCATE TABLE lmt_crdt_agr;
TRUNCATE TABLE lmt_crdt_app;
TRUNCATE TABLE lmt_crdt_apply_report;
TRUNCATE TABLE lmt_crdt_deel_app;
TRUNCATE TABLE lmt_crdt_deel_detail;
TRUNCATE TABLE lmt_crdt_lmt;
TRUNCATE TABLE lmt_crdt_lmt_his;
TRUNCATE TABLE lmt_crdt_risk;
TRUNCATE TABLE lmt_cus_addr;
TRUNCATE TABLE lmt_cus_business_entity;
TRUNCATE TABLE lmt_cus_crdt_deel_app;
TRUNCATE TABLE lmt_cus_crdt_deel_detail;
TRUNCATE TABLE lmt_cus_crdt_lmt;
TRUNCATE TABLE lmt_cus_crdt_lmt_his;
TRUNCATE TABLE lmt_cus_ent;
TRUNCATE TABLE lmt_cus_ent_mgr;
TRUNCATE TABLE lmt_cus_ent_shr;
TRUNCATE TABLE lmt_cus_house_info;
TRUNCATE TABLE lmt_cus_ind_common;
TRUNCATE TABLE lmt_cus_ind_ent;
TRUNCATE TABLE lmt_cus_ind_social;
TRUNCATE TABLE lmt_cus_ind_work;
TRUNCATE TABLE lmt_cus_indiv;
TRUNCATE TABLE lmt_cus_veh_info;
TRUNCATE TABLE lmt_stop_app;
TRUNCATE TABLE pay_credit_app;
TRUNCATE TABLE pay_payout_app;
TRUNCATE TABLE pay_payout_exp;
TRUNCATE TABLE pls_banlance_account;
TRUNCATE TABLE pls_coll_task;
TRUNCATE TABLE pls_coop_claim_repay;
TRUNCATE TABLE pls_cus_acct_chg;
TRUNCATE TABLE pls_cus_rpy_acct_chg;
TRUNCATE TABLE pls_cus_warn_app;
TRUNCATE TABLE pls_cus_warn_auto;
TRUNCATE TABLE pls_cus_warn_man;
TRUNCATE TABLE pls_due_date_chg;
TRUNCATE TABLE pls_dyn_cus_warn_bat;
TRUNCATE TABLE pls_dyn_cus_warn_bat_dtl;
TRUNCATE TABLE pls_ln_use_chk;
TRUNCATE TABLE pls_ln_use_risk_chk;
TRUNCATE TABLE pls_loan_canc_asset_mgr;
TRUNCATE TABLE pls_loan_canc_duebill;
TRUNCATE TABLE pls_loan_canc_plan;
TRUNCATE TABLE pls_loan_canc_recov;
TRUNCATE TABLE pls_loan_cancel;
TRUNCATE TABLE pls_loan_chk;
TRUNCATE TABLE pls_loan_grace_chg;
TRUNCATE TABLE pls_loan_int_adj;
TRUNCATE TABLE pls_loan_rate_chg;
TRUNCATE TABLE pls_loan_relief;
TRUNCATE TABLE pls_loan_repay_mode_chg;
TRUNCATE TABLE pls_loan_term_chg;
TRUNCATE TABLE pls_man_repay;
TRUNCATE TABLE pls_repay;
TRUNCATE TABLE pls_repay_app;
TRUNCATE TABLE pls_repay_approve;
TRUNCATE TABLE pls_repay_exp;
TRUNCATE TABLE pls_repay_result;
TRUNCATE TABLE pls_repayment_file;
TRUNCATE TABLE pls_risk_class_adjust;
TRUNCATE TABLE pls_risk_class_config;
TRUNCATE TABLE pls_risk_class_result;
TRUNCATE TABLE prd_acct_config;
TRUNCATE TABLE prd_agr_tmpl_ref;
TRUNCATE TABLE prd_bank_ref;
TRUNCATE TABLE prd_base_info;
TRUNCATE TABLE prd_chan_ref;
TRUNCATE TABLE prd_code_map;
TRUNCATE TABLE prd_com_param;
TRUNCATE TABLE prd_config_parameters;
TRUNCATE TABLE prd_core_prd_map;
TRUNCATE TABLE prd_crdt_ctrl;
TRUNCATE TABLE prd_crdt_intv;
TRUNCATE TABLE prd_crdt_lmt;
TRUNCATE TABLE prd_ctrl_grp;
TRUNCATE TABLE prd_ctrl_grp_ref;
TRUNCATE TABLE prd_declaration_parameters;
TRUNCATE TABLE prd_draw_intv;
TRUNCATE TABLE prd_draw_lmt;
TRUNCATE TABLE prd_draw_plan_day;
TRUNCATE TABLE prd_draw_term;
TRUNCATE TABLE prd_draw_term_cmm;
TRUNCATE TABLE prd_draw_term_rng;
TRUNCATE TABLE prd_file_grp_ref;
TRUNCATE TABLE prd_fixed_rate;
TRUNCATE TABLE prd_float_rate;
TRUNCATE TABLE prd_fund_plan_ref;
TRUNCATE TABLE prd_lmt_dist;
TRUNCATE TABLE prd_main_info;
TRUNCATE TABLE prd_org_ref;
TRUNCATE TABLE prd_over_ctrl;
TRUNCATE TABLE prd_repay;
TRUNCATE TABLE prd_repay_mode_map;
TRUNCATE TABLE prd_risk_class_model;
TRUNCATE TABLE prd_risk_config;
TRUNCATE TABLE prd_template;
TRUNCATE TABLE prd_tmpl_ref;
TRUNCATE TABLE prd_tran_config;
-- TRUNCATE TABLE prd_tree;
TRUNCATE TABLE prd_tree_param;
TRUNCATE TABLE rec_aml_info_add;
TRUNCATE TABLE rec_aml_info_all;
TRUNCATE TABLE rec_bas_rate;
TRUNCATE TABLE rec_cus_core_info;
TRUNCATE TABLE rec_fac_loan_duebill;
TRUNCATE TABLE rec_ivoc_crdt_info;
TRUNCATE TABLE rec_ln_acct_automatic_compensation;
TRUNCATE TABLE rec_ln_acct_bal_detail_eod;
TRUNCATE TABLE rec_ln_acct_detail;
TRUNCATE TABLE rec_ln_acct_mast;
TRUNCATE TABLE rec_ln_acct_repay_arrears;
TRUNCATE TABLE rec_ln_acct_repay_plan_add;
TRUNCATE TABLE rec_ln_acct_repay_plan_all;
TRUNCATE TABLE rec_ln_acct_repay_plan_crdt;
TRUNCATE TABLE rec_ln_acct_repay_plan_tmp;
TRUNCATE TABLE rec_ln_acct_repayment_mmdd_add;
TRUNCATE TABLE rec_ln_acct_repayment_mmdd_all;
TRUNCATE TABLE rec_ln_acct_repayment_mmdd_tmp;
TRUNCATE TABLE rec_ln_rec_reg_book;
TRUNCATE TABLE rec_ln_trace_log_mmdd;
TRUNCATE TABLE rec_pay_payout;
TRUNCATE TABLE repay_app_list;
TRUNCATE TABLE repay_approve_list;
TRUNCATE TABLE repay_list;
TRUNCATE TABLE rpt_migration_monthly;
TRUNCATE TABLE rpt_prd_annual;
TRUNCATE TABLE rpt_prd_chan_sum;
TRUNCATE TABLE rpt_prd_daily;
TRUNCATE TABLE rpt_prd_monthly;
TRUNCATE TABLE rpt_prd_org_over_sum;
TRUNCATE TABLE rpt_prd_org_sum;
TRUNCATE TABLE rpt_prd_quarterly;
TRUNCATE TABLE rpt_prd_sum;
TRUNCATE TABLE rule_champion_challenger;
TRUNCATE TABLE rule_champion_schedule_rel;
TRUNCATE TABLE rule_clazz;
TRUNCATE TABLE rule_decision_table;
TRUNCATE TABLE rule_execute_detail;
TRUNCATE TABLE rule_model_var_category;
TRUNCATE TABLE rule_pro_model_rel;
TRUNCATE TABLE rule_project;
TRUNCATE TABLE rule_project_record;
TRUNCATE TABLE rule_rule;
TRUNCATE TABLE rule_rule_set;
TRUNCATE TABLE rule_schedule;
TRUNCATE TABLE rule_scheduler_result;
TRUNCATE TABLE rule_score_card_new;
TRUNCATE TABLE rule_score_detail;
TRUNCATE TABLE rule_var_category;
TRUNCATE TABLE rule_variable;
TRUNCATE TABLE sccola;
TRUNCATE TABLE sch_group;
TRUNCATE TABLE sch_group_job_ref;
TRUNCATE TABLE sch_group_status;
TRUNCATE TABLE sch_job_contacts;
TRUNCATE TABLE sch_job_detail;
TRUNCATE TABLE sch_job_monitor;
TRUNCATE TABLE sch_job_status;
TRUNCATE TABLE sch_job_system;
TRUNCATE TABLE sch_lock;
TRUNCATE TABLE sch_task;
TRUNCATE TABLE sch_task_group_ref;
TRUNCATE TABLE sch_task_status;
TRUNCATE TABLE sculda;
TRUNCATE TABLE sms_send_person;
TRUNCATE TABLE sms_send_record;
TRUNCATE TABLE sms_tmpl_config;
-- TRUNCATE TABLE sys_acct_sysdate;
-- TRUNCATE TABLE sys_api_permission;
-- TRUNCATE TABLE sys_app;
-- TRUNCATE TABLE sys_app_api;
-- TRUNCATE TABLE sys_app_button;
-- TRUNCATE TABLE sys_app_cfg_adj_log;
-- TRUNCATE TABLE sys_bank;
-- TRUNCATE TABLE sys_config;
TRUNCATE TABLE sys_db_resource;
TRUNCATE TABLE sys_delete_log;
TRUNCATE TABLE sys_exception_log;
TRUNCATE TABLE sys_holiday;
-- TRUNCATE TABLE sys_home_config;
TRUNCATE TABLE sys_lock;
TRUNCATE TABLE sys_notice_public;
TRUNCATE TABLE sys_operation_log;
-- TRUNCATE TABLE sys_option;
-- TRUNCATE TABLE sys_org;
-- TRUNCATE TABLE sys_org_app;
-- TRUNCATE TABLE sys_org_map;
-- TRUNCATE TABLE sys_org_role;
-- TRUNCATE TABLE sys_role;
-- TRUNCATE TABLE sys_role_app;
-- TRUNCATE TABLE sys_role_app_api;
-- TRUNCATE TABLE sys_role_app_btn;
-- TRUNCATE TABLE sys_role_resource;
-- TRUNCATE TABLE sys_select;
-- TRUNCATE TABLE sys_sub_app;
-- TRUNCATE TABLE sys_tree;
-- TRUNCATE TABLE sys_user;
-- TRUNCATE TABLE sys_user_org;
-- TRUNCATE TABLE sys_user_role;
TRUNCATE TABLE test_test;
TRUNCATE TABLE unl_fund_plan;
TRUNCATE TABLE unl_plan_detail;
TRUNCATE TABLE unl_reg_detail 