Resource Addresses and Subinventories Error: "You cannot pass the party site number" (Doc ID 1056926.1)

Last updated on DECEMBER 15, 2016

Applies to:

Oracle Spares Management - Version 11.5.8 to 12.1.2 [Release 11.5 to 12.1]
Information in this document applies to any platform.
Form:CSPTRESS.FMB - CSP:Resource Addresses and Subinventories
***Checked for relevance on 14-Sep-2011***


Symptoms

Saving changes in the Resource Addresses and Subinventories form in Spares Management generates the following error:

ERROR
-----------------------
First Popup:
Execution of procedure ship_to_address_handler failed because the following unexpected errors occurred.
Cause: ORA-06502: PL/SQL: numeric or value error
Action: Please contact your technical representative

Second popup:
You cannot pass the party site number because the profile option HZ:Generate Party Site Number is either Null or is set to Yes

 
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Spares Management -> Setup -> Resource Addresses and Subinventories.
2. Enter new employee, address data and at least one default subinventory.
3. Save.

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