Apex 21.1 in local machine and 21.2 is at apex.oracle.com
created a table orderstest, contains 2 columns with default values, one is varchar2 type and another is timestamp(6) - below are related sql scripts.
when inserting data through SQL Command window it assigned default values as expected but when create Form and create a row through Form, there is no value in both columns with default values. please guide. ( also checked at apex.oracle.com. same problem )
Scripts:
CREATE TABLE "ORDERSTEST"
( "ID" NUMBER(10,0) GENERATED BY DEFAULT ON NULL AS IDENTITY(start with 1 increment by 1),
"ORDER_DATE" DATE,
"ORDER_DESCRIPTION" VARCHAR2(200),
"CLIENT_ID" NUMBER(10,0),
"ORDER_TOTAL" NUMBER(12,2) DEFAULT 0,
"ORDER_STATUS" VARCHAR2(15) DEFAULT 'pending',
"CREATED_BY" NUMBER(10,0),
"CREATED_AT" TIMESTAMP (6) DEFAULT CURRENT_TIMESTAMP,
"UPDATED_BY" NUMBER(10,0),
"UPDATED_AT" TIMESTAMP (6),
CONSTRAINT "PK_ORDERSTEST_ID" PRIMARY KEY ("ID")
USING INDEX ENABLE
);
insert into orderstest (client_id, order_date, order_status) values (1, to_date(sysdate), 'pending' );
select id, order_status, created_at from orderstest order by id;
screenshot of apex.oracle.com (here first record inserted thru sql command window and second thru Form):
regards