My Oracle Support Banner

Parts Requirements Address Error When Using Customer Ship To Address (Doc ID 299338.1)

Last updated on JULY 14, 2020

Applies to:

Oracle Spares Management - Version 11.5.9 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.
FORM:CSPTRREQ - CSP:Parts Requirements


Symptoms

The following error message is being raised when accessing the Parts Requirement form when selecting a "Customer" Ship-To Address:

Execution of procedure do_create_ship_to_location failed because the following unexpected errors occurred:

Cause: ORA-20001:HR_FLEX_VALUE_MISSING:N,COLUMN,TOWN_OR_CITY,N,PROMPT,City

Action: Please contact your technical representative

Execution of CSP_SHIP_TO_ADDRESS_PVT.SHIP_TO_ADDRESS_HANDLER failed because the following errors occurred: CSP.(P_UNEXPECTED_EXEC_ERRORS=Y) (RUTINE=do_create_ship_to_location)
(SQLERRM=ORA-20001: HR_FLEX_VALUE_MISSING:N,COLUMN,TOWN_OR_CITY,N,PROMPT,City)

Steps:
Responsibility = Field Service Manager
Navigation = Field Service Dispatcher > Spares management > Spares Logistics > Parts Requirement
Click on NEW
On Parts Requirements form select a Service Request / Repair Order
Select a Task
The default address is set to Engineer.
Click on CUSTOMER radio button.
Customer address defaults.
Complete part requisition line.
SAVE and the error is generated.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.