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:
PeopleSoft Enterprise PT PeopleTools - Version 8.56 and laterInformation in this document applies to any platform.
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |