Customer Support Specialist(CSZ) - Receiving ORA-00904: "INCIDENTDATE": Invalid Identifier Error
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.
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.
You have encountered an unexpected error. Please contact the system administrator for Assistance.
Click here for 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,
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.
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