While using DBEMS as "admin.persistence.type" in adapter framework, It creates below tables in the database and used as datastore.: 
ADAPTER
ADAPTERAGENT
ADAPTERAPPLICATION
ADAPTERAPPLICATIONiNSTANCE
ADAPTERAPPSPACE
ADAPTERCOMMANDHISTORY
ADAPTERINSTALLEDSOFTWARE
ADAPTERINSTANCE
ADAPTERINSTANCESTATUS
ADAPTERNODE
ADAPTERNODESTATUS
ADAPTERTEAAGNET

When starts adapteragent, it throws error as
" "WARN c.t.a.m.p.r.AdapterRDBMSDataManager - handling error in operation [createCommandHistory]", createCommandHistory is the table name.
Error "Message: ORA-00904:"ColumnName": invalid identifier" 
After that  then adapteragent starts successfully.

 

Error "Message: ORA-00904:"ColumnName": invalid identifier" .

======================================== Product: TIBCO Adapter Framework(ADF) Version: 1.3.1 and above OS: All Supported Operating Systems ========================================

To resolve this issue,there is two workarounds:
1.When DBEMS is used as "admin.persistence.type" and is configured DB connection with Oracle 12C, In the DB, some tables are created in DB and used as datastore.
When the error "Message  : ORA-00904:"ColumnName": invalid identifier" occurs, check all DB store tables listed above and find in which table "ColumnName" is located.
To find the correct table, search for the following error message.

Example:

 "WARN c.t.a.m.p.r.AdapterRDBMSDataManager - handling error in operation [createCommandHistory]", createCommandHistory is the table name.

Add the missing column name in the respective table to resolve the error.

2. Remove and recreate the above adapter tables using the script provided by the ADF: 

<TIBCO_HOME>\afx\<version>\config\dbscripts