ORA-29877 / DRG-50857 / JBO-26041 - PIM / EGO Error Creating Items, Searching For Items, Creating Manufacturer Part Numbers (Doc ID 1472527.1)

Last updated on MAY 24, 2016

Applies to:

Oracle Product Hub - Version 12.0.2 and later
Information in this document applies to any platform.
ODCIINDEXUPDATE
APPS.EGO_MTL_MFG_PART_NUMBERS_TR1: Trigger on MTL_MFG_PART_NUMBERS
EGO_ITEM_AML_PVT.populateProductionTable

Symptoms

Receive multiple errors working with items in Product Information Management (PIM) like searching for an item, creating a manufacturing part number, importing an item from Excel.

Searching for an item sometimes gives an error, but the same search a few minutes later works and shows the item.
Errors also occur when creating items.

 

ERROR : Searching for an Item


STEPS : Searching for an Item
* Cannot replicate at will but has happened a few times.

1. Navigate to Dev Manager > Simple search
2. enter item simple search > search for a item
3. click tab association
4. click manufacturer part number
5. enter manufacturer and party number
6. click to apply/update

Changes

Upgraded to database (RDBMS) version 10.2.0.5 or 11.2.0.1.0.

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