oracle.apps.fnd.framework.OAException: Could not load application module 'oracle.apps.fnd.sso.login.server.MainLoginPageAM'

Error :

Exception Details.
oracle.apps.fnd.framework.OAException: Could not load application module
'oracle.apps.fnd.sso.login.server.MainLoginPageAM'
...
## Detail 0 ##
oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND_NO_TRANSACTION_ID.
at oracle.apps.fnd.framework.webui.OAJSPHelper.getTransactionId(OAJSPHelper.java:350)
at oracle.apps.fnd.framework.webui.OAJSPApplicationRegistry.registerApplicationModule(OAJSPApplicationRegistry.java:133)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1279)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:532)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:420)
at _OA._jspService(_OA.java:216)
at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:335)
at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:478)
...

Relative Env:

Oracle Apps 11i and R12

Reason :

1. Increase or high no of Invalid Objects
2. Tablespace got filled


Solutions:

1. Check no of invalid objects.

select owner, object_type, count(*)
from dba_objects
where status='INVALID'
group by owner, object_type;

2. Compile the objects with  @?/rdbms/admin/utlrp.sql from sys user.
3. if required you can use adadmin to compile invalids
4. Check tablespace free space and add space if required.


For high traffic instance it is better to purge the inactive session periodically.

Schedule "Purge Inactive Sessions" program from sysadmin, it purges icx_trunsuctions

Follow the below note for more details.

Can Not Login To The Applications: oracle.apps.fnd.framework.OAException: FND_NO_TRANSACTION_ID error (Doc ID 737960.1)