Oracle Application DBA

Unable to Connect Oracle Database Server from Oracle Client - Change Oracle Database Character Set Applies to:             Oracle Enterprise Linux – Version: 5             Oracle EBS R12             Description: I have installed a new VISION instance on Oracle Linux 5. All is going well, all configuration and setup completed successfully. All services of Database and Application started successfully. Application is also working fine from client side. I have a problem to connect database from client side. TNSNAMES.ORA file also configured on client side but unable to connect SQLPLUS. SQLPLUS session going to hang/close when trying to connect: CMD> Sqlplus apps/apps@VIS Solution: After some research I found that the character set of Database is default to “AL16UTF16” which create the problem to connect the database from a windows client. So that to fix the problem, change the character set from “AL16UTF16” to “WE8MSWIN1252” To fix the problem do the f

Late Charges Report Print Wrong Date - Less Than 1 Day of the Original Date Applies to:             Oracle Receivables R12 12.1.3             Oracle Database 11.1.0.7.0 Description: We have noted that the “Late Charges Report” print the wrong date less than 1 day of the original date. Responsibility: Receivables Manager Navigation: Late Charges à Generate Late Charges à Late Charges Generate Solution: After some research work I found the solution to apply the following patch: Patch 26500596             ·          You should take backup of your system before applying the patch ·          First apply patch in a TEST environment ·          Re-test the issue I have fixed my issue by applying the above patch, now the date print accurately.             Your comments, especially which will help us improve the functionality, will be greatly appreciated J