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 FEBRUARY 13, 2017

Applies to:

Oracle Item Master - 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'.
They applied <Patch:24326014>:R12.ITM.D and 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

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