Multipocessing: As Of Date Not Part Of Where Clause In Unit Of Work Select
Last updated on OCTOBER 04, 2016
Applies to:Oracle Transfer Pricing - Version: 4.5.39
Information in this document applies to any platform.
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
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;
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms