Error while working with OracleApps Adapter please help mee
665465Jan 31 2009 — edited Feb 3 2009<bindingFault xmlns="http://schemas.oracle.com/bpel/extension"><part name="code"><code>1086</code>
</part><part name="summary"><summary>file:/F:/product/10.1.3.1/OracleAS_2/bpel/domains/test/tmp/.bpel_RepairOrder_1.0_4bac0e828ef344d37656722b167615db.tmp/CreateRepairOrder.wsdl [ CreateRepairOrder_ptt::CreateRepairOrder(InputParameters,OutputParameters) ] - WSIF JCA Execute of operation 'CreateRepairOrder' failed due to: Error while trying to prepare and execute an API.
An error occurred while preparing and executing the APPS.XX_BPEL_CREATEREPAIRORDER.CSD_REPAIRS_PUB$CREATE_REPAIR API. Cause: java.sql.SQLException: ORA-01086: savepoint 'CREATE_REPAIR_ORDER_PUB' never established
ORA-06512: at "APPS.JTF_PLSQL_API", line 65
ORA-06512: at "APPS.CSD_REPAIRS_PUB", line 144
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "APPS.XX_BPEL_CREATEREPAIRORDER", line 160
ORA-06512: at line 1
[Caused by: ORA-01086: savepoint 'CREATE_REPAIR_ORDER_PUB' never established
ORA-06512: at "APPS.JTF_PLSQL_API", line 65
ORA-06512: at "APPS.CSD_REPAIRS_PUB", line 144
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "APPS.XX_BPEL_CREATEREPAIRORDER", line 160
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_CREATEREPAIRORDER.CSD_REPAIRS_PUB$CREATE_REPAIR API. Cause: java.sql.SQLException: ORA-01086: savepoint 'CREATE_REPAIR_ORDER_PUB' never established
ORA-06512: at "APPS.JTF_PLSQL_API", line 65
ORA-06512: at "APPS.CSD_REPAIRS_PUB", line 144
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "APPS.XX_BPEL_CREATEREPAIRORDER", line 160
ORA-06512: at line 1
[Caused by: ORA-01086: savepoint 'CREATE_REPAIR_ORDER_PUB' never established
ORA-06512: at "APPS.JTF_PLSQL_API", line 65
ORA-06512: at "APPS.CSD_REPAIRS_PUB", line 144
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "APPS.XX_BPEL_CREATEREPAIRORDER", line 160
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.
</summary>
</part><part name="detail"><detail>
Internal Exception: java.sql.SQLException: ORA-01086: savepoint 'CREATE_REPAIR_ORDER_PUB' never established
ORA-06512: at "APPS.JTF_PLSQL_API", line 65
ORA-06512: at "APPS.CSD_REPAIRS_PUB", line 144
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "APPS.XX_BPEL_CREATEREPAIRORDER", line 160
ORA-06512: at line 1
Error Code: 1086</detail>
</part></bindingFault>