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.
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.
No comments:
Post a Comment