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.
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.
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
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.
Observe the above error
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