Performance Issue Using The Public API "OZF_CLAIM_PUB.Asso_Accruals_To_Claim_Line"

(Doc ID 2385587.1)

Last updated on APRIL 12, 2018

Applies to:

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

Symptoms

Performance issue using the public API "OZF_CLAIM_PUB.Asso_Accruals_To_Claim_Line"

Porr performing query,

 SELECT SUM(plan_curr_amount_remaining)
 FROM ozf_funds_utilized_all_b
 WHERE utilization_type IN('ACCRUAL','ADJUSTMENT', 'CHARGEBACK')
  AND org_id = cv_org_id
  AND gl_posted_flag = 'Y'
  AND plan_type = cv_plan_type
  AND plan_id = cv_offer_id
  AND (cv_product_id IS NULL OR product_id = cv_product_id)
  AND (cv_product_level_type IS NULL OR product_level_type = cv_product_level_type)
  AND plan_currency_code = cv_plan_currency_code
  AND cust_account_id = cv_cust_account_id;



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