R11: OKEDTSFM: Pre-Defined Query 'Due This Month' In DTS Errors With ORA-00905
Last updated on MARCH 08, 2017
Applies to:Oracle Project Contracts - Version 220.127.116.11 to 18.104.22.168 [Release 11.5.10]
Information in this document applies to any platform.
Selecting the Pre-Defined Query 'Due This Month' returns the following error message in the Delivery Tracking System from Project Contracts.
APP-FND-01242: Cannot read value from field OKE_DTS_MAIN.
Cause: The field OKE_DTS_MAIN. could not be located or read.
Action: This error is normally the result of an incorrectly-entered field
name string in a trigger, or a field name string that does not uniquely specify
a field in your form. Correct your trigger logic to precisely specify a valid
ORA-00905: missing keyword
FRM-40505: ORACLE ERROR: unable to perform query.
Query a contract in project contract - navigate to DTS. Use the flashlight to perform a query.
Find Deliverables window opens on the Default Filters tab select 'Due This Month' from the
Pre-defined Query LOV. Click on the Find Button - You receive an error msg. However, if you
select the other values from the LOV work.
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