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_Date,

NVL(:P_BU_NAME,'ALL') BU_NAME,

NVL(:P_SOURCE,'ALL') SOURCE,

TO_CHAR (:INV_P_FROM_DATE, 'DD-MON-RRRR') From_Invoice_Date,

TO_CHAR (:INV_P_TO_DATE, 'DD-MON-RRRR') To_Invoice_Date,

TO_CHAR (SYSDATE + 3/24, 'DD-MM-YYYY HH12:MI:SS AM') PRINT_DATE,

to_char(sysdate,'DD-MON-RRRR HH24:MI:SS') as RUN_DATE,

((select SUBSTR(external_virtual_host,INSTR( external_virtual_host, '-', 1,2 )+1,9) from ask_deployed_domains WHERE

deployed_domain_name='FADomain')) instance,

FND_GLOBAL.USER_NAME as RUN_BY

FROM DUAL

No comments:

Post a Comment