[Solved]Automatically objects are getting invalid after some days.

Issue:
we have facing some issue that some objects are automatically gets invalid after some days.
after running script utlrp.sql it will get valid but issue comes again after some days.

Solution:
Please follow the below steps.
1) Run 'Re-create grants and synonyms for APPS schema' in adadmin.
2) As sysdba, run the following twice in order to compile any dependent objects
SQL > @?/rdbms/admin/utlrp.sql
3) Run 'Compile APPS Schema' in adadmin
4) Run 'Validate APPS Schema' in adadmin
5) Run the following report:
$AD_TOP/sql/adutconf.sql


I hope issue has been resolved invalid objects.

ORA-20000: ORU-10027: buffer overflow, limit of 2000 bytes

Question: 
I am using a procedure to try to pull data for reporting purposes.  I am getting the following ORA-20000 with ORU-10027 error:

ORA-20000: ORU-10027: buffer overflow, limit of 2000 bytes

I need the output for a report, so I cannot just disable it to eliminate the ORA-20000 ORU-10027.

What can I do to get rid of the ORA-20000 ORU-10027 error?

Answer: 
DBMS_OUTPUT has different default buffer sizes, depending on your Oracle version.  For your system, the limit is 2000 bytes.You can increase the buffer up to 1,000,000 using the following PL/SQL statement:

 DBMS_OUTPUT.ENABLE(1000000);

The SQL*Plus statement to achieve the same result is:

set serveroutput on size 1000000

Starting with Oracle release 10g, it is possible to use the following unlimited buffer settings:

• PL/SQL: DBMS_OUTPUT.ENABLE (buffer_size => NULL);
• SQL*Plus: set serveroutput on size unlimited

Since I do not have the code you are running, I cannot do a full diagnostic on it.  If the DBMS_OUTPUT settings in the code are acceptable for your version of Oracle and the client (SQL*Plus, etc.) you are using and you are still getting the ORA-20000 ORU-10027 buffer overflow error for the stated limits, you should check your full code to determine whether there are any other calls that include conflicting DBMS_OUTPUT.ENABLE settings that might be overriding yours.

[Solved]Error No: 53 File not found Bi Publisher

Issue:
Following error pop-up is coming when we hit Oracle BI Publisher > Preview > PDF/EXCEL 
Error No: 53
Desc: File not found
Please confirm that
1) Java runtime version is 1.3 or later is installed correctly
2) The Java executable is accessible through the Windows Path or the Java Home directory is entered in the Preview tab of the options dialog

Solution:
Select correct Java Home by clicking on Browser button next to it.

Navigation:
 Ms Word -->Tools -- > options --> preview tab.

Java home should be selected there, if not select it or update path

BI Publisher desktop won’t install

I’m running windows 7, 8 with office 2010, 2013 respectively.  Have oracle 11G client.  I’m using this machine for some Report development.

But, I keep getting: “Template Builder Installer failed": Unexpected Error”

People are putting all sorts of stuff on forums that look like pot shots.  “Try uninstall and install again” – huh???,  but computers generally do the same thing given the same input.

How about I find some log files and go from there.

C:\Users\AmitGupta\AppData\Local\Temp has TemplateBuilderInstaller.log – WOW!  direct hit.

This has:

Word process check start
Error No.: 339
Description: Component 'MSCOMCTL.OCX' or one of its dependencies not correctly registered: a file is missing or invalid

WOW again, direct hit.

I need to install this file, mscomctl.ocx does not exist on my machine

http://www.microsoft.com/downloads/en/details.aspx?FamilyID=25437d98-51d0-41c1-bb14-64662f5f62fe&displaylang=en

download this file, and install it.  You can install this on 64 windows.

Right…  That did not work, even when I tried the repair…  Damn!

I tried a few other things, and then.

http://www.ascentive.com/support/new/support_dll.phtml?dllname=MSCOMCTL.OCX

Downloaded this file (MSCOMCTL.OCX)

And then put this file C:\Windows\SysWOW64 location.

Restart the installation!