How can products be imported using EIM? (Doc ID 485530.1)

Symptoms

We understood that the S_VOD and S_VOD_VER tables have been reintroduced in the application, and looking at the database, each record on the S_PROD_INT is linked to one record on the S_VOD, and each record on the S_VOD is linked to at least one record on the S_VOD_VER.

Since there isn't any EIM table that maps these two tables the records that we import do not have any corresponding record on the S_VOD and S_VOD_VER table. We believe that this might be the cause of the problems that we are experiencing on the records that we import.

The problem is that the product imported is only visible in the product administration view and moreover, it is not possible to save the record created by EIM in the product administration view. The error returned is "This operation is not allowed when there are no records displayed. Please execute a query that returns at least one record or add a new record. (SBL-DAT-00215)".

The key of S_PROD_INT to the S_VOD is the CFG_MODEL_ID column, which is not a FK, in the comment field of the S_PROD_INT table is written:

"Versioned Object Definition Id. From 7.0.x onward, this column has not been used by the application. For 7.8, this column will be re-used as a user key reference to S_VOD, where CFG_MODEL_ID is equal to S_VOD.OBJECT_NUM and S_VOD.VOD_TYPE_CD is implicitly equal to 'ISS_PROD_DEF'. For EIM, this column will be mapped as an attribute.".

It is not clear to us how the EIM should be populated, if you could provide us some indications it would be very helpful. In attachment I have added the IFB file that we are using and an insert query on the EIM table that we are using for our test.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.