E1: 42: Generate Rebate Claims (R42770) Ends in No records meet search criteria Error in the Work Center (Doc ID 3052936.1)

Last updated on OCTOBER 10, 2024

Applies to:

Symptoms

After the Rebate Transaction Summary (F4078) table has been populated where Sales Orders have been created that exceed the rebate threshold value, running Generate Rebate Claims (R42770) results in the following error in the Work Center:

Error: No records meet search criteria

Steps:
The issue can be reproduced at will with the following steps:
1. Create a Rebate Adjustment (Adjustment Control Code = 5) in Price Adjustment Definition (P4071) and Adjustment Detail (P4072).
2. Enter threshold values and rebate factors in Threshold Revisions (P4077).
3. Link the rebate adjustment to a schedule (P4070), and add that to a customer (P03013).
4. Create a Sales Order with an order quantity well above the threshold value.
5. Run Sales Update (R42800) and verify that tables F4078 (Rebate Transaction Summary) and F4079 (Rebate Transaction Detail) are populated.
6. Run Generate Rebate Claims (R42770) and notice that the system creates the following error in the Work Center:

Error: No records meet search criteria

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.