Unexpected Error Messages SBL-ISS-00121 and SBL-EAI-04376 When Migrating Promotions With Import Export (Doc ID 1134086.1)

Last updated on MAY 01, 2023

Applies to:

Symptoms

The following error message is displayed when migrating promotions from source to target environment:

[1] Partial Import: ; [1] Method 'Execute' of business component
'Product Promotions Relationship VBC' (integration component 'Product
Promotions Relationship VBC') returned the following error: "An active
version can not be found; Type ISS_PROD_DEF; Name Test Product; Time stamp 04/06/2010
12:57:01(SBL-ISS-00121)"(SBL-EAI-04376); Data will be skipped ; [1]
Method 'Execute' of business component 'Product Promotions Relationship
VBC' (integration component 'Product Promotions Relationship VBC')
returned the following error: "An active version can not be found; Type
ISS_PROD_DEF; Name Test Product; Time stamp 04/07/2010
09:01:15(SBL-ISS-00121)"(SBL-EAI-04376); Data will be skipped ; [1]
Method 'Execute' of business component 'Product Promotions Relationship
VBC' (integration component 'Product Promotions Relationship VBC')
returned the following error: "An active version can not be found; Type
ISS_PROD_DEF; Name Test Product; Time stamp 04/07/2010
13:27:48(SBL-ISS-00121)"(SBL-EAI-04376); Data will be skipped ;


Steps to reproduce it:

1-) Create a Customizable Product with 1 child Product in the source environment

Root Product SF
Child Product SF 1

No Min or Default cardinality defined in the product. Max was set to 999 by default.

2-) Create a Promotion with Root Product SF

Promotion
Root Product (Min =1, Default =1 , Max =1)
Child Product

No promotions constraints or cardinality were set to the child products

3-) Export the promotion export using Full Structure

4-) Import in the target environment and release all objects

5-) In the source environment, add a new child Product to the Root Product

Root Product SF
Child Product SF 1
Child Product SF 2

No Min or Default cardinality defined in the product. Max was set to 999 by default.

6-) Check the Promotion and you will see that the Child Product SF 2 is now part of it.

7-) Re-export the promotion using Objects Only

8-) Import the Promotion in the target

=> We get the following error message:

Import: Partial; ; [1] Method 'Execute' of business component 'Product Promotions Relationship VBC' (integration component 'Product Promotions Relationship VBC') returned the following error:
"An active version can not be found; Type ISS_PROD_DEF; Name Child Product SF 1; Time stamp 04/30/2010 11:47:11(SBL-ISS-00121)"(SBL-EAI-04376); Data will be skipped

9-) Re-export the Promotion using Full Structure and import in the target environment

=> We get the same error message:

Import: Partial; ; [1] Method 'Execute' of business component 'Product Promotions Relationship VBC' (integration component 'Product Promotions Relationship VBC') returned the following error:
"An active version can not be found; Type ISS_PROD_DEF; Name Child Product SF 2; Time stamp 04/30/2010 11:47:11(SBL-ISS-00121)"(SBL-EAI-04376); Data will be skipped

In version 7.8, the object gets imported as expected with no error messages using the same scenario.

Note: the error message is displayed even after applying the workaround provided on
<Bug 10583814> "Getting the error SBL-EAI-04421, when importing a product promotion from one environment of 8.1.1 to other environment"

Changes

Cause

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