Skip to main content
Question

Customization Uplift Steps for 25R2 ?

  • November 30, 2025
  • 27 replies
  • 1181 views

Show first post

27 replies

Forum|alt.badge.img+7
  • Sidekick (Customer)
  • April 13, 2026

@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

 

Hi ​@wahelk,

 

I reviewed my 25R2 code and it looks like I have two versions of customizations on standard IFS tables. First, using the RTB, I have:

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

SET SERVEROUTPUT OFF


Next, using the TAB, I have:
 

SET SERVEROUTPUT ON
DECLARE
table_name_ VARCHAR2(30) := 'xxxxxxx_TAB';
columns_ Database_SYS.ColumnTabType;
column_ Database_SYS.ColRec;
BEGIN
Database_SYS.Reset_Column_Table(columns_);
Database_SYS.Set_Table_Column(columns_, 'FIELD_NAME', 'VARCHAR2(20)', '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]
/
SET SERVEROUTPUT OFF

I have both of these, and the sanities, environments, and deliveries were successful, so you may be able to use either one.

 

In your example, is your .cdb file getting executed? Without the / after the code block, does the code ever leave the buffer?

 

Thank you,

Dylan


wahelk
Hero (Former Employee)
Forum|alt.badge.img+11
  • Hero (Former Employee)
  • April 13, 2026

Hi ​@HoustonHockyMon  ​@dritter 

 

Thank you both for the explanation. I have not applied yet and  planning a list of what to do.I can try without changes and see what is the result.

Best Regards,
Wasana