Sunday, 29 May 2016

Blank Page Issue In Oracle ERP R12

There are could be many reasons of the blank page issue. Recently, I faced below cause of this issue.

ERROR:1 -
Below error appeared in $LOG_HOME/ora/10.1.3/opmn/opmn/oafm_default_group_1/oafmstd.out

11/12/15 14:27:19.974 html: chain failed
javax.servlet.ServletException: java.lang.RuntimeException: ORA-04063: package body "APPS.FND_WEB_SEC" has errors
ORA-06508: PL/SQL: could not find program unit being called: "APPS.FND_WEB_SEC"
ORA-06512: at line 1

at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.EvermindPageContext.handlePageThrowable(EvermindPageContext.java:899)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.EvermindPageContext.handlePageException(EvermindPageContext.java:816)
at _AppsLocalLogin._jspService(_AppsLocalLogin.java:303)
at com.orionserver[Oracle Containers for J2EE 10g (10.1.3.4.0) ].http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:462)
at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)
at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)

Cause: Due to FND_WEB_SEC package was corrupted.

Action Plan:1 Try to compile the package. ( It's not resolved)

SQL> ALTER PACKAGE FND_WEB_SEC COMPILE BODY;

Warning: Package Body altered with compilation errors.

SQL> SHOW ERROR
Errors for PACKAGE BODY FND_WEB_SEC:

LINE/COL ERROR
-------- -----------------------------------------------------------------
0/0 PLS-00753: malformed or corrupted wrapped unit

Solution:

Please execute the following steps:

1. Login to UNIX session of the EBS Apps Tier

2. Set the application environment file

3.  Validate the version of the package FND_WEB_SEC in database

select text from user_source
where NAME= 'FND_WEB_SEC'
and line = 2;

4. Validated the version of FND_WEB_SEC package in file system,

cd $FND_TOP/patch/115/sql

adident Header AFSCJAV8.pls
adident Header AFSCJAVB.pls
adident Header AFSCJAVS.pls

Note : FND_WEB_SEC version in DB and File system should match

5. Execute the below commands

sqlplus apps/<apps pw> $FND_TOP/patch/115/sql/AFSCJAVS.pls
sqlplus apps/<apps pw> $FND_TOP/patch/115/sql/AFSCJAVB.pls
sqlplus apps/<apps pw> $FND_TOP/patch/115/sql/AFSCJAV8.pls

4. Validate that FND_WEB_SEC the package is valid.

select OBJECT_NAME,OBJECT_TYPE,STATUS from all_objects where OBJECT_NAME='FND_WEB_SEC';


5. Retest the issue. 


Solution:2  Check your tablespace size, Might be full.

*********************************************************************************

No comments:

Post a Comment

OS Watcher Installation in RAC

 Step:1 Download and untar the oswbb812.tar under the grid user in RAC on the both nodes. Follow the OS Watcher User's Guide (Doc ID 153...