My Oracle Support Banner

There Is No Data CSI_ITEM_INSTANCES after Miscellaneous Receipt with Serial Number after R12.2.9 Upgrade (Doc ID 2752698.1)

Last updated on MARCH 12, 2021

Applies to:

Oracle Inventory Management - Version 12.2.5 and later
Information in this document applies to any platform.

Symptoms

Actual Behavior
On R12.1.3 instance, After Miscellaneous Transaction Receipt with Serial number,
There is generated data on CSI_ITEM_INSTANCES table immediately.
But on R12.2.9 instance, Do same step, there is no data generated on CSI_ITEM_INSTANCES table.

Expected Behavior
Want to generated on CSI_ITEM_INSTANCES table after Miscellaneous Transaction after R12.2.9 Upgrade

Steps to Reproduce

  1. Create serial number controlled item and Track in Installed Base filed was checked in Service tab on Master Item form.
    (N)Inventory > Items > Master Items > Service tab
  2. Miscellaneous Transaction Receipt with Serial number
    (N)Inventory > Transactions > Miscellaneous Transaction
  3. Check CSI_ITEM_INSTANCES table

Changes

 Upgrade from R12.1.3 to R12.2.9 instance

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.