Getting An Error When Creating A Date Time Field On Opportunity: Column not found for table usage 300000001240411 type Datetime (Doc ID 2280181.1)

Last updated on JUNE 24, 2017

Applies to:

Oracle Fusion Sales Cloud Service - Version 11.12.1.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.12.1.0.0 version, Opportunities

Getting an Error when creating a Date Time field on Opportunity
We get an error as "Column not found for table usage 300000001240411 type Datetime" when we try to create a date Time field on opportunity. Please find the attachment of the Customization report and screenshot of the error we get. We have created 256 custom fields out of which only 4 are Date and Time fields

ERROR
-----------------------
Column not found for table usage 300000001240411 type Datetime

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Application Composer
2. Opportunity
3. Fields
4. Create new Custom field of DateTime
5. Error Shows Up

BUSINESS IMPACT
-----------------------
Can not create new date time field

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms