Why Does Accrual Data Have No Value In ORIG_UTILIZATION_ID Or PRICE_ADJUSTMENT_ID ? (Doc ID 2067697.1)

Last updated on DECEMBER 28, 2015

Applies to:

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

Goal

Question 1

Accruals captured in OZF_FUNDS_UTILIZED_ALL_B table but there is no reference information found in columns ORIG_UTILIZATION_ID or PRICE_ADJUSTMENT_ID

Most of these lines are related to UTILIZATION_TYPE = ' ADJUSTMENT'

Why is there no data in these tables ?
 


Question 2

Normally OE_PRICE_ADJUSTMENTS table will store all calculations performed before arriving the final discount rate etc.
For back dated adjustments  if there is no record in price_adjustment_id or orig_Utilization_id then how do we know the calculation done by the system and where we can find the information?
 


Question 3

When Price_adjustment_id is null  there is no way to understand the calculation.

Normally for backdated adjustments which table is used to store calculations?
 

Solution

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