Multipocessing: As Of Date Not Part Of Where Clause In Unit Of Work Select (Doc ID 403508.1)

Last updated on OCTOBER 04, 2016

Applies to:

Oracle Transfer Pricing - Version: 4.5.39
Information in this document applies to any platform.

Goal

AS_OF_DATE is not included when Transfer Pricing process performs multiprocessing unit of work data slicing. This causes all months to be included when slicing data. AS_OF_DATE is included when each slice of data is processed.

Is this the expected behavior?

If so, then should he include AS_OF_DATE in the filter criteria so that it will be included in the data slicing SQL?

See Example Below:

SELECT DISTINCT a.product_2_id, a.org_unit_id
FROM cons_loan_als a
WHERE a.product_1_id = 178390
AND NOT product_2_id IN

(SELECT leaf_node
FROM ofsa_idt_transfer_price
WHERE transfer_price_sys_id = 178452
AND (tp_calc_method_cd = 3
OR (tp_calc_method_cd = 5
OR tp_calc_method_cd = 8)
AND mid_period_reprice_flg <> 0
AND assignment_date_cd = 1))
ORDER BY a.product_2_id, a.org_unit_id;

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