Integration

Exception occured when binding was invoked. Exception occured during invocation of JCA binding: "JCA Binding execute of Reference operation 'Get_InData' failed due to: Stored procedure invocation error. Error while trying to prepare and execute the AST_OCS.AS_IPMBAR_INV.AS_AP_BARINV_GETDATA API. An error occurred while preparing and executing the AST_OCS.AS_IPMBAR_INV.AS_AP_BARINV_GETDATA API. Cause: java.sql.SQLException: ORA-06511: PL/SQL: cursor already open ORA-06512: at "AST_OCS.AS_IPMBAR_INV", line 26 ORA-06512: at "AST_OCS.AS_IPMBAR_INV", line 97 ORA-02049: timeout: distributed transaction waiting for lock ORA-02063: preceding line from EBSLIVE ORA-06512: at line 1 Check to ensure that the API is defined in the database and that the parameters match the signature of the API. This exception is considered retriable, likely due to a communication failure. To classify it as non-retriable instead add property nonRetriableErrorCodes with value "6511" 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.

Please give me the solution ....

Thanks,

Nir