Hi,
for information, I have tested Oracle JDeveloper 12c and I met a problem we creating business component from table :
SELECT /*OracleDictionaryQueries.ALL_VISIBLE_USERS_QUERY*/
U.USERNAME, 'SCHEMA', NULL OBJECT_ID, NULL LAST_DDL_TIME
FROM SYS.DBA_USERS U
WHERE EXISTS ( SELECT 1
FROM SYS.DBA_TAB_PRIVS_RECD TPR
WHERE TPR.OWNER = U.USERNAME )
AND U.USERNAME LIKE ?
UNION
SELECT USER, 'SCHEMA', NULL OBJECT_ID, NULL LAST_DDL_TIME FROM SYS.DUAL
oracle.javatools.db.DBSQLException: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
at oracle.javatools.db.execute.StatementWrapper.createDBSQLException(StatementWrapper.java:711)
at oracle.javatools.db.execute.ConnectionWrapper.call(ConnectionWrapper.java:199)
at oracle.javatools.db.execute.ConnectionWrapper.call(ConnectionWrapper.java:117)
at oracle.javatools.db.execute.ConnectionWrapper.run(ConnectionWrapper.java:102)
at oracle.javatools.db.execute.QueryWrapper$QueryExecutionRunnable.runImpl(QueryWrapper.java:459)
at oracle.javatools.db.execute.StatementWrapper$ExecutionRunnable.run(StatementWrapper.java:920)
at oracle.ideimpl.db.ProgressBarExecutionWrapper.runAndLog(ProgressBarExecutionWrapper.java:137)
at oracle.ideimpl.db.ProgressBarExecutionWrapper.access$000(ProgressBarExecutionWrapper.java:37)
at oracle.ideimpl.db.ProgressBarExecutionWrapper$R.run(ProgressBarExecutionWrapper.java:181)
at oracle.ide.dialogs.ProgressBar.run(ProgressBar.java:961)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
....
Uncaught exception
java.lang.IllegalStateException: Must call setDescriptor before get/setFilter
at oracle.ide.db.controls.NameFilterField.getDescriptor(NameFilterField.java:99)
at oracle.ide.db.controls.NameFilterField.getFilter(NameFilterField.java:115)
at oracle.ide.db.panels.SelectDBObjectsPanel.saveSettings(SelectDBObjectsPanel.java:910)
at oracle.jbo.dt.jdevx.ui.pkg.XPKEntityFromTablePanel$XPKSelectDBObjectsPanel.doSaveSettings(XPKEntityFromTablePanel.java:1077)
at oracle.jbo.dt.jdevx.ui.pkg.XPKEntityFromTablePanel.leave(XPKEntityFromTablePanel.java:387)
at oracle.jbo.dt.ui.main.dlg.wizard.JboWizard.wizardValidatePage(JboWizard.java:2165)
at oracle.bali.ewt.wizard.WizardPage.processWizardValidateEvent(WizardPage.java:710)
at oracle.bali.ewt.wizard.WizardPage.validatePage(WizardPage.java:680)
....
-----------
Cause : object SYS.DBA_TAB_PRIVS_RECD does not exists in database (version 12.1)
I didn't found a patch, so I have applied a workaround in test environment :
In database, create the synonym as sysdba :
create synonym SYS.DBA_TAB_PRIVS_RECD for SYS.DBA_TAB_PRIVS;
Regards,
EGU.