My Oracle Support Banner

java.sql.SQLSyntaxErrorException: ORA-00904: "VIEW_ATTR": invalid identifier - While Sorting Work Confirmation Through Statuses in iSupplier Portal (Doc ID 2550741.1)

Last updated on JUNE 05, 2019

Applies to:

Oracle iSupplier Portal - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.6 version, Other Issues

When attempting to sort work confirmation over status on work confirmation page,
the following error occurs.

ERROR

Exception Details.
 oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT DISTINCT
RHI.SHIPMENT_NUM,
RHI.HEADER_INTERFACE_ID WC_HEADER_ID,
RHI.REQUEST_DATE,
RHI.PERFORMANCE_PERIOD_FROM,
RHI.PERFORMANCE_PERIOD_TO,
RHI.VENDOR_ID,
RHI.VENDOR_SITE_ID,
  NVL(POH.CLM_DOCUMENT_NUMBER,POH.SEGMENT1) SEGMENT1,
POH.PO_HEADER_ID,
POH.CURRENCY_CODE,
  'INTERFACE' WC_STAGE,
POV.VENDOR_NAME,
PVS.VENDOR_SITE_CODE,
   HRO.NAME ORGANIZATION_NAME,
RHI.CREATED_BY CREATOR_ID,
  NVL(PDSH.CLM_FLAG,'N') CLM_FLAG,
'' as DISPLAY_STATUS,
  RHI.EXPECTED_RECEIPT_DATE
FROM
RCV_HEADERS_INTERFACE RHI,
RCV_TRANSACTIONS_INTERFACE RTI,
PO_VENDORS POV,
PO_VENDOR_SITES_ALL PVS,
PO_HEADERS_ALL POH,
HR_ALL_ORGANIZATION_UNITS_TL HRO,

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

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:947)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1283)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1441)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3823)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1671)
at weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatement.java:135)
at oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:860)
at oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:669)
at oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java:3754)
at oracle.jbo.server.OAJboViewObjectImpl.executeQueryForCollection(Unknown Source)
at oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQueryForCollection(OAViewObjectImpl.java:4602)
at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:751)
at oracle.jbo.server.ViewRowSetImpl.executeQueryForMasters(ViewRowSetImpl.java:900)
at oracle.jbo.server.ViewRowSetImpl.executeQueryForMode(ViewRowSetImpl.java:814)


STEPS TO REPRODUCE
The issue can be reproduced at will with the following steps:
1. iSupplier Portal -> Orders - > Work Confirmations
2. Advanced Search -> Go
3. Click on Status tab to sort the statuses
4. The above exception appears

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
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.