oracle.soa.tracking.FlowId: 30025] [oracle.soa.tracking.InstanceId: 30066] [oracle.soa.tracking.SCAEntityId: 40008] [composite_name: GTCDEV01_PLSQL_FND_USER_PKG!1.0] [FlowId: 0000LLo^I^UF^6N5yJH7iW1NQ0OS00000X] oracle.apps.fnd.isg.monitor.callout.SOAMonitorPayload.getFunctionIdjava.sql.SQLException: Result set after last row[[

Oracle Community | 3184211 | 8 months ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    Integrated SOA Gateway - Error on SOAP web service call

    Oracle Community | 8 months ago | 3184211
    oracle.soa.tracking.FlowId: 30025] [oracle.soa.tracking.InstanceId: 30066] [oracle.soa.tracking.SCAEntityId: 40008] [composite_name: GTCDEV01_PLSQL_FND_USER_PKG!1.0] [FlowId: 0000LLo^I^UF^6N5yJH7iW1NQ0OS00000X] oracle.apps.fnd.isg.monitor.callout.SOAMonitorPayload.getFunctionIdjava.sql.SQLException: Result set after last row[[

    Root Cause Analysis

    1. oracle.soa.tracking.FlowId

      30025] [oracle.soa.tracking.InstanceId: 30066] [oracle.soa.tracking.SCAEntityId: 40008] [composite_name: GTCDEV01_PLSQL_FND_USER_PKG!1.0] [FlowId: 0000LLo^I^UF^6N5yJH7iW1NQ0OS00000X] oracle.apps.fnd.isg.monitor.callout.SOAMonitorPayload.getFunctionIdjava.sql.SQLException: Result set after last row[[

      at oracle.jdbc.driver.GeneratedScrollableResultSet.getInt()
    2. Oracle jdbc
      GeneratedScrollableResultSet.getInt
      1. oracle.jdbc.driver.GeneratedScrollableResultSet.getInt(GeneratedScrollableResultSet.java:1424)
      1 frame
    3. weblogic.jdbc.wrapper
      ResultSet_oracle_jdbc_driver_ForwardOnlyResultSet.getInt
      1. weblogic.jdbc.wrapper.ResultSet_oracle_jdbc_driver_ForwardOnlyResultSet.getInt(Unknown Source)
      1 frame
    4. oracle.apps.fnd
      SOAMonitorPayload.auditRequest
      1. oracle.apps.fnd.isg.monitor.IrepAccess.getFunctionId(IrepAccess.java:192)
      2. oracle.apps.fnd.isg.monitor.SOAPUtil.getIRepInfo(SOAPUtil.java:662)
      3. oracle.apps.fnd.isg.monitor.callout.SOAMonitorPayload.auditRequest(SOAMonitorPayload.java:376)
      3 frames