Error in Validating AFF- Help needed

[paulmat555]

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

[SIVAKUMAR_G]

Hi

The view name must not contain any spaces.
Modify the view name to contain no spaces. Other requirements that must be met in order to prevent this errror are: it must begin with a letter and it may not contain any characters other than letters, numbers or underscores (_).

Regards
Sivakumar

[paulmat555]

Hi Shiva,

Thanks very much indeed....

I'll try as per your suggestion...

regards,

Paul