Concurrent request output and log opens like form and not in text/word - Oracle EBS R12

http://systemadministratorsys.blogspot.com/2016/12/concurrent-request-output-and-log-opens.html

Concurrent request output and log opens like form and not in text/word

Concurrent request output and log opens like form and not in text/word. We have to Navigate to Tools>Copy
set the profile, "Viewer: Text" to Browser. This will open the output / log in browser

FSG Report Last run date - Oracle EBS R12

http://systemadministratorsys.blogspot.com/2016/12/fsg-report-last-run-date.html

FSG Report Last run date

select * from  fnd_concurrent_requests bb, fnd_concurrent_programs_vl jj, RG_REPORTS_V cc
where bb.CONCURRENT_PROGRAM_ID = jj.CONCURRENT_PROGRAM_ID
and cc.REPORT_ID = bb.ARGUMENT7
and jj.USER_CONCURRENT_PROGRAM_NAME = 'HUBCO Program - Publish FSG Report'
order by bb.REQUEST_ID desc

Convert number to character in PLSQL - Oracle EBS R12

http://systemadministratorsys.blogspot.com/2016/12/convert-number-to-character-in-oracle.html

Convert number to character in PLSQL

select spell_number (50000) from dual