Error
<bpelFault><faultType>0</faultType><bindingFault xmlns="http://schemas.oracle.com/bpel/extension"><part name="summary"><summary>Exception occured when binding was invoked. Exception occured during invocation of JCA binding: "JCA Binding execute of Reference operation 'fds' failed due to: Interaction processing error. Error while processing the execution of the xxxxxxinteraction. An error occurred while processing the interaction for invoking the APPS.LINT_LF_PROCESS_NOTIFICATION.GET_NOTIF_DET API. Cause: java.sql.SQLException: ORA-01403: no data found ORA-06512: at line 1 Check to ensure that the XML containing parameter data matches the parameter definitions in the XSD. This exception is considered not retriable, likely due to a modelling mistake. To classify it as retriable instead add property nonRetriableErrorCodes with value "-1403" to your deployment descriptor (i.e. weblogic-ra.xml). To auto retry a retriable fault set these composite.xml properties for this invoke: jca.retry.interval, jca.retry.count, and jca.retry.backoff. All properties are integers. ". The invoked JCA adapter raised a resource exception. Please examine the above error message carefully to determine a resolution. </summary></part><part name="detail"><detail>ORA-01403: no data found ORA-06512: at line 1 </detail></part><part name="code"><code>1403</code></part></bindingFault></bpelFault>
Solution:
1)From the Database side, to the particular API check the traffic.
If there are many subscribers you need to kill them.
Give a clean restart and you should be able to extract the records.
<bpelFault><faultType>0</faultType><bindingFault xmlns="http://schemas.oracle.com/bpel/extension"><part name="summary"><summary>Exception occured when binding was invoked. Exception occured during invocation of JCA binding: "JCA Binding execute of Reference operation 'fds' failed due to: Interaction processing error. Error while processing the execution of the xxxxxxinteraction. An error occurred while processing the interaction for invoking the APPS.LINT_LF_PROCESS_NOTIFICATION.GET_NOTIF_DET API. Cause: java.sql.SQLException: ORA-01403: no data found ORA-06512: at line 1 Check to ensure that the XML containing parameter data matches the parameter definitions in the XSD. This exception is considered not retriable, likely due to a modelling mistake. To classify it as retriable instead add property nonRetriableErrorCodes with value "-1403" to your deployment descriptor (i.e. weblogic-ra.xml). To auto retry a retriable fault set these composite.xml properties for this invoke: jca.retry.interval, jca.retry.count, and jca.retry.backoff. All properties are integers. ". The invoked JCA adapter raised a resource exception. Please examine the above error message carefully to determine a resolution. </summary></part><part name="detail"><detail>ORA-01403: no data found ORA-06512: at line 1 </detail></part><part name="code"><code>1403</code></part></bindingFault></bpelFault>
1)From the Database side, to the particular API check the traffic.
If there are many subscribers you need to kill them.
Give a clean restart and you should be able to extract the records.