E-ORA: When Attempting to Build a Record With a Custom Field (DATE) the Following Error Occurs: 904 - ORA-00904: : invalid identifier (Doc ID 2675716.1)

Last updated on JANUARY 03, 2023

Applies to:

Symptoms

When attempting to build a record,
the following error occurs.

ERROR
-----------------------
Error: CUSTOM_TBL - SQL Error. Error Position: 712 Return: 904 - ORA-00904: : invalid identifier

CREATE TABLE PS_CUSTOM_TBL (BUSINESS_UNIT VARCHAR2(5) NOT NULL,    PROJECT_ID VARCHAR2(15) NOT NULL,    PROJECT_ID_2 VARCHAR2(15) NOT NULL,    PROJ_REQUEST_ID VARCHAR2(15) NOT NULL,    PROJECT_USER1 VARCHAR2(10) NOT NULL,    PPK_INIT_TYPE_ID VARCHAR2(10) NOT NULL,    PROJECT_SUB_STATUS VARCHAR2(30) NOT NULL,    DECHRS DECIMAL(14, 2) NOT NULL,    DATE DATE) TABLESPACE FSLARGE STORAGE (INITIAL 40000 NEXT 100000 MAXEXTENTS UNLIMITED PCTINCREASE 0) PCTFREE 10 PCTUSED 80

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Insert a field named "DATE" into a record
2. Attempt to build the record

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.