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.
Base Server
Override View in IFS
@Override VIEW Inventory_Part IS   c_proj_provide.Flags           = 'A----'   c_proj_provide.Datatype        = 'STRING(20)'   ...
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_...
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...
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_);
Rumesh Aponso (RMAX)
Nov 22, 20241 min read
Â
Â
Â
Important DOCMAN APIs
Edm_File_API; Batch_Transfer_Handler_API; Plsqlap_Server_API; Edm_Location_API;
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; ...
Rumesh Aponso (RMAX)
Nov 22, 20241 min read
Â
Â
Â
How to attach an External Document to LU in IFS
DECLARE order_no_ VARCHAR2(100) := 'O123456'; line_no_ VARCHAR2(100) := '4'; rel_no_ VARCHAR2(100) := '1';...
Rumesh Aponso (RMAX)
Nov 22, 20242 min read
Â
Â
Â
Overtake using Search & Replace in IFS
Source IFS: Overtake using Search & Replace
Rumesh Aponso (RMAX)
Nov 22, 20241 min read
Â
Â
Â
Override and Overtake in IFS
Source IFS: Override and Overtake
Rumesh Aponso (RMAX)
Nov 22, 20241 min read
Â
Â
Â
How to use Conditional Compilation in a VIEW [Dynamic Calls]
Dynamic Calls to Optional Components Example1: @Override VIEW Part_Catalog IS Â Â type_desc.Flags = 'A-IUL' Â Â type_desc.Datatype =...
Rumesh Aponso (RMAX)
Nov 15, 20241 min read
Â
Â
Â
Conditional Compilation [Dynamic Calls]
Dynamic Calls to Optional Components $IF (Component_COMPONENT_SYS.INSTALLED) $THEN -- TODO : $ELSE NULL; $END Example: $IF...
Rumesh Aponso (RMAX)
Nov 15, 20241 min read
Â
Â
Â
Remove Debug Information from All Debug Complied Packages
DECLARE error_count_ NUMBER:=0; row_count_ NUMBER:=0; CURSOR get_debug_compiled_objects IS SELECT name, 'alter package ' || name || '...
Rumesh Aponso (RMAX)
Nov 15, 20241 min read
Â
Â
Â
List Packages Compiled with Debug Information
SELECT owner, name, type FROM all_plsql_object_settings WHERE PLSQL_DEBUG='TRUE';
Rumesh Aponso (RMAX)
Nov 15, 20241 min read
Â
Â
Â
Grant IFSWEBCONFIG
BEGIN Installation_SYS.Grant_Ifswebconfig(true); END; /
Rumesh Aponso (RMAX)
Nov 15, 20241 min read
Â
Â
Â
Debug Compile Package
ALTER PACKAGE &PACKAGE_NAME COMPILE DEBUG;
Rumesh Aponso (RMAX)
Nov 15, 20241 min read
Â
Â
Â
Compile Invalid Objects
DECLARE error_count_ NUMBER:=0; row_count_ NUMBER:=0; CURSOR get_invalid_objects IS SELECT * FROM ( SELECT object_name, object_type,...
Rumesh Aponso (RMAX)
Nov 15, 20241 min read
Â
Â
Â
Refresh Reference Cache
-- Provide a view or module as parameter, empty string ('') will result in a full refresh BEGIN Reference_SYS.Refresh_Active_List__('&VIE...
Rumesh Aponso (RMAX)
Nov 15, 20241 min read
Â
Â
Â
Refresh Dictionary Cache
BEGIN Dictionary_SYS.Rebuild_Dictionary_Storage_(0); END; /
Rumesh Aponso (RMAX)
Nov 15, 20241 min read
Â
Â
Â
Grant IFSSYS
BEGIN Installation_SYS.Grant_Privileged_Grantee('IFSSYS', TRUE); END; /
Rumesh Aponso (RMAX)
Nov 15, 20241 min read
Â
Â
Â
How to Grant Permission for Projection in IFS Cloud
BEGIN Fnd_Projection_Grant_API.Grant_All('ReportMappingHandling','IFS_ALL'); COMMIT; END;
Rumesh Aponso (RMAX)
Nov 15, 20241 min read
Â
Â
Â
bottom of page