Customization Uplift Steps for 25R2 ?

​@HoustonHockyMon ​@dritter  I hope you have the answer to this question. I have not seen in  technical documentation that it has cleraly mentioned how to handle cdb files for  customization on IFS defined tables.

In your example, i see that you have used RTB and # method.

usually when upgrade scripts runs , standard tables are renamed to use RTB.after the cdb runs .so if we have already a cdb file like below, it shouldnt cause any errors even though if we keep it as it is.  Did you get any errors to change it?

--
--  File   : 220218_MFIN001_NO200487-16_ACCRUL.cdb
SET SERVEROUTPUT ON
DECLARE
   table_name_ VARCHAR2(30) := 'COMPANY_FINANCE_TAB';
   columns_    Database_SYS.ColumnTabType;
   column_     Database_SYS.ColRec;
BEGIN
   Database_SYS.Reset_Column_Table(columns_);
   Database_SYS.Set_Table_Column(columns_, 'C_ACTIVATION_METHOD', 'VARCHAR2(20)', 'Y');
   Database_SYS.Create_Or_Replace_Table(table_name_, columns_, '&IFSAPP_DATA', NULL, TRUE);
END;
SET SERVEROUTPUT OFF

Best Regards,
Wasana

Thank you and congratulations to yourself! We have successfully pushed the changes to our use place/CFG environment. In the hopes that it helps someone else in the future, this is what our limited number of custom objects looked like in the cdb files (we did not prepare our code for delivery continuity at this time).

Custom Tables:

-- [IFS COMPLETE BLOCK DECLAREEND]
DECLARE
   table_name_ VARCHAR2(30) := 'XXXXX_TAB';
   columns_    Database_SYS.ColumnTabType;
   column_     Database_SYS.ColRec;
BEGIN
   Database_SYS.Reset_Column_Table(columns_);
   Database_SYS.Set_Table_Column(columns_, 'FIELD_ONE', 'VARCHAR2(75)', 'N');
   Database_SYS.Set_Table_Column(columns_, 'FIELD_TWO', 'VARCHAR2(5)', 'N');
   Database_SYS.Set_Table_Column(columns_, 'ROWVERSION', 'DATE', 'N');
   Database_SYS.Set_Table_Column(columns_, 'ROWKEY', 'VARCHAR2(50)', 'N', 'sys_guid()');
   Database_SYS.Create_Or_Replace_Table(table_name_, columns_, '&IFSAPP_DATA', NULL, TRUE);
   Database_SYS.Prepare_Table_For_EBR(table_name_);
END;
-- [END IFS COMPLETE BLOCK]
/

Indexes for Custom Tables:

-- [IFS COMPLETE BLOCK DECLAREEND]
DECLARE
   index_name_ VARCHAR2(30) := 'XXXXX_PK';
   table_name_ VARCHAR2(30) := 'XXXXX_RTB';
   columns_    Database_SYS.ColumnTabType;
BEGIN
   Database_SYS.Reset_Column_Table#(columns_);
   Database_SYS.Set_Table_Column#(columns_, 'PRIMARY_KEY');
   Database_SYS.Create_Constraint#(table_name_, index_name_, columns_, 'P', '&IFSAPP_INDEX', NULL, TRUE, TRUE);
END;
-- [END IFS COMPLETE BLOCK]
/

-- [IFS COMPLETE BLOCK DECLAREEND]
DECLARE
   index_name_ VARCHAR2(30) := 'XXXXX_RK';
   table_name_ VARCHAR2(30) := 'XXXXX_RTB';
   columns_    Database_SYS.ColumnTabType;
BEGIN
   Database_SYS.Reset_Column_Table#(columns_);
   Database_SYS.Set_Table_Column#(columns_, 'ROWKEY');
   Database_SYS.Create_Constraint#(table_name_, index_name_, columns_, 'U', '&IFSAPP_INDEX', NULL, TRUE, TRUE);
END;
-- [END IFS COMPLETE BLOCK]
/

Customizations made to IFS-defined Tables:

DECLARE
   table_name_ VARCHAR2(30) := 'IFS_TABLE_NAME_RTB';
   columns_    Database_SYS.ColumnTabType;
   column_     Database_SYS.ColRec;
BEGIN
   Database_SYS.Reset_Column_Table#(columns_);
   Database_SYS.Set_Table_Column#(columns_, 'CUSTOM_FIELD', 'NUMBER', 'Y');
   Database_SYS.Create_Or_Extend_Real_Table#(table_name_, columns_, '&IFSAPP_DATA', NULL, TRUE);
END;
/

RDF Files - Not sure if this will help, but we left the definition of the _RPT table, as that threw an error if we removed it when it was used in the Report_SYS.Define_Report_() method, but we commented out the declaration of the do_rs_ variable and removed the if-statement for when do_rs_ is true. If there is a secondary if(do_rs_) statement for updating the RPT table, that code was also removed.

Those are all of the customization types we had, but I hope this helps anyone else. Happy Friday!

Dylan