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.
PL/SQL Solutions
Rumesh Aponso (RMAX)
Nov 22, 20241 min read
Get Week Number in PLSQL
SELECT TO_NUMBER(TO_CHAR(TO_DATE('06/14/2018', 'MM/DD/YYYY'), 'WW')) FROM DUAL; SELECT TO_NUMBER(TO_CHAR(TO_DATE(SYSDATE, 'DD/MM/YYYY'),...
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
Rumesh Aponso (RMAX)
Nov 22, 20242 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';...
7 views0 comments
Rumesh Aponso (RMAX)
Nov 22, 20241 min read
Get Filenames from an Oracle Directory in IFS
DECLARE directory_name_ CONSTANT all_directories.directory_name%TYPE := 'OUT_DIR'; file_ist_ Intface_File_Types :=...
2 views0 comments
Rumesh Aponso (RMAX)
Nov 21, 20241 min read
Download Files From DB and Upload to FTP in IFS
DECLARE error_msg_ VARCHAR2(32000); file_name_ edm_file_tab.file_name%TYPE; local_file_name_ VARCHAR2(4000);...
6 views0 comments
Rumesh Aponso (RMAX)
Nov 21, 20241 min read
DROP Package in PLSQL
DROP PACKAGE BODY <PACKAGE_NAME> ; DROP PACKAGE <PACKAGE_NAME> ; Example: DROP PACKAGE BODY RMAX_API ; DROP PACKAGE RMAX_API ;
0 views0 comments
Rumesh Aponso (RMAX)
Nov 21, 20241 min read
BULK COLLECT with Custom SQL Statement
DECLARE rec_limit_ NUMBER := 100; fetch_limit_ CONSTANT PLS_INTEGER DEFAULT 9; sql_stmt_ CLOB; CURSOR get_co_info IS SELECT...
2 views0 comments
Rumesh Aponso (RMAX)
Nov 21, 20241 min read
BULK COLLECT using CURSOR FOR LOOP
DECLARE rec_limit_ NUMBER := 100; fetch_limit_ CONSTANT PLS_INTEGER DEFAULT 9; CURSOR get_co_info IS SELECT t.order_no,...
5 views0 comments
Rumesh Aponso (RMAX)
Nov 21, 20241 min read
SPLIT in PLSQL
Way 1 -- ^ value delimiter DECLARE temp_attr_ VARCHAR2(32000); CURSOR get_splitted_values IS SELECT REGEXP_SUBSTR(temp_attr_, '[^ ^...
5 views0 comments
Rumesh Aponso (RMAX)
Nov 21, 20241 min read
Get IFS Error Messages From sqlerrm
EXCEPTION WHEN OTHERS THEN error_ := rec_.contract || ';' || rec_.part_status || ';' || rec_.part_no; IF (Error_SYS.Is_Foundation_Error(...
3 views0 comments
Rumesh Aponso (RMAX)
Nov 21, 20241 min read
Get Person Default Language in IFS
DECLARE user_id_ VARCHAR2(50); language_code_ VARCHAR2(10); BEGIN --Get Session Logged-in Language Code user_id_ :=...
2 views0 comments
Rumesh Aponso (RMAX)
Nov 21, 20241 min read
Set Session Language in IFS
DECLARE BEGIN Fnd_Session_API.Set_Language('en'); --TODO: Logic END;
0 views0 comments
Rumesh Aponso (RMAX)
Nov 21, 20241 min read
Get Session Language in IFS
SELECT Sys_Context('FNDSESSION_CTX', 'LANGUAGE') FROM DUAL;
0 views0 comments
Rumesh Aponso (RMAX)
Nov 21, 20241 min read
Get Logged-in/Session User in IFS
SELECT Fnd_Session_API.Get_Fnd_User FROM DUAL;
1 view0 comments
Rumesh Aponso (RMAX)
Nov 21, 20241 min read
Exception Handling in IFS
PROCEDURE Test_Exception_Handling IS BEGIN -- TODO: Pre Logic Dbms_Output.Put_Line('Pre Logic'); BEGIN @ApproveTransactionStatement(2024...
3 views0 comments
Rumesh Aponso (RMAX)
Nov 20, 20241 min read
BULK COLLECT using TYPE Record
DECLARE Â Â sql_stmt_Â Â VARCHAR2(32000); Â Â Â Â CURSOR get_data IS Â Â Â Â Â SELECT t.order_no, Â Â Â Â Â Â Â Â Â Â Â Â t.line_no, Â Â Â Â Â Â Â Â Â Â Â Â t.rel_no,...
10 views0 comments
Rumesh Aponso (RMAX)
Nov 20, 20241 min read
Create Sequence in IFS
DECLARE seq_exists_ NUMBER; sql_stmt_ VARCHAR2(2000); CURSOR check_exists IS SELECT 1 FROM all_objects WHERE object_name =...
5 views0 comments
Rumesh Aponso (RMAX)
Nov 20, 20241 min read
Select Database Links in Oracle
select * from dba_db_links
2 views0 comments
Rumesh Aponso (RMAX)
Nov 20, 20241 min read
How to last compile data and time in Oracle
SELECT t.last_ddl_time, t.* FROMÂ Â all_objects t WHEREÂ t.object_type = 'PACKAGE BODY' ANDÂ Â Â t.OBJECT_NAME = 'CUSTOMER_ORDER_API';
2 views0 comments
Rumesh Aponso (RMAX)
Nov 20, 20241 min read
Change NLS_TERRITORY in Oracle
ALTER SESSION SET NLS_TERRITORY = Germany;
0 views0 comments
bottom of page