My Oracle Support Banner

Spares Management: Getting error trying to submit a parts requirement with a 'Special' shipto address (Doc ID 1505050.1)

Last updated on MARCH 12, 2021

Applies to:

Oracle Spares Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

 
Getting error trying to submit a parts requirement with a 'Special' shipto address:

Error:
-------
Unable to create Special Ship To Address. Please contact System Administrator.

in the FND debug logfile, the following error can be seen:

csp.portal.requirement.server.RequirementAMImpljava.sql.SQLException: ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'SHIP_TO_ADDRESS_HANDLER'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

 

This happens after <patch 14743823:R12.CSP.B> - CSPCSP_PROCESS_ORDER_ERRORSNOM_MSGVALIDATION FAILED FOR THE FIELD - BILL TO

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.