Oct 31, 2019

Oracle Branding Logo Change


Oracle Branding Logo Change



Step 1 : Place the XXX.Png file under $OA_MEDIA directory in App Tier.
Step 2 : Query the Profile & Change the value . 
              System Administrator > Profile - System.
              Query profile "Corporate Branding Image for Oracle Applications"
              Change the SITE level value to the name of the custom image file { XX_CUSTOM_LOGO.jpg }
Step 3 :  Clear the Cache From Functional Administrator.



Oct 17, 2019

TOAD TNS Entry Issue

TOAD for Oracle 9 or TOAD 10 – 64-bit Windows – ORA-12154: could not resolve the connect identifier specified or ORA-6413: connection not open

I recently downloaded the new 10.x version of TOAD and could not connect to my databases. Still running TOAD 9.x, no problem. This really threw me off for a minute, so I thought I would share the resolution.
You are likely running a 64-bit Windows OS and have installed TOAD into C:\Program Files (x86)\....
I simply copied over my entire Quest Software directory from C:\Program Files (x86)\... to C:\Program Files\..., and restarted the TOAD.exe. Everything is working great, without having to reinstall anything.

Useful Workflow Commands

  WFLOAD apps/columbus789 0 Y DOWNLOAD APEXP_FINDEV.wft APEXP Locations: $PO_TOP/patch/115/import/US/porpocha.wft $PO_TOP/patch/115/import/U...