爱丫爱丫在线观看视频_淮南网红小长城_阿森纳英超积分_怎样创建网站

文章目录

- ORACLE 通用导入开发
- - 1、通用导入设置界面
  - 2、定义录入的数据源
  - 3、编写导入程序内容
  - 4、界面挂载

ORACLE 通用导入开发

1、通用导入设置界面

录入三个数据源名称，自定义的(这个界面我一直没找到在哪，所以我一般用脚本直接执行导入)

数据源	含义
CUX_TEST_TEMP	导入信息界面
CUX_TEST_TEMP_I	错误信息界面
CUX_TEST_TEMP_W	警告信息界面

在这里插入图片描述

也可以使用如下脚本进行导入

--初始化导入设置
INSERT INTO cux.cux_common_import_setup(import_code,win_title,package_name,inv_org_required,archive_required,all_view,invalid_view,warning_view,field_separator,creation_date,created_by,last_update_date,last_updated_by,last_update_login)
VALUES('CUXTESTIMPORT', --通用导入名称(唯一标识)'CUX:测试通用导入功能', --通用导入标题名称'CUX_TEST_IMPORT_PKG', --关联主体程序包的名字'N','Y','CUX_TEST_TEMP', --导入信息界面'CUX_TEST_TEMP_I', --错误信息界面'CUX_TEST_TEMP_W', --警告信息界面',',SYSDATE,0,SYSDATE,0,-1);
COMMIT;

2、定义录入的数据源

路径: CRM 管理员 -> 电子表 -> 元数据管理

在这里插入图片描述

定义可导入内容界面

在这里插入图片描述

定义错误数据界面

在这里插入图片描述

定义警告数据界面

在这里插入图片描述

也可以使用如下脚本进行导入

--界面布局1
BEGIN--导入电子表数据源DECLAREl_rowid                VARCHAR2(80);l_grid_datasource_name VARCHAR2(80);l_db_view_name         VARCHAR2(80);l_application_id       NUMBER;l_default_row_height   NUMBER;l_max_queried_rows     NUMBER;l_where_clause         VARCHAR2(80);l_alt_color_code       VARCHAR2(80);l_alt_color_interval   NUMBER;l_title_text           VARCHAR2(80);l_creation_date        DATE;l_created_by           NUMBER;l_last_update_date     DATE;l_last_updated_by      NUMBER;l_last_update_login    NUMBER;l_fetch_size           NUMBER;--bgein 只改动这部分内容，其他不用动CURSOR cur_gdn ISSELECT 'CUX_TEST_TEMP' grid_datasource_name, --数据源名称'CUX:测试通用导入功能-导入信息' title_text, --通用导入界面标题'IMPORT_STATUS NOT IN (''INVALID'',''WARNNING'')' where_clause --where子句FROM dualUNION ALLSELECT 'CUX_TEST_TEMP_I' grid_datasource_name, --数据源名称'CUX:测试通用导入功能-错误信息' title_text, --通用导入界面标题'IMPORT_STATUS=''INVALID''' where_clause --where子句FROM dualUNION ALLSELECT 'CUX_TEST_TEMP_W' grid_datasource_name, --数据源名称'CUX:测试通用导入功能-警告信息' title_text, --通用导入界面标题'IMPORT_STATUS=''WARNNING''' where_clause --where子句FROM dual;--end 只改动这部分内容,其他不用动BEGINSELECT fna.application_idINTO l_application_idFROM fnd_application fnaWHERE fna.application_short_name = 'CUX';FOR rec IN cur_gdn LOOPl_grid_datasource_name := rec.grid_datasource_name; --数据源名称l_title_text           := rec.title_text; --标题l_where_clause         := rec.where_clause; --where子句l_db_view_name         := 'CUX_COMMON_IMPORTS_TEMP_V'; --关系视图名称--l_application_id       := 20003; --应用产品IDl_default_row_height := 1; --行/排l_creation_date      := SYSDATE;l_created_by         := fnd_global.user_id;l_last_update_date   := SYSDATE;l_last_updated_by    := fnd_global.user_id;l_last_update_login  := fnd_global.login_id;jtf_grid_datasources_pkg.insert_row(x_rowid                => l_rowid,x_grid_datasource_name => l_grid_datasource_name,x_db_view_name         => l_db_view_name,x_application_id       => l_application_id,x_default_row_height   => l_default_row_height,x_max_queried_rows     => l_max_queried_rows,x_where_clause         => l_where_clause,x_alt_color_code       => l_alt_color_code,x_alt_color_interval   => l_alt_color_interval,x_title_text           => l_title_text,x_creation_date        => l_creation_date,x_created_by           => l_created_by,x_last_update_date     => l_last_update_date,x_last_updated_by      => l_last_updated_by,x_last_update_login    => l_last_update_login,x_fetch_size           => l_fetch_size);END LOOP;END;COMMIT;
END;

--界面布局2
--导入电子表数据源内容
BEGINDECLAREl_rowid                    VARCHAR2(80);l_grid_datasource_name     VARCHAR2(80);l_grid_col_alias           VARCHAR2(80);l_db_col_name              VARCHAR2(80);l_data_type_code           VARCHAR2(80);l_query_seq                NUMBER;l_sortable_flag            VARCHAR2(80);l_sort_asc_by_default_flag VARCHAR2(80);l_visible_flag             VARCHAR2(80);l_freeze_visible_flag      VARCHAR2(80);l_display_seq              NUMBER;l_display_type_code        VARCHAR2(80);l_display_hsize            NUMBER;l_header_alignment_code    VARCHAR2(80);l_cell_alignment_code      VARCHAR2(80);l_display_format_type_code VARCHAR2(80);l_display_format_mask      VARCHAR2(80);l_checkbox_checked_value   VARCHAR2(80);l_checkbox_unchecked_value VARCHAR2(80);l_checkbox_other_values    VARCHAR2(80);l_db_currency_code_col     VARCHAR2(80);l_label_text               VARCHAR2(80);l_creation_date            DATE;l_created_by               NUMBER;l_last_update_date         DATE;l_last_updated_by          NUMBER;l_last_update_login        NUMBER;l_query_allowed_flag       VARCHAR2(80);l_validation_object_code   VARCHAR2(80);l_query_display_seq        NUMBER;l_db_sort_column           VARCHAR2(80);l_fire_post_query_flag     VARCHAR2(80);l_image_description_col    VARCHAR2(80);CURSOR cur_cols IS--基础信息SELECT 'CUX_TEST_TEMP' grid_datasource_name,'LINE_NUMBER' grid_col_alias,'LINE_NUMBER' db_col_name,'行号' label_text,10 display_seq,'50' display_hsizeFROM dualUNION ALLSELECT 'CUX_TEST_TEMP' grid_datasource_name,'ATTRIBUTE1' grid_col_alias,'ATTRIBUTE1' db_col_name,'业务实体' label_text,15 display_seq,'150' display_hsizeFROM dualUNION ALLSELECT 'CUX_TEST_TEMP' grid_datasource_name,'ATTRIBUTE2' grid_col_alias,'ATTRIBUTE2' db_col_name,'采购订单号' label_text,20 display_seq,'50' display_hsizeFROM dualUNION ALLSELECT 'CUX_TEST_TEMP' grid_datasource_name,'ATTRIBUTE3' grid_col_alias,'ATTRIBUTE3' db_col_name,'物料编码' label_text,25 display_seq,'150' display_hsizeFROM dualUNION ALLSELECT 'CUX_TEST_TEMP' grid_datasource_name,'ATTRIBUTE4' grid_col_alias,'ATTRIBUTE4' db_col_name,'供应商' label_text,30 display_seq,'300' display_hsizeFROM dual--错误信息UNION ALLSELECT 'CUX_TEST_TEMP_I' grid_datasource_name,'LINE_NUMBER' grid_col_alias,'LINE_NUMBER' db_col_name,'行号' label_text,10 display_seq,'50' display_hsizeFROM dualUNION ALLSELECT 'CUX_TEST_TEMP_I' grid_datasource_name,'IMPORT_MESSAGE' grid_col_alias,'IMPORT_MESSAGE' db_col_name,'错误信息' label_text,20 display_seq,'1000' display_hsizeFROM dual--警告信息UNION ALLSELECT 'CUX_TEST_TEMP_W' grid_datasource_name,'LINE_NUMBER' grid_col_alias,'LINE_NUMBER' db_col_name,'行号' label_text,10 display_seq,'50' display_hsizeFROM dualUNION ALLSELECT 'CUX_TEST_TEMP_W' grid_datasource_name,'IMPORT_MESSAGE' grid_col_alias,'IMPORT_MESSAGE' db_col_name,'警告信息' label_text,20 display_seq,'1000' display_hsizeFROM dual;BEGINFOR rec IN cur_cols LOOPl_grid_datasource_name := rec.grid_datasource_name; --数据源名称l_grid_col_alias           := rec.grid_col_alias; --列别名l_db_col_name              := rec.db_col_name; --查看列/函数l_query_seq                := rec.display_seq; --查询序号l_label_text               := rec.label_text; --标签l_display_seq              := rec.display_seq; --显示序号l_display_hsize            := rec.display_hsize; --显示宽度l_data_type_code           := 'C'; --数据类型l_sortable_flag            := 'T';l_sort_asc_by_default_flag := 'T';l_visible_flag             := 'T';l_freeze_visible_flag      := 'F';l_display_type_code        := 'TXT';l_header_alignment_code    := 'S';l_cell_alignment_code      := 'S';l_display_format_type_code := NULL;l_display_format_mask      := NULL;l_checkbox_checked_value   := NULL;l_checkbox_unchecked_value := NULL;l_checkbox_other_values    := 'T';l_db_currency_code_col     := NULL;l_query_allowed_flag       := 'F';l_validation_object_code   := NULL;l_query_display_seq        := NULL;l_image_description_col    := NULL;l_db_sort_column           := NULL;l_fire_post_query_flag     := 'F';l_creation_date            := SYSDATE;l_created_by               := fnd_global.user_id;l_last_update_date         := SYSDATE;l_last_updated_by          := fnd_global.user_id;l_last_update_login        := fnd_global.login_id;-- Call the procedureapps.jtf_grid_cols_pkg.insert_row(x_rowid                    => l_rowid,x_grid_datasource_name     => l_grid_datasource_name,x_grid_col_alias           => l_grid_col_alias,x_db_col_name              => l_db_col_name,x_data_type_code           => l_data_type_code,x_query_seq                => l_query_seq,x_sortable_flag            => l_sortable_flag,x_sort_asc_by_default_flag => l_sort_asc_by_default_flag,x_visible_flag             => l_visible_flag,x_freeze_visible_flag      => l_freeze_visible_flag,x_display_seq              => l_display_seq,x_display_type_code        => l_display_type_code,x_display_hsize            => l_display_hsize,x_header_alignment_code    => l_header_alignment_code,x_cell_alignment_code      => l_cell_alignment_code,x_display_format_type_code => l_display_format_type_code,x_display_format_mask      => l_display_format_mask,x_checkbox_checked_value   => l_checkbox_checked_value,x_checkbox_unchecked_value => l_checkbox_unchecked_value,x_checkbox_other_values    => l_checkbox_other_values,x_db_currency_code_col     => l_db_currency_code_col,x_label_text               => l_label_text,x_creation_date            => l_creation_date,x_created_by               => l_created_by,x_last_update_date         => l_last_update_date,x_last_updated_by          => l_last_updated_by,x_last_update_login        => l_last_update_login,x_query_allowed_flag       => l_query_allowed_flag,x_validation_object_code   => l_validation_object_code,x_query_display_seq        => l_query_display_seq,x_db_sort_column           => l_db_sort_column,x_fire_post_query_flag     => l_fire_post_query_flag,x_image_description_col    => l_image_description_col);END LOOP;END;COMMIT;
END;