Tuesday, February 11, 2020

Report output displays FNDWRR 'Query String Parse Error'

I was running Invoice print program but after normal completion output was giving me 'Query String Parse Error'
















I was on Windows 10 machine, EBS 12.2.9

For windows 10, solution is to change the MIME type for RTF to  application/msword.  

1.Navigate to System Administrator > Install > Viewer Options and select the entry for the RTF File Format.
2.Delete this row. (for  RTF  MIME Type application/rtf )
3.Add a new row for the RTF File Format with
4.Mime Type : application/msword
5.And with Allow Native Client Encoding checked.










6.Save the changes.
7.Open the same output file, it should solve the issue.


Reference: Doc ID 2484620.1

Monday, February 10, 2020

ORA-12545: Connect failed because target host or object does not exist

It's a very common error while connecting to the Database though any Oracle tool.

Few points to check.

1> Please check if you have the correct DB entry in the tnsnames.ora file.
     > If haven't, create a common TNSNAMES.ORA shared amongst all Oracle Homes
            a) Create c:\Oracle\TNS_ADMIN directory.
            b) Create TNS_ADMIN environment variable:


            c) Place the tnsnames.ora file in c:\Oracle\TNS_ADMIN directory with the 
                correct entry

2> Check if you have the related database connection (dbc) in place
      > If haven't, create a common FND_SECURE  home
            a) Create c:\Oracle\FND_SECURE directory.
            b) Create FND_SECURE environment variable:


            c) Place the related .dbc file in the c:\Oracle\FND_SECURE directory
                     > 11i path: $FND_TOP/secure
                     > R12 path: $INST_TOP/appl/fnd/12.0.0/secure
                     > If you do not have access to Unix box, check with your DBA

3> Please check if you have the correct host entry in your local Host file.
     Host entry must be matching with the host name in the tnsnames.ora file.
      > Host file location: C:\Windows\System32\drivers\etc

4> Most important one :)
     > If you are connecting remotely check if you are connected to the client VPN.