Filter Not Working In Receivables Posting Seeded Transaction Source (Doc ID 2049725.1)

Last updated on DECEMBER 21, 2015

Applies to:

Oracle Incentive Compensation - Version 12.2.3 and later
Information in this document applies to any platform.

Symptoms

Collect Invoice package has a filter condition as follows:
--*** User-defined filter statements
  DELETE FROM cn_comm_lines_api api
  WHERE
  api.attribute43 = 'XX _XX'  --(Where XX_XX is the value of the attribute )
AND api.transaction_amount = 0
  AND api.process_batch_id = x_batch_id;

But after collection is completed transactions with the above conditions are still seen in cn_comm_lines_api_all

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