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)

How to generate DBC file in R12 EBS

How to generate DBC file in EBS R12?

java oracle.apps.fnd.security.AdminAppServer apps/apps ADD FNDNAM=apps GWYUID=applsyspub/pub TWO_TASK=DATABASE_NAME SECURE_PATH=$FND_TOP/secure GUEST_USER_PWD=guest/oracle APPS_JDBC_DRIVER_TYPE=THIN DB_HOST=db_host_name DB_PORT=db_port