Spares Mangement>Resource Address and Subinventories Form Error: 'ORA-01403 no data found An Unexpected Error-6502 has occured.' (Doc ID 759992.1)

Last updated on SEPTEMBER 02, 2016

Applies to:

Oracle Spares Management - Version 12.0.4 to 12.0.6 [Release 12]
Information in this document applies to any platform.
***Checked for relevance on 15-Dec-2011***

FORM:CSPTRESS.FMB - CSP:Resource Addresses and Subinventories


Symptoms

Trying to define addresses and sub-inventories to field service resources fails to save

Steps To Reproduce:

  (R) Field Service Manager

  1. Navigation Field Service Manager>Spares Management> Resource Address and Subinventories - Resources Subinventory assignment
  2. Select Employee
  3. On Address tab enter a valid address and timezone
  4. On the Subinventories tab, choose an organization and usable subinventory and mark it as default.
  5. Commit - Error message displayed:
ERROR:
---------
ORA-01403 no data found
An Unexpected Error-6502 has occured. An alert has been sent to the system administrator.
ORA-01403 no data found

<Patch 6723006> from <Note 563471.1> has already been applied, but the issue persists.

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