Sairam Nimmagadda

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

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)

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. 

I had to replace REGEXP_REPLACE to regular REPLACE like below. Code: REPLACE(v_value, '&', '&'||'amp;'); I found the solution from this link. https://cloudcustomerconnect.oracle.com/posts/8e55f4748c

DECLARE    output utl_file.file_type;     v_data  varchar2(20000);     v_file_path varchar2(100); BEGIN    output := utl_file.fopen('/data/test/DEV/excel'                                           ,'Test.xls'                                           ,'w'                                            ,32000);               owa_sylk.show(p_file  => output                                       ,p_query => 'SELECT msi.organization_id                                                               ,msi.segment1 item_number                                                               ,msi.description item_description                                                            FROM inv.mtl_system_items_b msi                                                            WHERE msi.organization_id = :org_id'                      ,p_parm_names  => owa_sylk.owasylkarray('org_id')                      ,p_parm_values => owa_sylk.owasylka

When the XML Publisher creates the Excel output file with fields having leading Zero, when the output file is opened in the Excel Format The leading zeros in the will be automatically lost by the Excel. Excel treat the number in character format as number, we need force excel to treat this value as character and not as numeric value. In my case the tag  01007926 When opening in Excel Format, all i can see is 1007926 . During XML template design, Instead of the using the tag  use      = " < ? XX_INVOICE_NUM ? > " Please remove spaces. They are only there for the purpose of posting in this blog It wraps the value with double quotes. Now Excel treat value as character and doesn't trim the leading zeroes of value. I found the solution from this link  http://peoplesoftlearnings.blogspot.com/2010/04/how-to-avoid-trimming-of-leading-zeros.html