cannot invoke oracle appliations in BPEL
684914Sep 24 2009 — edited Oct 1 2009Hi all,
I created BPEL asyn process to create single invoice using AR_INVOICE_API_PUB API. I created the BPEL project and deployed to BPEL successfully, but when i am testing the BPEL process it's giving the following error.
In the BPEL process i used oracle applications service.
Faulted while invoking operation "CreateInvoice" on provider "CreateInvoice". More...
[2009/09/24 14:28:21] [FAULT RECOVERY] Invoked handleBPELFault on custom java action class "oracle.apps.aia.core.eh.BPELJavaAction".
[2009/09/24 14:28:21] [FAULT RECOVERY] Rethrow fault {http://schemas.oracle.com/bpel/extension}bindingFault. More...
[2009/09/24 14:28:21] "{http://schemas.oracle.com/bpel/extension}bindingFault" has been thrown. More...
</sequence>
<scope>
</sequence>
[2009/09/24 14:28:21] "BPELFault" has not been caught by a catch block.
[2009/09/24 14:28:21] There is a system exception while performing the BPEL instance, the reason is "faultName: {{http://schemas.oracle.com/bpel/extension}bindingFault} messageType: {{http://schemas.oracle.com/bpel/extension}RuntimeFaultMessage} parts: {{code=6510 ,summary=file:/D:/SOA10.1.3.5/10.1.3.1/OracleAS_1/bpel/domains/default/tmp/.bpel_AIABPELProcess123_1.0_50bed59e40f2a49ccbcf4888d70cbc6d.tmp/CreateInvoice.wsdl [ CreateInvoice_ptt::CreateInvoice(InputParameters,OutputParameters) ] - WSIF JCA Execute of operation 'CreateInvoice' failed due to: Error while trying to prepare and execute an API. An error occurred while preparing and executing the APPS.XX_BPEL_CREATEINVOICE.AR_INVOICE_API_PUB$CREATE_SIN API. Cause: java.sql.SQLException: ORA-06510: PL/SQL: unhandled user-defined exception ORA-06512: at "APPS.OE_SYS_PARAMETERS", line 68 ORA-06510: PL/SQL: unhandled user-defined exception ORA-06512: at "APPS.OE_SYS_PARAMETERS_PVT", line 390 ORA-06510: PL/SQL: unhandled user-defined exception ORA-06512: at "APPS.OE_PROFILE", line 115 ORA-06512: at "APPS.AR_INVOICE_UTILS", line 9 ORA-06512: at "APPS.AR_INVOICE_API_PUB", line 976 ORA-06512: at "APPS.XX_BPEL_CREATEINVOICE", line 1 ORA-06512: at line 1 [Caused by: ORA-06510: PL/SQL: unhandled user-defined exception ORA-06512: at "APPS.OE_SYS_PARAMETERS", line 68 ORA-06510: PL/SQL: unhandled user-defined exception ORA-06512: at "APPS.OE_SYS_PARAMETERS_PVT", line 390 ORA-06510: PL/SQL: unhandled user-defined exception ORA-06512: at "APPS.OE_PROFILE", line 115 ORA-06512: at "APPS.AR_INVOICE_UTILS", line 9 ORA-06512: at "APPS.AR_INVOICE_API_PUB", line 976 ORA-06512: at "APPS.XX_BPEL_CREATEINVOICE", line 1 ORA-06512: at line 1 ] ; nested exception is: ORABPEL-11811 Error while trying to prepare and execute an API. An error occurred while preparing and executing the APPS.XX_BPEL_CREATEINVOICE.AR_INVOICE_API_PUB$CREATE_SIN API. Cause: java.sql.SQLException: ORA-06510: PL/SQL: unhandled user-defined exception ORA-06512: at "APPS.OE_SYS_PARAMETERS", line 68 ORA-06510: PL/SQL: unhandled user-defined exception ORA-06512: at "APPS.OE_SYS_PARAMETERS_PVT", line 390 ORA-06510: PL/SQL: unhandled user-defined exception ORA-06512: at "APPS.OE_PROFILE", line 115 ORA-06512: at "APPS.AR_INVOICE_UTILS", line 9 ORA-06512: at "APPS.AR_INVOICE_API_PUB", line 976 ORA-06512: at "APPS.XX_BPEL_CREATEINVOICE", line 1 ORA-06512: at line 1 [Caused by: ORA-06510: PL/SQL: unhandled user-defined exception ORA-06512: at "APPS.OE_SYS_PARAMETERS", line 68 ORA-06510: PL/SQL: unhandled user-defined exception ORA-06512: at "APPS.OE_SYS_PARAMETERS_PVT", line 390 ORA-06510: PL/SQL: unhandled user-defined exception ORA-06512: at "APPS.OE_PROFILE", line 115 ORA-06512: at "APPS.AR_INVOICE_UTILS", line 9 ORA-06512: at "APPS.AR_INVOICE_API_PUB", line 976 ORA-06512: at "APPS.XX_BPEL_CREATEINVOICE", line 1 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. Contact oracle support if error is not fixable. ,detail= Internal Exception: java.sql.SQLException: ORA-06510: PL/SQL: unhandled user-defined exception ORA-06512: at "APPS.OE_SYS_PARAMETERS", line 68 ORA-06510: PL/SQL: unhandled user-defined exception ORA-06512: at "APPS.OE_SYS_PARAMETERS_PVT", line 390 ORA-06510: PL/SQL: unhandled user-defined exception ORA-06512: at "APPS.OE_PROFILE", line 115 ORA-06512: at "APPS.AR_INVOICE_UTILS", line 9 ORA-06512: at "APPS.AR_INVOICE_API_PUB", line 976 ORA-06512: at "APPS.XX_BPEL_CREATEINVOICE", line 1 ORA-06512: at line 1 Error Code: 6510 }} ". Please check the error log file for more infromation. Please try to use bpel fault handlers to catch the faults in your bpel process. If this is a system exception, please report this to your system administrator. Administrator could perform manual recovery of the instance from last non-idempotent activity or dehydration point. More...
[2009/09/24 14:28:21] BPEL process instance #"20006" cancelled
And is there any other way to create single invoice .
pls help me
thanks in advance
mani