There is no problem with FBIs in loading for TDM.
The particular problem was following:
In Oracle, when creating the following table with index:
CREATE TABLE tablename(
APPAUDITID Date NOT NULL,
CREATEDTS Timestamp(9) with time zone DEFAULT SYSTIMESTAMP NOT NULL,
CREATEDDT Date AS (CAST(CREATEDTS AS DATE)) NOT NULL
)
/
CREATE INDEX indexname ON tablename(CREATEDDT) /
Because in case of CREATEDDT column it is a Virtual Column, Oracle remakes this column to FBI with expression "(cast(some col as date))".
But in this case, Oracle doesn't allow to use this FBI and throws that error message.
TDM can't reverse this and Development will repair it as to make have this index loaded during RE as an index with CREATEDDT column.
To execute the workaround:
In that formerly reversed model, you can just rewrite that index to index using CREATEDDT column. To do this, go the the particular index, tab Items and change CAST(CREATEDTS AS DATE) to CREATEDDT. Or just uncheck "Generate Expression" and select CREATEDDT column on the tab.
If you would like to RE the db again, we can send you the repair in advance and it would load the indexes accordingly to be able to generate them flawlessly. In this case, I would recommend to upgrade to the latest version of TDM.
