PFT 8.1.1.3: Uniform Allocation Distribution Doesn’t Include The Month In Driver (Doc ID 2949478.1)

Last updated on MAY 23, 2023

Applies to:

Symptoms

On PFT 8.1.1.3 version, Uniform allocation distribution doesn’t include the month in driver.

When you try to create an allocation with uniform distribution, the driver doesn’t include the month that appears in the source. The driver includes the year only.
You expect the driver to also have the month set.


Below is what appears in the allocation log for uniform distribution in the driver part (see the last two lines of the excerpt):

FROM FSI_D_MANAGEMENT_LEDGER mv) m
WHERE m.FINANCIAL_ELEM_ID = 40030.000000
AND XX_CHANNEL_ID IN (
SELECT LEAF_NODE
FROM OFSA_IDT_ROLLUP
WHERE OFSA_IDT_ROLLUP.SYS_ID_NUM = 203984
AND (OFSA_IDT_ROLLUP.NODE_02 IN (
SELECT REV_HIERARCHY_FILTER.LEAF_NODE
FROM REV_HIERARCHY_FILTER
WHERE REV_HIERARCHY_FILTER.SYS_ID_NUM = 226400
AND REV_HIERARCHY_FILTER.HIERARCHY_LEVEL = 2 )
OR OFSA_IDT_ROLLUP.NODE_01 IN (
SELECT REV_HIERARCHY_FILTER.LEAF_NODE
FROM REV_HIERARCHY_FILTER
WHERE REV_HIERARCHY_FILTER.SYS_ID_NUM = 226400
AND REV_HIERARCHY_FILTER.HIERARCHY_LEVEL = 3 ) ))
AND m.FISCAL_YEAR = 2022.000000
AND m.CONSOLIDATION_CD = 100.000000 )


User also made a comparison with percent distribution and in this case the month rule seems to be applied (see below with m.FISCAL_MONTH):

FROM (SELECT ROW_NUMBER() OVER ( PARTITION BY LEGAL_ENTITY_ID,
XX_CHANNEL_ID
ORDER BY LEGAL_ENTITY_ID, XX_CHANNEL_ID ) RW, (SUM(DECODE(
m.FISCAL_YEAR, 2022.000000 , DECODE(m.FISCAL_MONTH, 11.000000 ,
m.ENTERED_BALANCE, 0), 0)) OVER (PARTITION BY LEGAL_ENTITY_ID,
XX_CHANNEL_ID)) ColVal, (SUM(DECODE( m.FISCAL_YEAR, 2022.000000 ,
DECODE(m.FISCAL_MONTH, 11.000000 , m.ENTERED_BALANCE, 0), 0))
OVER ()) mTotal, LEGAL_ENTITY_ID, XX_CHANNEL_ID

Cause

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