Customer Support Specialist(CSZ) - Receiving ORA-00904: "INCIDENTDATE": Invalid Identifier Error (Doc ID 1937752.1)

Last updated on MARCH 02, 2016

Applies to:

Oracle Customer Support - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

In the Agent Dashboard, Update Service Request, when attempting to sort the 'Date Completed' column using the personalize option from the "Service Requests for Item Instance" section by navigating from the Agent Dashboard, the following error is thrown.

Error

You have encountered an unexpected error. Please contact the system administrator for Assistance.
Click here for exception details

Exception details:
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (Select incident_id, incident_number Request,
s.name, inc.customer_product_id, inc.incident_date, inc.close_date, inc.incident_status_id, inc.incident_number,
inc.summary summary
from cs_incidents_all_vl inc, cs_incident_statuses_vl s
where inc.incident_status_id = s.incident_status_id) QRSLT WHERE (:1 = CUSTOMER_PRODUCT_ID)AND (:2 <> INCIDENT_ID) ORDER BY INCIDENTDATE asc

## Detail 0 ##
java.sql.SQLSyntaxErrorException: ORA-00904: "INCIDENTDATE": invalid identifier


Steps to Reproduce

1) Responsibility : Customer Support

2) Navigation : Agent Dashboard


  Select a Service Request from 'My Service Requests'
  Select one of the Service Requests and select tab Problem and Diagnosis
  Select the Personalize page on the top right and then click on Content Tab
  From the Service Requests for Item Instance Section click the pencil to personalize the Service Requests for Item Instance section
  Select the pencil next to Date Created
  On the Responsibility level, change the Sort Allowed value from inherit to yes. Click Apply
  Use the link at the bottom of the page to Return to Application
  Click the Date Created column to sort when the errors are thrown.


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