Unable To Remove Item Expenses Via File Upload (Doc ID 2949662.1)

Last updated on MAY 18, 2023

Applies to:

Symptoms

Unable to remove Item Expenses via File Upload

While attempting to remove inappropriately generated item expenses from conversion, below error is being rendered after loading an Item Master ODS file with a Delete Action on the item_expenses tab:

Worksheet Row Column Issue Type Issue Description
NONE - ERROR in PROCESS_IEXP 0. Error Error ORA-06502: PL/SQL: numeric or value error: character string buffer too small returned by program unit CORESVC_ITEM.EXEC_IEXP_HEAD_DEL.

Steps To Recreate:

1. Populate an item master file wtih the item expenses tab populated for the item-supplier expenses we are targeting.
2. Upload the file.
3. Receive the error defined earlier and in the attached Item_Induction_Issues file.
4. Expenses remain on items.

Cause

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