EBS 12.1.3 Login Page not working

Issue:

On : 12.1.3 version:

When attempting to login to ebs application, the following error occurs:

Error:

You have encountered an unexpected error. Please contact the System Administrator for assistance.

The Error Detail page displays:

Exception Details. 
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation.  Statement: select /*+ ORDERED PUSH_SUBQ USE_NL (WN WL WIT) index(WN WF_NOTIFICATIONS_N1)*/ WN.NOTIFICATION_ID,

## Detail 0 ##
java.sql.SQLSyntaxErrorException: ORA-00904: "WN"."SENT_DATE": invalid identifier

Solution:

Follow the below steps to fix the issue.

1. Stop the application tier services.

2. Use adodfcmp utility to alert the table:

cd $FND_TOP/patch/115/odf

adodfcmp odffile=afwf.odf mode=tables changedb=Yes \

userid=applsys/apps touser=apps/apps priv_schema=SYSTEM/manager

3. Restart the application tier services.
4. Retest the issue.

Recreate the appsutil/scripts directory

Issue: The $ORACLE_HOME/appsutil directory or subdirectories of appsutil are missing.

Solution:

To implement the solution, please update the RDBMS ORACLE_HOME file system with AutoConfig files from the AppsTier by performing the following steps exactly:

1. On the Application Tier (as the APPLMGR user):

2. Log in to the APPL_TOP environment and source the environment file

3. Create appsutil.zip file: "perl /bin/admkappsutil.pl"
(This will create appsutil.zip in $APPL_TOP/admin/out/appsutil.zip)

4. Copy or FTP the appsutil.zip file to the RDBMS $ORACLE_HOME

5. On the Database Tier (as the ORACLE user):
$ cd $ORACLE_HOME

$ unzip -o appsutil.zip

6. Generate the Database Context File:

Context File Creation on Linux:

$ cd $ORACLE_HOME

$ *.env

$ cd $ORACLE_HOME/appsutil/bin

$ perl adbldxml.pl tier=db appsuser= appspasswd=

$ cd $ORACLE_HOME/appsutil/bin


$ adconfig.sh contextfile= appspass=