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

Last updated on MARCH 08, 2017

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.

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