For example:
*********************************ERROR*******************************
Index created.
CREATE INDEX PHR.IDX_APPAUDIT_CREATEDDT ON PHR.APPAUDIT (CAST("CREATEDTS" AS DATE))
*
ERROR at line 1:
ORA-54018: A virtual column exists for this expression
*********************************ERROR*******************************
Index created.
CREATE INDEX PHR.IDX_APPAUDITDTL_CREATEDDT ON PHR.APPAUDITDTL (CAST("CREATEDTS" AS DATE))
*
ERROR at line 1:
ORA-54018: A virtual column exists for this expression
Index created.
Is this a new ISSUE or does TDM not support FBI ddl generation? Does this issue occur for all FBI’s?
During RE, creating Indexes where there is a virtual column is reference an error is generated.