Hi,
Please help.
We are getting following error when executing the BPEL process to this package and procedure.
Error:
Exception occurred when binding was invoked.
Exception occurred during invocation of JCA binding: "JCA Binding execute of Reference operation 'AddRequisitionEventDetail_DB' failed due to: Stored procedure invocation error.
Error while trying to prepare and execute the LPI_REQUISITIONEVENTDETAIL_WPR.LPI_EVENTLOG$ADDDETAILREQUISI API.
An error occurred while preparing and executing the LPI_REQUISITIONEVENTDETAIL_WPR.LPI_EVENTLOG$ADDDETAILREQUISI API. Cause: java.sql.SQLException: ORA-06531: Reference to uninitialized collection
ORA-06512: at "ENTSOAAPPS_LPI_CERT.LPI_REQUISITIONEVENTDETAIL_WPR", line 28
ORA-06512: at "ENTSOAAPPS_LPI_CERT.LPI_REQUISITIONEVENTDETAIL_WPR", line 123
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 not retriable, likely due to a modelling mistake. To classify it as retriable instead add property nonRetriableErrorCodes with value "-6531" 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.