My Oracle Support Banner

Rollback Doesn't Work Correctly When Running EGO_ITEM_PUB.Process_Item_Revision Although Set p_commit=FALSE (Doc ID 2546972.1)

Last updated on MAY 12, 2020

Applies to:

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


Actual Behavior
Rollback doesn't work correctly when running EGO_ITEM_PUB.Process_Item_Revision although we set p_commit=FALSE.
This issue occur when checkbox type attribute is used, and default value is set for this attribute.

Expected Behavior
EGO_ITEM_PUB.Process_Item_Revision is rollback when error occur.

Steps to Reproduce

  1. Create new item by EGO_ITEM_PUB.Process_Item. Do not commit.
  2. Create new revision for same item by EGO_ITEM_PUB.Process_Item_Revision.
    Set p_effectivity_date as 'sysdate - 10' to raise error.
  3. The following error occur. (expected behavior.)
  4. When we check MTL_SYSTEM_ITEMS_B, new item is created although we don't commit after running these APIs.
    When there is no checkbox type attribute, this issue doesn't occur.




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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.