Oracle_Apps
Wednesday, 28 May 2025
Query to get ESS Job Last Run Date
›
SELECT NVL(Max(erh.processstart), NULL) last_run_date FROM ess_request_history erh, ess_request_property erp1 ...
Monday, 12 May 2025
Query to get ESS Request details(Oracle Fusion)
›
SELECT UNIQUE rh1.requestid Child_requestid,rp1.value job_id --,rh.PARENTREQUESTID request_id FROM fusion.ess_request_history rh1, fusion...
Sunday, 11 May 2025
To Display the Run time and instance Details(Oracle Fusion)
›
SELECT TO_CHAR (:ACCOUNTING_P_FROM_DATE, 'DD-MON-RRRR') From_GL_Date, TO_CHAR (:ACCOUNTING_P_TO_DATE, 'DD-MON-RRRR') To_GL...
Query to extract the user details(Oracle Fusion)
›
SELECT pur.username USER ,papf.person_number EMP_NUM ,ppnf.first_name EMP_FIRST_NAME ,ppnf.last_name EMP_LAST_NAME ,DECODE(SUSPENDED,...
More Columns in RTF(Oracle Fusion)
›
Suppose we are developing the RTF report with more than 30 columns then we don't have sufficient place in the RTF even if we used the l...
Tuesday, 6 May 2025
Date and Time parameter for Oracle Report(Oracle Fusion)
›
Hi Guys, Usually we are using the format as 'MM-dd-yyyy' for Date parameter in the Data model to display for Date calendar. In case...
To remove the space lines in the notepad++
›
Suppose we have the extra space lines between the lines like below then go to Edit ----> Line Operations ------> Remove empty lines ...
›
Home
View web version