Customer Support Specialist: Errors JBO-27122, ORA-00904 clicking on Service Request links

(Doc ID 1378320.1)

Last updated on MARCH 02, 2016

Applies to:

Oracle Customer Support - Version 12.1.2 to 12.1.3 [Release 12.1]
Oracle Installed Base - Version 12.1.3 to 12.1.3 [Release 12.1]
Oracle Customer Support - Version 12.1.3 and later
Information in this document applies to any platform.
ChargeEO.xml
ChargeEOImpl.java
ChargeEOVO.xml
ChargeEOVORowImpl.java
EstimateChargeEOVO.xml
EstimateChargeEOVORowImpl.java

Symptoms

On the Service Request detail page (Update SR Page) when you add a related Service Request to the Related Service Request region, save and then attempt to click on the resulting link, you get an error.

-OR-

In Installed Base, when clicking the "Request Details" icon for the incident number of a particular Item Instance the same error occurs.

Error:

You have encountered an unexpected error. Please contact the System Administrator for assistance.

Steps:

(R) Customer Support Specialist
(N) Agent Dashboard

- Under My Service Request Region, click on Summary link
- Go to Update Service Request Page under Problem and Diagnosis Tab, under Related Service Request Region
- Add a SR and click on Save.
- Then attempt to click on the resulting link
=> Error occurs.

-OR-

(R) Install Base Agent User Responsibility
(N) View Item Instance

- For the Instance, select "Service Request" and click Go
- For the particular Incident Number click on "Service Request Details" icon to view the Service Request details
=> Error occurs.

Exception Details:

oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation.

Statement: SELECT * FROM (SELECT ChargeEO.ESTIMATE_DETAIL_ID,
      ChargeEO.LAST_UPDATE_DATE,
      ChargeEO.LAST_UPDATED_BY,
      ChargeEO.CREATION_DATE,
      [ ... ]
     ChargeEO.COVERAGE_BILLING_TYPE_ID,
      ChargeEO.TIME_ZONE_ID,
      ChargeEO.TXN_BILLING_TYPE_ID,
      ChargeEO.INVOICE_NUMBER,
      ChargeEO.INVOICE_DATE,
      ChargeEO.INVOICE_LINE_NUMBER,
      ChargeEO.TAX_AMOUNT,
      ChargeEO.FREIGHT_AMOUNT,
      ChargeEO.FREIGHT_FLAG,
      ChargeEO.BUSINESS_PROCESS_ID,
      ChargeEO.INCIDENT_ID,
      ChargeEO.ORIGINAL_SOURCE_ID,
      ChargeEO.ORIGINAL_SOURCE_CODE,
      ChargeEO.SOURCE_ID,
      ChargeEO.SOURCE_CODE,
      ChargeEO.CONTRACT_ID,
      ChargeEO.COVERAGE_ID,
      ChargeEO.COVERAGE_TXN_GROUP_ID,
      [ ... ]
      ChargeEO.TAX_CODE,
      ChargeEO.EST_TAX_AMOUNT,
      ChargeEO.OBJECT_VERSION_NUMBER,
      ChargeEO.PRICING_ATTRIBUTE16,
      ChargeEO.PRICING_ATTRIBUTE17,
      [ ... ]
      ChargeEO.RATE_TYPE_CODE,
       'N' DetailDisclosureBoolean,
      decode(ChargeEO.ORIGINAL_SOURCE_CODE,original_source_code,(Select meaning
   from cs_lookups
  where lookup_code = original_source_code
    and lookup_type = 'ESTIMATE_SOURCE'),original_source_code )
original_source_code_desc,
     (CASE original_source_code
        WHEN 'SR' THEN (SELECT incident_number  FROM cs_incidents_all_b WHERE incident_id    = original_source_id)
        WHEN 'DR' THEN (SELECT repair_number    FROM csd_repairs        WHERE repair_line_id = original_source_id)
        WHEN 'SD' THEN (SELECT h.debrief_number FROM csf_debrief_headers h, csf_debrief_lines l
                         WHERE h.debrief_header_id = l.debrief_header_id  AND l.debrief_line_id = original_source_id)
        ELSE null
      END ) original_source_number,
      decode(ChargeEO.SOURCE_CODE,source_code,(Select meaning
                                                 from cs_lookups
                                                where lookup_code = source_code
                                                  and lookup_type = 'ESTIMATE_SOURCE' ),source_code ) source_code_desc,
     (CASE source_code
        WHEN 'SR' THEN (SELECT incident_number  FROM cs_incidents_all_b WHERE incident_id = source_id)
        WHEN 'DR' THEN (SELECT repair_number    FROM csd_repairs        WHERE repair_line_id = source_id)
        WHEN 'SD' THEN (SELECT h.debrief_number FROM csf_debrief_headers h, csf_debrief_lines l
                         WHERE h.debrief_header_id = l.debrief_header_id  AND l.debrief_line_id = source_id)
        ELSE null
     END ) source_number,
lookup_code LINE_STATUS,
 meaning line_status_name,
 ChargeEO.instrument_payment_use_id
FROM CS_ESTIMATE_DETAILS  ChargeEO,
     fnd_lookup_values_vl flv
WHERE lookup_type = 'CS_CHG_LINE_STATUS'

 AND lookup_code = decode(chargeeo.charge_line_type,   'ESTIMATE',  
'NEW',   'IN_PROGRESS',   'NEW',   decode(nvl(chargeeo.order_line_id,  
-999),   -999,   decode(nvl(chargeeo.submit_error_message,   'xxx'),  
'xxx',   decode(nvl(chargeeo.submit_restriction_message,   'xxx'),  
'xxx',   'NEW',   'FOR_REVIEW'),   'IN_ERROR'),   'SUBMITTED'))) QRSLT  
WHERE (CHARGE_LINE_TYPE IN ('ACTUAL','IN_PROGRESS') AND INCIDENT_ID =
:1)
ORDER BY ESTIMATE_DETAIL_ID desc
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:886)
at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:1009)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:211)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:133)
at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:797)
at oracle.apps.cs.charges.webui.CsROActualChargesMainCO.processRequest(CsROActualChargesMainCO.java:60)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:600)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
at oracle.apps.fnd.framework.webui.OAWebBeanHideShowHelper.processRequest(OAWebBeanHideShowHelper.java:104)
at oracle.apps.fnd.framework.webui.OAHideShowHeaderHelper.processRequest(OAHideShowHeaderHelper.java:126)
      [ ... ]

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

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
[ ... ]


-OR-

java.sql.SQLSyntaxErrorException:
ORA-00904: "CHARGEEO"."ORIG_SYSTEM_LINE_REFERENCE": invalid identifier

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
[ ... ]


WORKAROUND
----------
None.

Changes

None.

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