Issue: Issue occurred while running the 9651687 fix script.
SQL> @xla_mulent_fix.sql;
Exception occured :: ORA-20001:
DECLARE
*
ERROR at line 1:
ORA-20001:
ORA-06512: at "APPS.APP_EXCEPTION", line 72
ORA-06512: at line 468
Exception :: ORA-00904: "NEED_BAL_FLAG": invalid identifier
in side Print1
Exception occured When Creating xla_ae_headers Backup Table :: ORA-20001:
Exception occured :: ORA-20001:
Cause:
SQL> @xla_mulent_fix.sql;
Exception occured :: ORA-20001:
DECLARE
*
ERROR at line 1:
ORA-20001:
ORA-06512: at "APPS.APP_EXCEPTION", line 72
ORA-06512: at line 468
Log Details
in side Print1
Exception occured When Creating xla_ae_headers Backup Table :: ORA-20001:
Exception occured :: ORA-20001:
Cause:
The backup table is not having the column NEED_BAL_FLAG
Solution:
ALTER TABLE XAH_9651687_BKP ADD(NEED_BAL_FLAG VARCHAR2(1));
SQL> select column_name from ALL_TAB_COLUMNS where table_name='XAH_9651687_BKP';
COLUMN_NAME ------------------------------ NEED_BAL_FLAG CLOSE_ACCT_SEQ_VERSION_ID COMPLETION_ACCT_SEQ_VALUE
.....If the column appears in the output then run the fix script it should complete now.
SQL> @xla_mulent_fix.sql; ------------------------------------------------------------------------------- Please Note the Following information. Kindly open the Out file to proceed further Out file Location would be /usr/tmp/9651687-fix-15:23:56.html Log file Location would be /usr/tmp/9651687-fix.log ------------------------------------------------------------------------------- PL/SQL procedure successfully completed. SQL> exit
No comments:
Post a Comment