SELECT ‘Request id: ‘||request_id , ‘Trace id: ‘||oracle_Process_id, ‘Trace Flag: ‘||req.enable_trace, ‘Trace Name: ‘||dest.value||’/’||lower(dbnm.value)||’_ora_’||oracle_process_id||’.trc’, ‘Prog. Name: ‘||prog.user_concurrent_program_name, ‘File Name: ‘||execname.execution_file_name|| execname.subroutine_name , ‘Status : ‘||decode(phase_code,’R’,’Running’) ||’-‘||decode(status_code,’R’,’Normal’), ‘SID Serial: ‘||ses.sid||’,’|| ses.serial#,…
Read MoreThe coronavirus outbreak has changed life as we know it. From enforcing travel restrictions to advising work from home, the governments are taking this challenge head-on. As the world takes…
Read MoreUse the below Link to create the Cerfiticate using Amazon SMTP address. https://whatsmychaincert.com/?email-smtp.us-east-1.amazonaws.com Creating Oracle Wallet : mkdir -p /u01/app/oracle/wallet/TEST orapki wallet create -wallet /u01/app/oracle/wallet/TEST orapki wallet add -wallet /u01/app/oracle/wallet/TEST…
Read MoreGot the below error during cloning. To fix this issue, need to “clear unarchived logfile group” Solution : SQL> alter database open resetlogs; alter database open resetlogs * ERROR…
Read MoreSometimes have a requirement to run the running total in XMLP Report and set the record per page by Variable declaration. Step to follow, Add the form field in RTF…
Read MoreSometimes, We have a requirement to disable the DFF at form level. Either have to do disable the DFF as well or Read-Only of the attribute of the DFF. So,…
Read MoreProcess to restrict number of rows per page in xml reports by using following command Let us take example if you want show 5 records per page you can use…
Read MoreHi All, This API useful to load lease data into oracle Property Manager module in oracle apps .pm_lease_code_func
Read MoreHi All, This query useful to get all the total amount by accounts in AR receivables. This will be useful in audit purpose for an account validation oracle-receivable-total-by-accounts
Read MoreHi All, API to apply Credit memo on invoice will be useful whenever situation occur if we have created AR invoices wrongly in oracle. For that credit memo has to…
Read More