Getting Error INV_IOI_REV_BAD_ORDER During Item Sync.

(Doc ID 1339792.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Product Master Data Management Integration Base Pack - Version 2.5 and later
Information in this document applies to any platform.

Symptoms

When attempting to sync an item where the default revision in PIM is different to Ebiz which is erroring out. EBI debug shows:

...
27/FEB/2011 19:24:49: STEP: 20 START CALLING EGO_ITEM_PUB.process_item
************************************
TRANSACTION ID : 1544007
ORGANIZATION ID : 123
TABLE NAME : MTL_ITEM_REVISIONS_INTERFACE
COLUMN NAME : EFF1
MESSAGE NAME : INV_IOI_REV_BAD_ORDER
ERROR MESSAGE : The order of Revisions for an Item must occur in both
chronological (EFFECTIVITY_DATE) and alphabetical (REVISION) order.
************************************
TRANSACTION ID : 1544006
ORGANIZATION ID : 123
TABLE NAME : MTL_SYSTEM_ITEMS_INTERFACE
COLUMN NAME : INVENTORY_ITEM_ID
MESSAGE NAME : INV_IOI_ERR
ERROR MESSAGE :
27/FEB/2011 19:25:16: STEP: 30 END CALLING EGO_ITEM_PUB.process_item

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