ERPstuff - Oracle EBS Community

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

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

Hi Shiva,

Thanks very much indeed....

I'll try as per your suggestion...

regards,

Paul