My Oracle Support Banner

Unable To Update Resource Addresses And Subinventories For Spares Management .Getting Error"HR_7220_INVALID_PRIMARY_KEY" (Doc ID 2581658.1)

Last updated on AUGUST 30, 2019

Applies to:

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

Symptoms

On : 12.2.8 version, Setup Related UIs

When trying to update existing setups of Resource Addresses and Subinventories for Spares Management getting the following error.


ERROR
-----------------------
Execution of procedure do_update_ship_to_location failed because the following unexpected errors occurred:
Cause: ORA-20001: HR_7200_INVALID_PRIMARY_KEY
Action: please contact your technical representative


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login to Applications
2. Go to Responsibility: Spares Management
3.Navigate to Setups>Addresses and SubInventories HTML
4.Query existing record
The Address information is blank
5,Navigate to SubInventories tab add a SubInventory to the existing list.

Save (CTRL+S).

Observe the above error



Changes

 

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
Changes
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.