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 11.5.10.2 to 11.5.10.2 [Release 11.5.10]
Information in this document applies to any platform.

Symptoms

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
field.

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.

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
References

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