Thursday, November 12, 2015

Reporting Tools available in Oracle Fusion

The following reporting options are available for Oracle Fusion Cloud product

1. BI Publisher (High volume transactional reports)
2. OTBI (Oracle Transactional Business Intelligence) (Closely related to OBIEE)
3. Financial Reporting Center (Hyperion like)
4. Smart View (Excel plugin)

Wednesday, November 11, 2015

Solution: Unable to run OAF Page from JDeveloper 505 Error

I was usually able to run the OAF pages from JDeveloper without any issues, but after trying to install a oracle database in the c:\oracle folder some settings were messed up, resulting in 505 Error when OAF pages were run.

Fix: to fix this I have gone through the log (the log section we have in the JDeveloper itself) carefully and found what the issue is..




C:\p9879989_R12_GENERIC\jdevhome\jdev\system\oracle.j2ee.10.1.3.41.57\embedded-oc4j\config\server.xml
[waiting for the server to complete its initialization...]
Nov 11, 2015 7:49:23 PM com.evermind.server.jms.JMSMessages log
INFO: JMSServer[]: OC4J JMS server recovering transactions (commit 0) (rollback 0) (prepared 0).
Nov 11, 2015 7:49:23 PM com.evermind.server.jms.JMSMessages log
INFO: JMSServer[]: OC4J JMS server recovering local transactions Queue[jms/Oc4jJmsExceptionQueue].
WARNING: Code-source C:\p9879989_R12_GENERIC\jdevbin\jdev\appslibrt\xml.jar (from in /C:/p9879989_R12_GENERIC/jdevhome/jdev/system/oracle.j2ee.10.1.3.41.57/embedded-oc4j/config/application.xml) has the same filename but is not identical to /C:/p9879989_R12_GENERIC/jdevbin/lib/xml.jar (from (ignore manifest Class-Path) in META-INF/boot.xml in C:\p9879989_R12_GENERIC\jdevbin\j2ee\home\oc4j.jar). If it contains different versions of the same classes, it will be masked as the latter is already visible in the search path of loader default.root:0.0.0.
WARNING: Code-source C:\p9879989_R12_GENERIC\jdevbin\jdev\appslibrt\jazn.jar (from in /C:/p9879989_R12_GENERIC/jdevhome/jdev/system/oracle.j2ee.10.1.3.41.57/embedded-oc4j/config/application.xml) has the same filename but is not identical to /C:/p9879989_R12_GENERIC/jdevbin/j2ee/home/jazn.jar (from in META-INF/boot.xml in C:\p9879989_R12_GENERIC\jdevbin\j2ee\home\oc4j.jar). If it contains different versions of the same classes, it will be masked as the latter is already visible in the search path of loader default.root:0.0.0.
WARNING: Code-source C:\p9879989_R12_GENERIC\jdevbin\jdev\appslibrt\jazncore.jar (from manifest of /C:/p9879989_R12_GENERIC/jdevbin/jdev/appslibrt/jazn.jar) has the same filename but is not identical to /C:/p9879989_R12_GENERIC/jdevbin/j2ee/home/jazncore.jar (from in META-INF/boot.xml in C:\p9879989_R12_GENERIC\jdevbin\j2ee\home\oc4j.jar). If it contains different versions of the same classes, it will be masked as the latter is already visible in the search path of loader default.root:0.0.0.
WARNING: Code-source C:\oracle\lib\xmlparserv2.jar (from manifest of /C:/p9879989_R12_GENERIC/jdevbin/jdev/appslibrt/jazncore.jar) has the same filename but is not identical to /C:/p9879989_R12_GENERIC/jdevbin/lib/xmlparserv2.jar (from (ignore manifest Class-Path) in META-INF/boot.xml in C:\p9879989_R12_GENERIC\jdevbin\j2ee\home\oc4j.jar). If it contains different versions of the same classes, it will be masked as the latter is already visible in the search path of loader default.root:0.0.0.
WARNING: Code-source C:\oracle\jlib\ldapjclnt10.jar (from manifest of /C:/p9879989_R12_GENERIC/jdevbin/jdev/appslibrt/jazncore.jar) has the same filename but is not identical to /C:/p9879989_R12_GENERIC/jdevbin/jlib/ldapjclnt10.jar (from in META-INF/boot.xml in C:\p9879989_R12_GENERIC\jdevbin\j2ee\home\oc4j.jar). If it contains different versions of the same classes, it will be masked as the latter is already visible in the search path of loader default.root:0.0.0.
15/11/11 19:49:26 WARNING: Application.setConfig Application: datatags is in failed state as initialization failed.
java.lang.IllegalAccessError: tried to access method oracle.xml.jaxp.JXDocumentBuilder.()V from class oracle.xml.jaxp.JXDocumentBuilderFactory
Nov 11, 2015 7:49:26 PM com.evermind.server.ServerMessages warningApplicationInitializationFailed
WARNING: Exception initializing deployed application: datatags. Application: datatags is in failed state as initialization failed
Nov 11, 2015 7:49:26 PM com.evermind.server.ServerMessages warningApplicationInitializationFailed
WARNING: Exception initializing deployed application: APPS_OA. Application: APPS_OA is in failed state as initialization failed
15/11/11 19:49:26 WARNING: Application.setConfig Application: APPS_OA is in failed state as initialization failed.
java.lang.IllegalAccessError: tried to access method oracle.xml.jaxp.JXDocumentBuilder.()V from class oracle.xml.jaxp.JXDocumentBuilderFactory
15/11/11 19:49:26 WARNING: Application.setConfig Application: current-workspace-app is in failed state as initialization failed.
java.lang.IllegalAccessError: tried to access method oracle.xml.jaxp.JXDocumentBuilder.()V from class oracle.xml.jaxp.JXDocumentBuilderFactory
Nov 11, 2015 7:49:26 PM com.evermind.server.ServerMessages warningApplicationInitializationFailed
WARNING: Exception initializing deployed application: current-workspace-app. Application: current-workspace-app is in failed state as initialization failed
Nov 11, 2015 7:49:27 PM com.evermind.server.http.HttpMessages internalErrorWhileTryingToInstantiate
SEVERE: Internal error raised tyring to instantiate web-application: webapp defined in web site OC4J 10g (10.1.3) Default Web Site. Application: webapp has been stopped

Upon looking it carefully, I found in those warning that the file version were not the same and copied the ones from jdev to c:\oracle and everything is back!!

Thanks,
Sridhar


Powered By Blogger

About Me

hyderabad, A.P, India
I am sridhar(sidhu) from India. Interested in sharing my views and myself with friends and well wishers.