PRODUCT PROMOTION EXPORT IS TAKING LONG TIME IN IP15 (Doc ID 2202102.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel CRM - Version 15.8 [IP2015] and later
Information in this document applies to any platform.

Symptoms

 While exporting Promotion, they see a huge performance differences as compared to 8.0.x.
On analysis what we have observed in that the IO ISS Promotion has a new IC Product Promotions Relationship VBC which was not present in 8.0.

The major difference is caused by this IC.

The BS 'ISS Authoring Import Export Service' invoke method: 'ExportFullVOD' took 46sec to complete in 8.0.
In IP15 the same takes 111.467 seconds for the same set of Promotions.

And the major reason is query on this IC Product Promotions Relationship VBC|Execute|10|10970

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