My Oracle Support Banner

Unable to Delete Item Due to Error : exec_delete 5 ORA-00942: table or view does not exist (Doc ID 2213018.1)

Last updated on OCTOBER 12, 2023

Applies to:

Oracle Item Master - Version 12.2.5 and later
Oracle Inventory Management - Version 12.2.5 and later
Information in this document applies to any platform.

Symptoms

Problem Statement
Getting the following error while deleting an Item 'exec_delete 5 ORA-00942: table or view does not exist'.
You applied <Patch:24326014>:R12.ITM.D (which upgraded invdelc.ldt to 120.17.12020000.11), but it did not resolve the issue.

Error
exec_delete 5 ORA-00942: table or view does not exist

Steps To Reproduce

  1. Create Item
    (N)INV > Items > Master Items

  2. Delete Groups (Org in which Item was created)
    (N)INV > Items > Delete Items  
    ==>Submitted request for Concurrent Program(BMCDEL)

  3. Requests

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


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