My Oracle Support Banner

OZF_FUNDS_UTILIZED_ALL_B.INCREASE_PAID changing to zero once claim is created (Doc ID 2653188.1)

Last updated on APRIL 27, 2023

Applies to:

Oracle Trade Management - Version 12.2.6 and later
Information in this document applies to any platform.


 After creating an adjustment using API OZF_FUND_UTILIZED_PUB.CREATE_FUND_ADJUSTMENT and increasing total paid amount and creating a new claim for this offer , there is discrepancy in paid amount of OZF_OBJECT_FUND_SUMMARY & SUM of

The issue can be reproduced at will with the following steps:
1. Offer with Earned Amount (paid amount = 0)
2. create paid record using API
3. Create claim for same customer account ->Approve claim
4. After creation of claim, record created in OZF_FUNDS_UTILIZED_ALL_B with adjustment_type = 'INCREASE_PAID¿ updated to 0 USD in all amount related columns.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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