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.


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"
         <property name="SchemaName" value="APPS"/>
         <property name="PackageName" value="PO_DOCUMENT_CONTROL_PUB"/>
         <property name="ProcedureName" value="CONTROL_DOCUMENT"/>

Error returned





Output :



<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


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