WSH_DELIVERY_VALIDATIONS is Invalid After Patch 23115794_R12.WMS.C is Applied (Doc ID 2227927.1)

Last updated on JANUARY 28, 2017

Applies to:

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

Symptoms

WSH_DELIVERY_VALIDATIONS is invalid after patch 23115794_R12.WMS.C is applied

OBJECT_NAME
------------------------------------------------------------------------------
--
OBJECT_TYPE OWNER STATUS
------------------- ------------------------------
WSH_DELIVERY_VALIDATIONS INVALID
PACKAGE BODY APPS

[Error] PLS-302 (7635: 25): PLS-302: component 'SERVICE_ORG_ID' must be
declared
[Error] PLS-394 (10135: 9): PLS-394: wrong number of values in the INTO
list of a FETCH statement
These are the errors when trying to manually recompile

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