Debit Rows Over-Written with Credit When Running a Ledger Stat Allocation Against 2nd Month (Doc ID 1443796.1)

Last updated on APRIL 05, 2012

Applies to:

Oracle Financial Services Profitability Management - Version: 5.6 and later   [Release: 5 and later ]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

In Oracle Financial Services Profitability Management (PFT) 5.6, when you run a Dynamic Driver Ledger Stat to Ledger Stat Allocation against a second month of data, the Allocation does not update the second MONTH_xx column and sets the BALANCE_TYPE_CD = 102 for the Debit rows that had previously been set to 101 by the first run.

Example: First Run is for January 2011 and the Second run if for February 2011

Source Row:

Identity Cd
Fin Elem
GL Acct
Common COA
Product
Org Unit
Month_01
Month_02
Bal Type Cd
100001
10078
999
41312
999
15000004
100
200
0

Driver Rows:

Identity Cd
Fin Elem
GL Acct
Common COA
Product
Org Unit
Month_01
Month_02
Bal Type Cd
90001
14519
999
999
115010102000
15000004
20
10
0
90001
14519
999
999
120000101000
15000004
30
20
0
90001
14519
999
999
116010103000
15000004
10
10
0


1st Run: 01/31/2011

(Debit: Product = Same As Driver, Org Unit = Match Source & Driver)

Debit Output - Correct:

Identity Cd
Fin Elem
GL Acct
Common COA
Product
Org Unit
Month_01
Month_02
Bal Type Cd
10366
10078
999
41312
115010102000
15000004
33.33
0
101
10366
10078
999
41312
120000101000
15000004
50
0
101
10366
10078
999
41312
116010103000
15000004
16.67
0
101

Credit Output - Correct:

Identity Cd
Fin Elem
GL Acct
Common COA
Product
Org Unit
Month_01
Month_02
Bal Type Cd
10366
10078
999
41312
999
15000004
-100
0
102


2nd Run: 02/28/2011

Debit Output - Wrong:

Identity Cd
Fin Elem
GL Acct
Common COA
Product
Org Unit
Month_01
Month_02
Bal Type Cd
10366
10078
999
41312
115010102000
15000004
33.33
0
102
10366
10078
999
41312
120000101000
15000004
50
0
102
10366
10078
999
41312
116010103000
15000004
16.67
0
102

Credit Output:

Identity Cd
Fin Elem
GL Acct
Common COA
Product
Org Unit
Month_01
Month_02
Bal Type Cd
10366
10078
999
41312
999
15000004
-100
-200
102


In the 2nd run, for Debit, the MONTH_02 column is not updated and Balance Type Cd is updated to 102.

Steps to Reproduce:
  1. Go to Profitability Management
  2. Go to Rule Specification > Allocation Specification
  3. Create and run a Dynamic Driver Ledger Stat Allocation for January 2011
  4. Run the same Dynamic Driver Ledger Stat Allocation for February 2011
No values are output to MONTH_02 and the debit Balance Type Cd is updated to 102.

Cause

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