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 Developer Studio
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 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 || '...
2 views0 comments
Rumesh Aponso (RMAX)
Nov 15, 20241 min read
Profile in PLSQL
DECLARE file_name_ VARCHAR2(1000); result_ NUMBER; trace_name_ VARCHAR2(1000) := 'my_trace'; filename_ VARCHAR2(1000) :=...
7 views0 comments
Rumesh Aponso (RMAX)
Nov 15, 20241 min read
List Tablespaces
SELECT * FROM user_tablespaces;
1 view0 comments
Rumesh Aponso (RMAX)
Nov 15, 20241 min read
List Sessions
SELECT osuser, machine, program, status FROM v$session WHERE username=USER;
1 view0 comments
Rumesh Aponso (RMAX)
Nov 15, 20241 min read
List Invalid Objects
SELECT object_name, object_type FROM all_objects WHERE status='INVALID' AND owner = USER;
1 view0 comments
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';
0 views0 comments
Rumesh Aponso (RMAX)
Nov 15, 20241 min read
Grant IFSWEBCONFIG
BEGIN Installation_SYS.Grant_Ifswebconfig(true); END; /
0 views0 comments
Rumesh Aponso (RMAX)
Nov 15, 20241 min read
Debug Compile Package
ALTER PACKAGE &PACKAGE_NAME COMPILE DEBUG;
0 views0 comments
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,...
0 views0 comments
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...
3 views0 comments
Rumesh Aponso (RMAX)
Nov 15, 20241 min read
Refresh Dictionary Cache
BEGIN Dictionary_SYS.Rebuild_Dictionary_Storage_(0); END; /
3 views0 comments
Rumesh Aponso (RMAX)
Nov 15, 20241 min read
Grant IFSSYS
BEGIN Installation_SYS.Grant_Privileged_Grantee('IFSSYS', TRUE); END; /
1 view0 comments
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;
4 views0 comments
bottom of page