My Oracle Support Banner

Trade Management Claims Summary Page Is Not Opening (Doc ID 2770965.1)

Last updated on NOVEMBER 30, 2021

Applies to:

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

Symptoms

On : 12.2.9 version, CLAIMS

ACTUAL BEHAVIOR
---------------
Recently upgraded to 12.2.9 and users are unable to access the Trade Management Claims Summary page.  There is no error, the browser page will spin and never display the page.


STEPS
---------
a) Navigate to Trade Management User responsibility
b) Click on Claims from responsibility menu or Claims tab
c) Claim Summary doesn't populate.


EXPECTED BEHAVIOR
-------------------------
User should be able to open the Claims tab and review the Claim Summary detail.


TRACE SHOWS
------------------
Below query is causing the page to not populate as expected.

SELECT * FROM (SELECT /*+ push_pred(jre4) push_pred(pv) push_pred(ps) */
oc.amount_settled amountSettle, oc.tax_amount taxAmount, oc.acctd_tax_amount
accTaxAmount, oc.acctd_amount_settled acctdAmtSettled,
DECODE(accd.edit_metrics_yn,'Y', 'Y',
DECODE(FND_PROFILE.VALUE('OZF_CLAIM_UPDATE_ACCESS'), 'UPDATE','Y','N'))
accessFlag,...

 

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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