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.
*********************************************************************************
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