SQL Script to find Oracle eBS concurrent program details based on partial cp name

–query to get concurrent programs and executable_details in one step… SELECT cp.user_concurrent_program_name, cp.concurrent_program_name, cp.concurrent_program_id, exe.executable_name, exe.execution_file_Name, exe.user_executable_name, lkp.meaning Execution_Method, app.application_short_name, listagg(‘RG=’ ||rgrps.request_group_name || ‘|CODE=’ || rgrps.request_group_code || ‘|’ ||chr(10) ||'(‘ || rgrps.resp_list || ‘)’, ‘, ‘) within GROUP ( ORDER BY rgrps.request_unit_id) rg_list FROM fnd_executables_vl exe, fnd_lookups lkp, fnd_application_vl app, fnd_concurrent_programs_vl cp, (SELECT DISTINCT gu.request_group_id, […]

Oracle OAF – How to auto-generate table accessor PKG and java PL/SQL EO Support Class

Step 1: Create Your Table. Step 2: Download Google Tapig. Code can be downloaded here. If you want to see the code first, and peruse the project site, do that here. To download all files involved herein, click tapi-results. Step 3: Needed to fix the google code to handle oracle style tables tapi_spec.sql: CREATE OR […]

Oracle OEL 3.8 VM Appliance for eBS R12.2.4 – Update to mount cdrom and use to install vbox guest additions and folder shares

Step 1:  Load Virtual Box Guest Additions CD image into machine’s cd drive. This is done by selecting the title bar of the running server and from the top menu, select “Devices –> Insert Guest Additions CD Image…” Step 2:  Determine device name on system of the cd-rom drive. This is done with the command: […]

Fix “Unable to watch path” error in Atom on Linux.

TypeError: Unable to watch path If you get following error with a big traceback right after Atom starts: TypeError: Unable to watch path you have to increase number of watched files by inotify. For testing if this is the reason for this error you can issue sudo sysctl fs.inotify.max_user_watches=32768 and restart Atom. If Atom now […]

How do I boot into the console and then launch the Ubuntu desktop from it?

At the Ubuntu login page I have to hit Ctrl+Alt+F1 to be able to login as an user using the command line. But how do I get to the command line first and then start the Ubuntu desktop from it? Source: How do I boot into the console and then launch the Ubuntu desktop from […]

cMRO – Finding source for AHL type LOV (called through AhlfLOV.jsp)

The first requirement is to find the name of the title passed into the callLOV() javascript function. For example: I needed to find out what was being called after navigating to:  CMRO Home –> Engineering –> Document Index –> Search –> Source –> LOV Selection popup. Upon clicking the LOV Spyglass next to Source, if […]

Ubuntu – how to mount encrypted, LVM based hdd from trial DVD

sudo mkdir /yod #creates a mount point sudo cryptsetup luksOpen /dev/sda5 yod #this will ask for decryption password, and create the mapper object sudo fdisk -l #shows that there is a device named: /dev/mapper/yod sudo pvs #shows that VG=ubuntu-vg sudo lvdisplay /dev/ubuntu-vg #shows that LV Name: /dev/ubuntu-vg/root sudo mount /dev/ubuntu-vg/root /yod verify: cd /yod ls