當系統預設的彈性欄位用完後, 如何自行增加

1.用apps對實體表增加欄位
alter table inv.mtl_system_items_b add(GOBOADD1 varchar2(240),GOBOADD2 varchar2(240),GOBOADD3 varchar2(240),GOBOADD4 varchar2(240),GOBOADD5 varchar2(240))

2.注冊欄位
begin
--EXECUTE
 ad_dd.register_column('INV','MTL_SYSTEM_ITEMS_B','GOBOADD1',501,'VARCHAR2',240,'Y','N');
 ad_dd.register_column('INV','MTL_SYSTEM_ITEMS_B','GOBOADD2',502,'VARCHAR2',240,'Y','N');
 ad_dd.register_column('INV','MTL_SYSTEM_ITEMS_B','GOBOADD3',503,'VARCHAR2',240,'Y','N');
 ad_dd.register_column('INV','MTL_SYSTEM_ITEMS_B','GOBOADD4',504,'VARCHAR2',240,'Y','N');
 ad_dd.register_column('INV','MTL_SYSTEM_ITEMS_B','GOBOADD5',506,'VARCHAR2',240,'Y','N');
 commit;
end;

注1.p_col_name已有注冊的不會提示出錯,也不會改變原來的,需執行以下的,先刪除再注冊
begin
--EXECUTE
 ad_dd.delete_column('INV','MTL_SYSTEM_ITEMS_B','GOBOADD1');
 commit;
end;
注2:p_col_seq已有注冊的會提示出錯,換另一個號,即可

注3:參考115devg.pdf Table Registration API
procedure register_column (p_appl_short_name in varchar2,
p_tab_name in varchar2,
p_col_name in varchar2,
p_col_seq in number,
p_col_type in varchar2,
p_col_width in number,
p_nullable in varchar2,
p_translate in varchar2,
p_precision in number default null,
p_scale in number default null);

3.到ERP中applcation developer->application->database->table
找到此表MTL_SYSTEM_ITEMS_B,以及相關的欄位,看注冊是否正常

4.到ERP中applcation developer->flexfield->description->register
找到此表MTL_SYSTEM_ITEMS_B,以及相關的欄位,將enable勾上即可

5.按正常的彈性欄位設定即可