IB Error ' 'You have encountered an unexpected error in CSI_INV_TRXS_PKG.RECEIPT_INVENTORY, with error ORA-01403: no data found' (Doc ID 987818.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Installed Base - Version 11.5.10.2 to 12.1.3.4 [Release 11.5 to 12.1]
Information in this document applies to any platform.
***Checked for relevance 07-Aug-2014***

Symptoms

PO receipt a Serial Number where an Instance already exists in Install Base (through manual creation or earlier Sales Order shipment).  The transaction has one of the following errors in the 'Transaction Errors Processing' form

'You have encountered an unexpected error in CSI_INV_TRXS_PKG.RECEIPT_INVENTORY, with error ORA-01403: no data found'

OR

'An Owner Party already exists for this Item Instance <instanceno>. An instance can have only one Owner Party.


Steps to recreate the problem.

(Usage in CMRO)

1. Manually create an instance with serial number in Oracle Installed Base HTML page with internal owner checked.

2. Create an PO to receive same serial number into inventory

3. PO receipt transaction is in error


(Usage in transfer inventory internally)

1. Create an OM standard order to ship a serial number from inventory organization A to organization B

2. PO create in organization B to receive the serial number

3. PO receipt transaction is in 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