Hi friends,
I have been practicing on a mock implementation, and twice this error has appeared while trying to validate the AFF. The oupput of the error is as follows -
Oracle error 905: ORA-00905: missing keyword
ORA-06512: at "SYSTEM.AD_DDL", line 160
ORA-06512: at line 1 has been detected in afuddl() [3_xdd].
do_ddl(APPLSYS, SQLGL, 2, $statement$, BOBLAK AFF VIEW): private_do_ddl(APPS, APPLSYS, GL, 2, $statement$, BOBLAK AFF VIEW): do_cd_view(0, APPS, 2, BOBLAK AFF VIEW, $statement$): : do_apps_ddl(APPS, $statement$): : substr($statement$,1,255)='CREATE OR REPLACE VIEW BOBLAK AFF VIEW
(ROW_ID, CODE_COMBINATION_ID, Company, Cost_Sentre, Accounts, GL_ACCOUNT_TYPE, GL_CONTROL_ACCOUNT, RECONCILIATION_FLAG, DETAIL_BUDGETING_ALLOWED, DETAIL_POSTING_ALLOWED, REFERENCE2, LAST_UPDATE_DATE, ATTRIBUTE4, RE'
Oracle error 905: ORA-00905: missing keyword
ORA-06512: at "SYSTEM.AD_DDL", line 160
ORA-06512: at line 1 has been detected in afuddl() [3_xdd].
do_ddl(APPLSYS, SQLGL, 2, $statement$, BOBLAK AFF VIEW): private_do_ddl(APPS, APPLSYS, GL, 2, $statement$, BOBLAK AFF VIEW): do_cd_view(0, APPS, 2, BOBLAK AFF VIEW, $statement$): : do_apps_ddl(APPS, $statement$): : substr($statement$,1,255)='CREATE OR REPLACE VIEW BOBLAK AFF VIEW
AS SELECT 'View generation has failed. Check log file for error messages' VIEW_HAS_FAILED_CHECK_LOG_FILE
FROM SYS.DUAL'
Can anybody help me as to the reason what this might be....??
Any help would be much appreciated...
Thanking you,
Paul
Error in Validating AFF- Help needed
-
- Posts: 9
- Joined: Thu Jun 14, 2007 7:25 am
- Location: India
-
- Posts: 194
- Joined: Tue May 15, 2007 7:45 am
- Location: United Arab Emirates
-
- Posts: 9
- Joined: Thu Jun 14, 2007 7:25 am
- Location: India
Who is online
Users browsing this forum: No registered users and 1 guest