Creating On-Hand Inventory Claim from Price Protection Transaction Error: "ORA-01422: exact fetch returns more than requested number of rows has been detected in DPP_CLAIMS_PVT. Inventory Item ID is required for the API" (Doc ID 1496874.1)

Last updated on JANUARY 02, 2016

Applies to:

Oracle Price Protection - Version 12.1.1 to 12.1.1 [Release 12.1]
Information in this document applies to any platform.

Symptoms

Cannot create On-Hand Inventory Claim from Price Protection Transaction. 


Error

ORA-01422: exact fetch returns more than requested number of rows has been detected in DPP_CLAIMS_PVT. Inventory Item ID is required for the API
ORA-01422: exact fetch returns more than requested number of rows in Package DPP_CLAIMS_PVT Procedure Create_Claims

Steps to Reproduce

  1. Responsibility: Oracle Price Protection User
  2. Navigation: Create Transactions
  3. Click execute button of Create On-hand Inventory Claim
  4. Claim fails with error

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