Posts

Showing posts from 2021

FND Load Scripts

1. Lookups FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/aflvmlu.lct XX_CUSTOM_LKP.ldt FND_LOOKUP_TYPE APPLICATION_SHORT_NAME="XXCUST" LOOKUP_TYPE="XX_LOOKUP_TYPE" FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/aflvmlu.lct XX_CUSTOM_LKP.ldt UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE 2. Concurrent Program FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct XX_CUSTOM_CP.ldt PROGRAM APPLICATION_SHORT_NAME="XXCUST" CONCURRENT_PROGRAM_NAME="XX_CONCURRENT_PROGRAM" FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct XX_CUSTOM_CP.ldt - WARNING=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE 3. Profile FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afscprof.lct XX_CUSTOM_PRF.ldt PROFILE PROFILE_NAME="XX_PROFILE_NAME" APPLICATION_SHORT_NAME="XXCUST" $FND_TOP/bin/FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afscprof.lct XX_CUSTOM_PRF.ldt - WARNING=YES UPLOAD_MODE=REPLACE CUSTO

PLSQL Developer icons are small on Windows 10

Recently i had to use PLSQL Developer on my windows10 laptop. The icons, fonts etc were so small and tried few things. One thing that worked for me i am sharing. I am also adding the URL from where i found it. So any credit coming should go to that thread/website. Get shortcut of sqldeveloper at your desktop Ensure that you have admin rights in your PC Right Click on sqldeveloper icon and select Properties. Go to the Compatibility tab: Compatibility mode change it to windows 7 Check the option of Override high DPI scaling behavior Select "System" in drop down below Apply Re-Launch the application This worked like a charm. Thanks to original person who shared this. I am saving this on my blog, so that if i face this in future! I have this handy. Source: https://stackoverflow.com/questions/50138830/how-to-increase-size-of-gui-font-everything-of-oracle-sql-developer-18-1/50139062

How to Turn off Low Level Diagnostics in R12

Disable diagnostic logging with the following steps: 1. Login as a user with System Administrator responsibility and then navigate to:  Profile > System. Set the following profile option at the User level: FND: Debug Log Enabled = No 2. Logout of the application. You may also want to clear the browser's cache. 3. Login again and confirm that the message no longer appears. Source: Doc ID 1326490.1 (Oracle Technical support)

Creating Shortcuts in Toad

Image
One way to create user shortcuts in TOAD is View -->      TOAD Options --> Toolbars/Menus --> Shortcuts  Pick the Command you need to change.  For eg: Execute Statement. This is usually F9. I am changing it to ALT + X Click on F9 and then enter ALT , 'X' till the Shortcut changes to Alt + X as shown below.