My Oracle Support Banner

PFT 6.1 Allocation Rule Fails With Invalid Credit Message Errors When Upgraded Allocation Rule is Run (Doc ID 1645865.1)

Last updated on FEBRUARY 26, 2019

Applies to:

Oracle Financial Services Profitability Management - Version 6.1.0.2 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Applications (OFSA) - Version 4.5

Symptoms

On Oracle Financial Services Profitability Management (PFT) 6.1.0.2 some migrated allocation rules fails with Invalid Credit message when the allocation is run.

ERROR

CONTEXT_SPECIFIC_TEXT
LEDGER_STAT.PRODUCT_COA_ID
LEDGER_STAT.SEGMENT_ID
LEDGER_STAT.COMPONENT_ID
LEDGER_STAT.FINANCIAL_ELEM_ID
LEDGER_STAT.ORG_UNIT_ID
LEDGER_STAT.GL_ACCOUNT_ID
LEDGER_STAT.COMMON_COA_ID
Invalid Credit.
Page: 1
Allocation ID is empty.
Allocation Preparation Completed


When checking the associated FSI_ALLOC_LEAVES table, there are rows missing for dimensions 0-6 for ROW_TYPE = 20 (credit):

Example bad allocation sys_id = 110977:

SYS_ID_NUM SEQUENCES ALLOC_TYPE ALLOC_DESCRIPTION TARGET_TABLE_CD PARALLEL_FLAG PROCESS_TARGET AUDIT_TRAIL_FLAG ALLOC_SYS_ID SEQUENCES_1 ROW_NUMBER LEAF_NUM_ID LEAF_NODE ROW_TYPE TREE_SYS_ID TREE_LEVEL_NUM CONSTANT_CHAR EXPRESSION
110,977 0 0 0 0 0 110,977 0 2 7 -99,300 20 0 0 LEDGER_STAT [Current_Amount] -99100
207,914 0 0 0 0 0 207,914 0 2 0 -99,100 20 0 0 -99100
207,914 0 0 0 0 0 207,914 0 2 1 -99,100 20 0 0 -99100
207,914 0 0 0 0 0 207,914 0 2 2 -99,100 20 0 0 -99100
207,914 0 0 0 0 0 207,914 0 2 3 -99,100 20 0 0 -99100
207,914 0 0 0 0 0 207,914 0 2 4 -99,100 20 0 0 -99100
207,914 0 0 0 0 0 207,914 0 2 5 -99,100 20 0 0 -99100
207,914 0 0 0 0 0 207,914 0 2 6 -99,100 20 0 0 -99100
207,914 0 0 0 0 0 207,914 0 2 7 -99,100 20 0 0 -99100
207,914 0 0 0 0 0 207,914 0 2 709 -99,100 20 0 0 -99100

Steps to reproduce:

1. Migrate from 4.5 to 6.0 using migration scripts.
2. Upgrade to 6.1.0.2 and run allocations.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


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