Reimfixeddealupload Batch Does Not Upload Fixed Deal Documents When There Are More than 1000 Rows (Doc ID 2270155.1)

Last updated on JUNE 01, 2017

Applies to:

Oracle Retail Invoice Matching - Version 15.0.1 and later
Information in this document applies to any platform.

Symptoms

When there are more than 1000 details for a fixed deal, reimfixeddealupload batch terminates successfully but doesn't process the data. Log file shows the following error.

ERROR:



Steps to Recreate:
1. Create a merchandise fixed deal with more than 1000 detail records (merch hier / location combinations).
2. Run all deal batches relevant to fixed deal and make sure that data is populated in STAGE_FIXED_DEAL_HEAD and STAGE_FIXED_DEAL_DETAIL tables.
3. Run reimfixeddealupload batch and notice that it terminates successfully but doesn't process the deal.
4. Notice the above error in the log file.

Changes

 

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