My Oracle Support Banner

Need To Rollback The Whole Change Order Creation Data If There Is A Single Failure in ENG_ECO_PUB.process_eco and ENG_CHANGE_ATTR_UTIL.INsert_Item_User_Attrs APIs (Doc ID 1905894.1)

Last updated on MARCH 08, 2017

Applies to:

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

Goal

Need to Rollback the whole Change order creation data if there is a single failure

We are creating Change Orders using APIs.

ENG_ECO_PUB.process_eco and ENG_CHANGE_ATTR_UTIL.INsert_Item_User_Attrs API for each UDA group to create ECO and add UDA changes.

We want to rollback the whole ECO if there is any failures. But, there is not p_commit parameter in these APIs. Is there a way to call the APIs without commit.
 

Solution

To view full details, sign in with your My Oracle Support account.

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


In this Document
Goal
Solution


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.