Can Item Instance Transaction History be Migrated to Install Base ?

(Doc ID 1274909.1)

Last updated on MARCH 06, 2018

Applies to:

Oracle Installed Base - Version 12.0.6 to 12.2.6 [Release 12 to 12.2]
Information in this document applies to any platform.

Goal

While migrating legacy data to Install Base, if user wants to create instance transaction history records in csi_item_instances_h table for instances, how can that be done ?  Is there an API that supports this?

For example, there is one Item that has about 716 associated install base history transactions (inventory moves, Subinventory transfers, receipts, processing etc.) in the legacy application from a period of 10-12 years ago. When doing an Install Base conversion user wants to create 1 Install Base instance (i.e. record count in csi_item_instances = 1) and 716 install base history records (i.e. record count in csi_item_instances_h = 716).

Can this be done using the Install Base Open Interfaces or any other way?


Solution

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