Performance Issue Using The Public API "OZF_CLAIM_PUB.Asso_Accruals_To_Claim_Line"
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.
Performance issue using the public API "OZF_CLAIM_PUB.Asso_Accruals_To_Claim_Line"
Porr performing query,
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;
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