AIA - Agile to Ebiz PIP Fails With ORA-02089 (Doc ID 2167914.1)

Last updated on AUGUST 09, 2016

Applies to:

Agile Product Lifecycle Management Integration Pack for Oracle E-Business Suite - Version 3.4 to 3.5 [Release 3.4 to 3.5]
Information in this document applies to any platform.

Symptoms

Agile to Ebiz PIP 3.4

ECO Creation from Agile to Ebusiness Suite fails with the error in the service CreateEngineeringChangeOrderListEbizProvABCSImplProcess

ERROR
=========
ORA-02089: COMMIT is not allowed in a subordinate session

Steps to Reproduce:
===============
1. Create an ECO in Agile
2. Sync to Ebusiness Suite

Business Impact
==============
Unable to create ECO because of this error.

Changes

 

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