"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

Get Print Count in IFS

To get the print count for each report in IFS.

IFS Tips & Tricks

Rumesh Aponso (RMAX)

Sep 41 min read

Connection between Print Job and Archive in IFS

IFS Tips & Tricks

Rumesh Aponso (RMAX)

Sep 41 min read

How to Create an IFS Java Transformer

IFS Tips & Tricks

Rumesh Aponso (RMAX)

Jul 311 min read

BLOB to CLOB in PLSQL

How to get file content in a BLOB file into a CLOB in PL/SQL. The below function can be used if the BLOB file contains text format data...

PL/SQL Solutions

Rumesh Aponso (RMAX)

Feb 252 min read

Fnd Dynamic Tab Page in IEE Client

[FndWindowRegistration("YVVDA_COMPANY_ADDR", "YvvdaCompanyAddr", FndWindowRegistrationFlags.HomePage)] [FndDynamicTabPage("frmCompanyAddr...

IEE Client

Rumesh Aponso (RMAX)

Dec 10, 20241 min read

LISTAGG in PLSQL

Example 1: SELECT DISTINCT LISTAGG(t.commission_receiver, ';') WITHIN GROUP (ORDER BY t.commission_receiver) FROM...

PL/SQL Solutions

Rumesh Aponso (RMAX)

Dec 10, 20241 min read

Get Foundation Error from ORA Error

FUNCTION Strip_Ora_Error ( sqlerrm_ IN VARCHAR2, sqlcode_ IN NUMBER DEFAULT NULL, strip_ora_only_ IN BOOLEAN DEFAULT...

IFS Tips & Tricks

Rumesh Aponso (RMAX)

Dec 10, 20241 min read

Global Values in IFS Clients [UserGlobalValueGet]

APP75 SalString sTempCompany = ApplicationForms.Const.strNULL; UserGlobalValueGet("COMPANY", ref sTempCompany); APP9...

IFS Tips & Tricks

Rumesh Aponso (RMAX)

Dec 10, 20241 min read

How to get a Child Form from a Parent Form in IEE IFS10

Example 1: frmCmpcfgCUTemplateContainer_Cust frmCmpcfgCUTemplateContainerCust = ((frmCmpcfgCUTemplateContainer_Cust)SalWindow.FromHandle(...

IFS Tips & Tricks

Rumesh Aponso (RMAX)

Dec 10, 20241 min read

How to use DataSourcePopulate in a Child Form in IFS IEE

In child form Override vrtDataSourcePopulateIt #region Methods public new SalBoolean DataSourcePopulateIt(SalNumber nParam) { #region...

IFS Tips & Tricks

Rumesh Aponso (RMAX)

Dec 10, 20241 min read

Access Private Controls/Variables from Child From to Parent From

We could encapsulate the control variables / define and use the Get Set methods. #region Methods public SalNumber GetExecutionTmplSq() {...

IFS Tips & Tricks

Rumesh Aponso (RMAX)

Dec 10, 20241 min read

Find Database Objects in Oracle

SELECT DISTINCT object_type FROM all_objects; SELECT t.* FROM all_objects t WHERE t.object_type IN ('VIEW', 'TABLE', 'INDEX',...

PL/SQL Solutions

Rumesh Aponso (RMAX)

Dec 10, 20241 min read

DBPLSQL Bind Variable in IFS10

Example 1: private void TestFunction() { #region Local Variables SalString sFullName = ":i_hWndFrame." + Ifs.Fnd.ApplicationForms.Int.Q...

IEE Client

Rumesh Aponso (RMAX)

Nov 27, 20241 min read

Object Property in IFS

BEGIN Object_Property_API.Add_Value('LU_NAME', 'OBJECT_KEY', 'PROPERTY_NAME', 'VALUE1;VALUE2;'); END; / IFS APP10 IFS APP7.5

IFS Tips & Tricks

Rumesh Aponso (RMAX)

Nov 27, 20241 min read

How to get Parent Form in Master Detail Form in IFS10

How to get parent form in Master Detail Form WAY 1 ((frmYvvdaCustomerPriceList)SalWindow.FromHandle(this.i_hWndParent,...

IEE Client

Rumesh Aponso (RMAX)

Nov 27, 20241 min read

How to get the Child Form in a Master Detail Form Pic Tab in IFS10

tbwCustomerOrderLine tte = ((tbwCustomerOrderLine)SalWindow.FromHandle(TabAttachedWindowHandleGet(picTab.FindName(Const.TAB_CustOrdLines)...

IEE Client

Rumesh Aponso (RMAX)

Nov 27, 20241 min read

Enable a New Language in IFS10

Enable language from the "Used Language" Add Translations Refresh Language Cache Run the below select statement to check that everything...

IFS Tips & Tricks

Rumesh Aponso (RMAX)

Nov 27, 20241 min read

Unpack Values from LOV in IFS

// Unpacks additional values from LOV public virtual SalBoolean UnpackAttribute(SalString sLovValues, SalString sAttributeName, ref...

IEE Client

Rumesh Aponso (RMAX)

Nov 27, 20241 min read

PM Data Item LOV Done in IFS10 [PM_DataItemLovDone]

#region Methods public SalString GetFieldValueFromLovStr(SalString lsLOV, SalString sSearchField) { #region Local Variables...

IEE Client

Rumesh Aponso (RMAX)

Nov 27, 20241 min read

PM Data Item Lov User Where in IFS10 [PM_DataItemLovUserWhere]

Example 1: private void tableWindow_colsBucketId_WindowActions(object sender, WindowActionsEventArgs e) { #region Actions switch...

IEE Client

Rumesh Aponso (RMAX)

Nov 27, 20241 min read