Cancel PO API Not Working From SOA Suite - BSO Web Service (Doc ID 2086617.1)

Last updated on MARCH 07, 2016

Applies to:

Oracle Purchasing - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

The issue of EBS Cancel PO API not working.
Call executed the API/Code successful in the database/SQL without any issues, which shows API is running successfully but has issues when run the same through SOA Suite.

 

 The SOA code is using the below API, ( For your reference ) :

 <property name="IRepInternalName"
 value="PLSQL:PO_DOCUMENT_CONTROL_PUB:CONTROL_DOCUMENT"/>
         <property name="SchemaName" value="APPS"/>
         <property name="PackageName" value="PO_DOCUMENT_CONTROL_PUB"/>
         <property name="ProcedureName" value="CONTROL_DOCUMENT"/>

Error returned

<Invoke_CANCELPO_ApsAdp_ESGAP_ApsAdp_ESGAPCancelPO_InputVariable>


<P_API_VERSION>1.0
<P_INIT_MSG_LIST>T
<P_DOC_TYPE>PO
<P_DOC_SUBTYPE>STANDARD
<P_DOC_ID>174060
<P_DOC_NUM>900000259
<P_ACTION>CANCEL
<P_ACTION_DATE>2015-05-15T09:29:08.712-04:00
<P_CANCEL_REQS_FLAG>Y
<P_PRINT_FLAG>N
<P_ORG_ID>206



<Invoke_CANCELPO_ApsAdp_ESGAP_ApsAdp_ESGAPCancelPO_OutputVariable>


<X_RETURN_STATUS>U



Output :
====================
<Invoke_checkError_ApsTest_InputVariable>


<P_MSG_INDEX>1
<P_ENCODED>F



<Invoke_checkError_ApsTest_OutputVariable>


<P_DATA>ORA-02089: COMMIT is not allowed in a subordinate session in Package po.plsql.PO_DOCUMENT_CONTROL_PVT. Procedure doc_communicate_oncancel:000:-2089:ORA-02089: COMMIT is not allowed in a subordinate session
<P_MSG_INDEX_OUT>1



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms