My Oracle Support Banner

ORA-00904:"B":"CHECKOUT_DATE":Invalid Identifier When Running Advanced Search (Doc ID 1075230.1)

Last updated on FEBRUARY 15, 2019

Applies to:

Oracle Agile PLM Framework - Version 9.2.2.0 to 9.3.1.0 [Release 9.2.0.0 to 9.3]
Information in this document applies to any platform.

Symptoms

Advanced Search on Problem Report errors out when the output fields display includes Attachments.Checkout.Date

Error
"ORA-00904:"B":"CHECKOUT_DATE":Invalid Identifier "

Steps to Reproduce

1. Configure Advanced Search with below criteria:
Search for: Problem Report
Search Type: Object Type
CoverPage.Status In Default Problem Report.Review and
Workflow.Approver Contains Admin
3. Click More > Customize Output Display and add Attachment.Checkout Date to output fields, and OK
4. Run Search

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.