Package WSH_REGIONS_SEARCH_PKG Will Not Compile (Doc ID 1588434.1)

Last updated on JULY 19, 2016

Applies to:

Oracle Shipping Execution - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Install Upgrade issues
After an 11.5.10 upgrade to 12.1.3, the APPS package WSH_REGIONS_SEARCH_PKG would not compile due to a "CONTINUE" statement, causing the following errors when trying to access Addresses and Subinventories

ERROR
-----------------------
Errors shown:
Execution of procedure do_create_ship_to_location failed
ORA-01086: savepoint WSH_LOCATION_EXISTS never established
ORA-06512" at APPS.WSH-MAP_LOCATION_REGION_PKG has errors
ORA-06508: PLSQL could not find program unit being called:
APPS.WSH_REGIONS_SEARCH_PKG

 WSH_REGIONS_SEARCH_PKG does not compile

 

Changes

 Upgrade from 11i to 12i

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