java.sql.SQLSyntaxErrorException: ORA-00907: missing right parenthesis (Doc ID 2160710.1)

Last updated on APRIL 20, 2023

Applies to:

Symptoms

On : 12.1.3 version, Other issues

When attempting to drill down PO 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
  POL.PO_HEADER_ID,POL.PO_LINE_ID,POL.LINE_NUM,
  MSI.CONCATENATED_SEGMENTS ITEM_NUM,
  POL.VENDOR_PRODUCT_NUM,POL.ITEM_DESCRIPTION,
  MUM.UNIT_OF_MEASURE_TL UNIT_MEAS_LOOKUP_CODE,
  POL.QUANTITY,
  nvl(POL.UNIT_PRICE,POL.AMOUNT) UNIT_PRICE,
DECODE(POL.matching_basis,'AMOUNT',POL.AMOUNT,POL.QUANTITY*POL.UNIT_PRICE) TOTAL,
  POH.SEGMENT1 PO_NUM,POH.CURRENCY_CODE,
  POL.ITEM_ID,FSP.INVENTORY_ORGANIZATION_ID,
  MSI.CONCATENATED_SEGMENTS SEGMENT1,
  POL.FROM_HEADER_ID,POLA.CLOSED_CODE,POLA.CANCEL_FLAG,
  POLA.CLOSED_FLAG,POLA.USER_HOLD_FLAG,
  POL.ATTRIBUTE1, POL.ATTRIBUTE2, POL.ATTRIBUTE3,
  POL.ATTRIBUTE4,POL.ATTRIBUTE5, POL.ATTRIBUTE6,
  POL.ATTRIBUTE7, POL.ATTRIBUTE8,POL.ATTRIBUTE9,
  POL.ATTRIBUTE10, POL.ATTRIBUTE11, POL.ATTRIBUTE12,
  POL.ATTRIBUTE13, POL.ATTRIBUTE14, POL.ATTRIBUTE15,
  POL.ATTRIBUTE_CATEGORY,POL.NOTE_TO_VENDOR,
  POH2.SEGMENT1 CONTRACT_NUM,POL.ITEM_REVISION,
  POL.USSGL_TRANSACTION_CODE,
  null UN_NUMBER,null HAZARD_CLASS,pol.QUANTITY_COMMITTED,
  pol.COMMITTED_AMOUNT,POL.EXPIRATION_DATE,
decode(POL.matching_basis,'AMOUNT',nvl(POCR.NEW_AMOUNT,POL.AMOUNT),nvl(POCR.NEW_PRICE,POL.UNIT_PRICE)) NEW_PRICE,
nvl(POCR.NEW_SUPPLIER_PART_NUMBER,POL.VENDOR_PRODUCT_NUM) NEW_SUPPLIER_PART_NUMBER,
  POCR.REQUEST_STATUS,
  0 ViewShipments,'SItemType' SItemType,'PriceType' PriceType,'LineStatus' LineStatus,
  NVL(POS_GET.GET_ITEM_CONFIG(POL.ITEM_ID, FSP.INVENTORY_ORGANIZATION_ID),'F') CONF_FLAG,
  null GA_NUMBER,POCR.REQUEST_REASON,
Decode (POCR.REQUEST_STATUS,NULL,POS_GET.pos_getstatus(POLA.CLOSED_CODE),FND_MESSAGE_CACHE.get_string('POS','POS_PENDING_CHANGE'))
 LINE_DISPLAY,
  POL.HAZARD_CLASS_ID,POL.UN_NUMBER_ID,
  null CONF_DETAILS,'REASON_TYPE' REASON_TYPE,POL.JOB_ID,
  POL.CONTRACTOR_FIRST_NAME ,POL.CONTRACTOR_LAST_NAME,
  'LINE_PRICE_DIFF_TYPE' LINE_PRICE_DIFF_TYPE,
  POLT.ORDER_TYPE_LOOKUP_CODE LINE_TYPE,
  PJ.NAME JOB_TITLE,POH.GLOBAL_AGREEMENT_FLAG,
  POH.TYPE_LOOKUP_CODE,'ENTITY_TYPE' ENTITY_TYPE,
  POLT.LINE_TYPE LINE_TYPE_DSP,
  PA.JOB_DESCRIPTION,null CONTRACTOR_NAME,
  POL.AMOUNT LINE_AMOUNT,POL.SUPPLIER_REF_NUMBER,
  POH.APPROVED_DATE,
  POH.AGENT_ID,
  POS_GET.GET_PERSON_NAME_CACHE(POH.AGENT_ID) AGENT_NAME,
  POH.VENDOR_ID,
  POH.VENDOR_SITE_ID,
  'N' as ROW_SELECTED,
  POH.revision_num as poh_revision_num,
  poh.cancel_flag poh_cancel_flag,
  poh.frozen_flag poh_frozen_flag,
  poh.user_hold_flag poh_user_hold_flag,
  poh.closed_code poh_closed_code,
  poh.authorization_status poh_authorization_status,
  POL.RETAINAGE_RATE,
  POL.MAX_RETAINAGE_AMOUNT,
  POL.PROGRESS_PAYMENT_RATE,
  POL.RECOUPMENT_RATE,
  POL.START_DATE,
  nvl(pdsh.progress_payment_flag,'N') as complex_work_flag,
  poh.acceptance_required_flag,
  POCR.INITIATOR,
 -9999 PO_RELEASE_ID,
  'OTHER_TYPES' shipment_type
FROM
  PO_LINES_ARCHIVE_ALL POL,
  PO_LINES_ALL POLA,
  PO_HEADERS_ALL POH,
  MTL_SYSTEM_ITEMS_KFV MSI,
  FINANCIALS_SYSTEM_PARAMS_ALL FSP,
  PO_CHANGE_REQUESTS POCR,
  PO_LINE_TYPES POLT, PER_JOBS PJ,
  PO_JOB_ASSOCIATIONS PA,
  PO_HEADERS_ALL POH2,
  po_doc_style_headers pdsh,
  MTL_UNITS_OF_MEASURE_TL MUM
WHERE
  POH.PO_HEADER_ID = POL.PO_HEADER_ID AND
  POL.CONTRACT_ID = POH2.PO_HEADER_ID(+) AND
  POL.LATEST_EXTERNAL_FLAG='Y' AND
  POL.PO_LINE_ID = POLA.PO_LINE_ID AND
  POLA.LINE_TYPE_ID = POLT.LINE_TYPE_ID AND
  POL.JOB_ID = PJ.JOB_ID (+) AND
  POL.JOB_ID = PA.JOB_ID (+) AND
  POL.ITEM_ID = MSI.INVENTORY_ITEM_ID (+) AND
  FSP.INVENTORY_ORGANIZATION_ID = NVL(MSI.ORGANIZATION_ID, FSP.INVENTORY_ORGANIZATION_ID) AND
  FSP.ORG_ID (+)=POH.ORG_ID AND
  POL.PO_HEADER_ID = POCR.DOCUMENT_HEADER_ID (+)AND
  POL.PO_LINE_ID = POCR.DOCUMENT_LINE_ID (+) AND
  POCR.REQUEST_LEVEL (+)= 'LINE' AND
  POCR.CHANGE_ACTIVE_FLAG (+)= 'Y' and
  poh.style_id = pdsh.style_id (+) AND
  MUM.UNIT_OF_MEASURE(+) = POL.UNIT_MEAS_LOOKUP_CODE AND
  MUM.language (+) = Userenv('LANG')
 UNION ALL
 SELECT
  POL.PO_HEADER_ID,POL.PO_LINE_ID,POL.LINE_NUM,
  MSI.CONCATENATED_SEGMENTS ITEM_NUM,
  POL.VENDOR_PRODUCT_NUM,POL.ITEM_DESCRIPTION,
  MUM.UNIT_OF_MEASURE_TL UNIT_MEAS_LOOKUP_CODE,
  POL.QUANTITY,
  nvl(POL.UNIT_PRICE,POL.AMOUNT) UNIT_PRICE,
DECODE(POL.matching_basis,'AMOUNT',POL.AMOUNT,POL.QUANTITY*POL.UNIT_PRICE) TOTAL,
  POH.SEGMENT1 PO_NUM,POH.CURRENCY_CODE,
  POL.ITEM_ID,FSP.INVENTORY_ORGANIZATION_ID,
  MSI.CONCATENATED_SEGMENTS SEGMENT1,
  POL.FROM_HEADER_ID,POLA.CLOSED_CODE,POLA.CANCEL_FLAG,
  POLA.CLOSED_FLAG,POLA.USER_HOLD_FLAG,
  POL.ATTRIBUTE1, POL.ATTRIBUTE2, POL.ATTRIBUTE3,
  POL.ATTRIBUTE4,POL.ATTRIBUTE5, POL.ATTRIBUTE6,
  POL.ATTRIBUTE7, POL.ATTRIBUTE8,POL.ATTRIBUTE9,
  POL.ATTRIBUTE10, POL.ATTRIBUTE11, POL.ATTRIBUTE12,
  POL.ATTRIBUTE13, POL.ATTRIBUTE14, POL.ATTRIBUTE15,
  POL.ATTRIBUTE_CATEGORY,POL.NOTE_TO_VENDOR,
  POH2.SEGMENT1 CONTRACT_NUM,POL.ITEM_REVISION,
  POL.USSGL_TRANSACTION_CODE,
  null UN_NUMBER,null HAZARD_CLASS,pol.QUANTITY_COMMITTED,
  pol.COMMITTED_AMOUNT,POL.EXPIRATION_DATE,
decode(POL.matching_basis,'AMOUNT',nvl(POCR.NEW_AMOUNT,POL.AMOUNT),nvl(POCR.NEW_PRICE,POL.UNIT_PRICE)) NEW_PRICE,
nvl(POCR.NEW_SUPPLIER_PART_NUMBER,POL.VENDOR_PRODUCT_NUM) NEW_SUPPLIER_PART_NUMBER,
  POCR.REQUEST_STATUS,
  0 ViewShipments,'SItemType' SItemType,'PriceType' PriceType,'LineStatus' LineStatus,
  NVL(POS_GET.GET_ITEM_CONFIG(POL.ITEM_ID, FSP.INVENTORY_ORGANIZATION_ID),'F') CONF_FLAG,
  null GA_NUMBER,POCR.REQUEST_REASON,
Decode (POCR.REQUEST_STATUS,NULL,POS_GET.pos_getstatus(POLA.CLOSED_CODE),FND_MESSAGE_CACHE.get_string('POS','POS_PENDING_CHANGE')) LINE_DISPLAY,
  POL.HAZARD_CLASS_ID,POL.UN_NUMBER_ID,
  null CONF_DETAILS,'REASON_TYPE' REASON_TYPE,POL.JOB_ID,
  POL.CONTRACTOR_FIRST_NAME ,POL.CONTRACTOR_LAST_NAME,
  'LINE_PRICE_DIFF_TYPE' LINE_PRICE_DIFF_TYPE,
  POLT.ORDER_TYPE_LOOKUP_CODE LINE_TYPE,
  PJ.NAME JOB_TITLE,POH.GLOBAL_AGREEMENT_FLAG,
  POH.TYPE_LOOKUP_CODE,'ENTITY_TYPE' ENTITY_TYPE,
  POLT.LINE_TYPE LINE_TYPE_DSP,
  PA.JOB_DESCRIPTION,null CONTRACTOR_NAME,
  POL.AMOUNT LINE_AMOUNT,POL.SUPPLIER_REF_NUMBER,
  POH.APPROVED_DATE,
  POH.AGENT_ID,
  POS_GET.GET_PERSON_NAME_CACHE(POH.AGENT_ID) AGENT_NAME,
  POH.VENDOR_ID,
  POH.VENDOR_SITE_ID,
  'N' as ROW_SELECTED,
  POH.revision_num as poh_revision_num,
  poh.cancel_flag poh_cancel_flag,
  poh.frozen_flag poh_frozen_flag,
  poh.user_hold_flag poh_user_hold_flag,
  poh.closed_code poh_closed_code,
  poh.authorization_status poh_authorization_status,
  POL.RETAINAGE_RATE,
  POL.MAX_RETAINAGE_AMOUNT,
  POL.PROGRESS_PAYMENT_RATE,
  POL.RECOUPMENT_RATE,
  POL.START_DATE,
  nvl(pdsh.progress_payment_flag,'N') as complex_work_flag,
  poh.acceptance_required_flag,
  POCR.INITIATOR,
  poll.PO_RELEASE_ID PO_RELEASE_ID,
  poll.shipment_type shipment_type
FROM
  PO_LINES_ARCHIVE_ALL POL,
  PO_LINES_ALL POLA,
  PO_HEADERS_ALL POH,
  MTL_SYSTEM_ITEMS_KFV MSI,
  FINANCIALS_SYSTEM_PARAMS_ALL FSP,
  PO_CHANGE_REQUESTS POCR,
  PO_LINE_TYPES POLT, PER_JOBS PJ,
  PO_JOB_ASSOCIATIONS PA,
  PO_HEADERS_ALL POH2,
  po_doc_style_headers pdsh,
  MTL_UNITS_OF_MEASURE_TL MUM,
  (SELECT distinct po_header_id,po_line_id ,po_release_id,SHIPMENT_TYPE FROM po_line_locations_archive_all WHERE PO_RELEASE_ID IS NOT NULL AND SHIPMENT_TYPE IN ('BLANKET','SCHEDULED')) poll
WHERE
  POH.PO_HEADER_ID = POL.PO_HEADER_ID AND
  POL.CONTRACT_ID = POH2.PO_HEADER_ID(+) AND
  POL.LATEST_EXTERNAL_FLAG='Y' AND
  POL.PO_LINE_ID = POLA.PO_LINE_ID AND
  POLA.LINE_TYPE_ID = POLT.LINE_TYPE_ID AND
  POL.JOB_ID = PJ.JOB_ID (+) AND
  POL.JOB_ID = PA.JOB_ID (+) AND
  POL.ITEM_ID = MSI.INVENTORY_ITEM_ID (+) AND
  FSP.INVENTORY_ORGANIZATION_ID = NVL(MSI.ORGANIZATION_ID, FSP.INVENTORY_ORGANIZATION_ID) AND
  FSP.ORG_ID (+)=POH.ORG_ID AND
  POL.PO_HEADER_ID = POCR.DOCUMENT_HEADER_ID (+)AND
  POL.PO_LINE_ID = POCR.DOCUMENT_LINE_ID (+) AND
  POCR.REQUEST_LEVEL (+)= 'LINE' AND
  POCR.CHANGE_ACTIVE_FLAG (+)= 'Y' and
  poh.style_id = pdsh.style_id (+) AND
  MUM.UNIT_OF_MEASURE(+) = POL.UNIT_MEAS_LOOKUP_CODE AND
  MUM.language (+) = Userenv('LANG')
  AND pol.po_line_id = poll.po_line_id
  AND POL.po_header_id = poll.po_header_id) QRSLT WHERE (PO_LINE_ID in (select pod.po_line_id from PO_DISTRIBUTIONS_ALL pod , po_req_distributions_all pord , po_requisition_lines_all por where pord.DISTRIBUTION_ID = pod.req_DISTRIBUTION_ID and pord.requisition_line_id = por.requisition_line_id and por.requisition_header_id= :1 ) AND PO_LINE_ID in (select PO_LINE_ID from po_line_locations_all where PO_HEADER_ID = :2 and PO_RELEASE_ID = :3) AND po_release_id = :4 AND shipment_type in ('BLANKET,'SCHEDULED')) ORDER BY LINE_NUM

java.sql.SQLSyntaxErrorException: ORA-00907: missing right parenthesis

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:205)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:861)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1145)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1267)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3493)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)
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:4568)
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)
at oracle.jbo.server.ViewRowSetImpl.executeQuery(ViewRowSetImpl.java:808)
at oracle.jbo.server.ViewObjectImpl.executeQuery(ViewObjectImpl.java:3674)
at oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQuery(OAViewObjectImpl.java:441)
at oracle.apps.fnd.framework.server.OAPlsqlViewObjectImpl.executeQuery(OAPlsqlViewObjectImpl.java:524)
at oracle.apps.fnd.framework.webui.OAWebBeanBaseTableHelper.queryData(OAWebBeanBaseTableHelper.java:1151)
at oracle.apps.fnd.framework.webui.beans.table.OAAdvancedTableBean.queryData(OAAdvancedTableBean.java:445)
at oracle.apps.pos.changeorder.webui.PosViewPOCO.processRequest(PosViewPOCO.java:324)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:604)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
at oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(OAStackLayoutBean.java:350)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:976)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:943)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:663)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
at oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(OAStackLayoutBean.java:350)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:976)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:943)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:663)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1183)
at oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(OAPageLayoutBean.java:1569)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:976)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:943)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:663)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
at oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(OAFormBean.java:385)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:976)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:943)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:663)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
at oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(OABodyBean.java:353)
at oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2678)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1960)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:557)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:439)
at _OA._jspService(_OA.java:213)
at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:390)
at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)
at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:734)
at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:391)
at com.evermind.server.http.ServletRequestDispatcher.unprivileged_forward(ServletRequestDispatcher.java:308)
at com.evermind.server.http.ServletRequestDispatcher.access$100(ServletRequestDispatcher.java:68)
at com.evermind.server.http.ServletRequestDispatcher$2.oc4jRun(ServletRequestDispatcher.java:214)
at oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:284)
at com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:219)
at com.evermind.server.http.EvermindPageContext.forward(EvermindPageContext.java:407)
at _OA._jspService(_OA.java:222)
at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:390)
at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)
at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26)
at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)
at oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:429)
at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:642)
at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:391)
at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:911)
at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:458)
at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:313)
at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:199)
at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
at java.lang.Thread.run(Thread.java:662)

 



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Go to iProcurement
2. Go to Requisition Details  
3. Go to PO link

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.