top of page
"All truths are easy to understand once they are discovered; the point is to discover them."
Galileo Galilei
RMAXOneNote covers a wide range of programming languages and technologies (Oracle PL/SQL, C#, Java, etc.), code examples, and solutions related to IFS ERP. The purpose of this blog is to share knowledge among developers about the problems they encounter daily.
IFS Tips & Tricks
Rumesh Aponso (RMAX)
Nov 25, 20242 min read
Array in PLSQL
Example 1: VARRAY TYPE 1 DECLARE TYPE namesarray IS VARRAY(5) OF VARCHAR2(10); names_ namesarray; TYPE grades IS VARRAY(5) OF INTEGER;...
5 views0 comments
Rumesh Aponso (RMAX)
Nov 25, 20241 min read
Sort Numbers in PLSQL
Issue: Solution: Sort Numbers Only ORDER BY REGEXP_REPLACE( <COLUMN_NAME> , '[[:digit:]]', '~') ASC ; Sort Numbers and Text ORDERÂ BY...
1 view0 comments
Rumesh Aponso (RMAX)
Nov 25, 20241 min read
How to Open Debub Console in IFS7.5
Press Ctrl + Alt + Right Mouse Button
6 views0 comments
Rumesh Aponso (RMAX)
Nov 25, 20241 min read
Trigger System Event in IFS
IF (Event_SYS.Event_Enabled('ProdStructure', 'PROD_STRUCTURE_COPIED')) THEN c_msg_ := Message_SYS.Construct('PROD_STRUCTURE_COPIED'); ...
3 views0 comments
Rumesh Aponso (RMAX)
Nov 25, 20241 min read
Mapping of Report Files from APP7.5 to APP8, APP9, APP10, and IFS Cloud
Mapping of report files from APP7.5 to APP8, APP9, APP10, and IFS Cloud.  E.g. Purchase Order report   APP7.5 APP8, APP9, APP10, IFS...
0 views0 comments
Rumesh Aponso (RMAX)
Nov 25, 20241 min read
Paste in IEE Client in IFS [PM_DataRecordPaste]
PM_DataRecordPaste private void tbwOrderLine_Cust_WindowActions(object sender, WindowActionsEventArgs e) { switch (e.ActionType) {...
1 view0 comments
Rumesh Aponso (RMAX)
Nov 25, 20241 min read
Copy in IEE Client in IFS [PM_DataRecordCopy]
PM_DataRecordCopy private void tbwOrderLine_Cust_WindowActions(object sender, WindowActionsEventArgs e) { switch (e.ActionType) {...
1 view0 comments
Rumesh Aponso (RMAX)
Nov 22, 20241 min read
Ways to Open another Form in IEE Client in IFS [SessionNavigate,
Via SessionNavigate Setup data transfer object [Optional Step] Call ‘SessionNavigate’ method and pass form/window name...
5 views0 comments
Rumesh Aponso (RMAX)
Nov 22, 20241 min read
Access Top Parent Form in IEE Client
Instead of :i_hWndParent use :i_HwandTopFrame . It will get the topmost form handle. :i_hWndParent : Immediate Parent Form...
6 views0 comments
Rumesh Aponso (RMAX)
Nov 22, 20241 min read
PalAttrAdd, Add value to Attr in Client in IFS (DataRecordFetchEditedUserEvent)
private void tblTestPackage_DataRecordFetchEditedUserEvent(object sender, cDataSource.DataRecordFetchEditedUserEventArgs e) { #region...
1 view0 comments
Rumesh Aponso (RMAX)
Nov 22, 20241 min read
Override View in IFS
@Override VIEW Inventory_Part IS   c_proj_provide.Flags           = 'A----'   c_proj_provide.Datatype        = 'STRING(20)'   ...
2 views0 comments
Rumesh Aponso (RMAX)
Nov 22, 20241 min read
Temporary Table in PLSQL
DECLARE --table row type TYPE customer_order_tab_type IS TABLE OF customer_order_tab%ROWTYPE INDEX BY BINARY_INTEGER; customer_order_tab_...
7 views0 comments
Rumesh Aponso (RMAX)
Nov 22, 20241 min read
Send Email via Event in IFS
IF (Event_SYS.Event_Enabled(lu_name_, 'PART_FULFILL'))THEN msg_ := Message_Sys.Construct('PART_FULFILL'); Message_Sys.Add_Attribute(m...
5 views0 comments
Rumesh Aponso (RMAX)
Nov 22, 20241 min read
Send Email via Server Side in IFS
Command_SYS.Mail(Fnd_Session_API.Get_Fnd_User(), email_id_, message_body_, subject_ => subject_, attach_ => attachment_);
4 views0 comments
Rumesh Aponso (RMAX)
Nov 22, 20241 min read
Remove the Empty Option in the Dropdown
Make the filed mandatory F1 Properties > Required > TRUE
0 views0 comments
Rumesh Aponso (RMAX)
Nov 22, 20241 min read
Important DOCMAN APIs
Edm_File_API; Batch_Transfer_Handler_API; Plsqlap_Server_API; Edm_Location_API;
4 views0 comments
Rumesh Aponso (RMAX)
Nov 22, 20241 min read
Check Box Value Set Methods in IEE
Way 1 - CheckBox field in frm cCheckBox this.cbCSelectIndicator.EditDataItemValueSet(0, cbCSelectIndicator.i_sUncheckedValue.ToHandle());...
0 views0 comments
Rumesh Aponso (RMAX)
Nov 22, 20241 min read
Set a value to a checkbox in IEE
Example 1: bValue = "FALSE"; if (Sal.SendMsg(cbCExcludeCreditControlDb, Ifs.Fnd.ApplicationForms.Const.PM_DataItemValueSet, true,...
0 views0 comments
Rumesh Aponso (RMAX)
Nov 22, 20241 min read
LOV Dialog Title not shown in IEE
Steps: Check the tab order of controls ALWAYS Label first, then Data Field
0 views0 comments
Rumesh Aponso (RMAX)
Nov 22, 20241 min read
How to Impersonate User in IFS
DECLARE backup_user_ VARCHAR2(20); temp_user_ VARCHAR2(20) := 'RMAX'; BEGIN backup_user_ := Fnd_Session_API.Get_Fnd_User; ...
11 views0 comments
bottom of page