Need to register statement like below (Highlighted in orange)
DECLAREtable_name_ VARCHAR2(30) := 'EXTERNAL_CUST_ORDER_LINE_TAB';columns_ Database_SYS.ColumnTabType;column_ Database_SYS.ColRec;register_id_ VARCHAR2(100) := 'CRIM131-12';module_ VARCHAR2(6) := 'ORDER';BEGINIF NOT (Db_Script_Register_Detail_API.Is_Sub_Section_Registered(module_, register_id_, sub_section_ => 1)) THENDatabase_SYS.Reset_Column_Table(columns_);Database_SYS.Set_Table_Column(columns_, 'C_CUST_SPEC_ID', 'VARCHAR2(20)', 'Y');Database_SYS.Set_Table_Column(columns_, 'C_REVISION_NO', 'NUMBER', 'Y');Database_SYS.Alter_Table(table_name_, columns_);Db_Script_Register_Detail_API.Register_Sub_Section(module_,register_id_,sub_section_ => 1,processed_ok_ => 'TRUE',file_name_ => '220126_C_CRIM131-12_ORDER.cdb');END IF;END;/
This will help to avoid installation issues on customer environment in IFS Cloud.
0 Comments