WSHPSRS INV_MOVE_ORDER_PUB.PROCESS_MOVE_ORDER ORA-01403: NO DATA (Doc ID 2054728.1)

Last updated on DECEMBER 22, 2015

Applies to:

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

Symptoms

When attempting to create reservation in Autodetail Batch form, got the following error:

ERROR
-----------------------
Batch form>Manully create reservation

ORA-06508: PL/SQL: could not find program unit being called in Package INV_RESERVATION_VALIDATE_PVT Procedure Validate_item_sku


Batch form>Autocreate reservation

Error:

ORA-06508: PL/SQL: could not find program unit being called in Package INV_Pick_Release_PVT Procedure INV_PICK_RELEASE_PVT

The package INV_PICK_RELEASE_PUB has been compiled but got this error:

ORA-04045: errors during recompilation/revalidation of APPS.INV_PICK_RELEASE_PUB
ORA-00955: name is already used by an existing object


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Production supervisor responsibility>Batch details>Autodetail batch/Line

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