2529293 - Error ORA-00907 - Wrong script generated with "identity" column - SAP PD

• PowerDesigner is generating a script that is not correct and when using this script to create a table in Oracle 12c, it reports the error below:

----
#Error in line : 2 in command -
create table SUDIS_INV_AMBIENTE (
ID_AMBIENTE NUMBER not null generated always as identity ( start with 1
increment by 1 nocycle order),
NME_AMBIENTE VARCHAR2(100) not null
)
tablespace SUDIS_TS

Error report -
ORA-00907: missing right parenthesis
00907. 00000 - "missing right parenthesis"#
----

• The correct script should be:

----
ID_AMBIENTE NUMBER generated always as identity ( start with 1
increment by 1 nocycle order) NOT NULL,
NME_AMBIENTE VARCHAR2(100) not null
)
tablespace SUDIS_TS;#
----

SAP PowerDesigner (PD) 16.6

Wrong script, identity, power designer, CR810536 , KBA , BC-SYB-PD , PowerDesigner , Bug Filed