My Oracle Support Banner

R11: OKEDTSFM: Pre-Defined Query 'Due This Month' In DTS Errors With ORA-00905 (Doc ID 783519.1)

Last updated on FEBRUARY 21, 2019

Applies to:

Oracle Project Contracts - Version to [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.




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

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