Error INVPAGI2.assign_item_header_recs: ORA-08006: specified row no longer exists When Running Import Item Program (INCOIN) To Create Or Assign Items To Organizations
(Doc ID 2881696.1)
Last updated on SEPTEMBER 07, 2023
Applies to:
Oracle Item Master - Version 12.2 and laterOracle Product Hub - Version 12.2 and later
Information in this document applies to any platform.
Symptoms
When Importing Items from interface by running program Item Import, the following error occurs.
ERROR
TRANSACTION ID : xxx
ORGANIZATION ID : xxx
TABLE NAME : MTL_SYSTEM_ITEMS_INTERFACE
COLUMN NAME :
MESSAGE NAME : BOM_PARSE_ITEM_ERROR
ERROR MESSAGE : INVPAGI2.assign_item_header_recs:ORA-08006: specified row no longer exists
************************************
TRANSACTION ID : -1
ORGANIZATION ID : -1
TABLE NAME : MTL_SYSTEM_ITEMS_INTERFACE
COLUMN NAME :
MESSAGE NAME : INV_IOI_ERR_ASS_ITM_HD_RVS
ERROR MESSAGE : *** BAD RETURN CODE b ***
Data in the Mtl_System_Items_Interface table shows: Process Flag = 4, meaning 'Validation succeeded/import failed'
STEPS
1. Load data into MTL_SYSTEM_ITEMS_INTERFACE
2. Inventory > Items > Import > Import Items > Run the program
3. Check concurrent request log for errors > See > INVPAGI2.assign_item_header_recs:ORA-08006: specified row no longer exists
Cause
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
Symptoms |
Cause |
Solution |
References |