GPF using an OFSA 4.5 Correction Process Id with Correction Rule Containing a Lookup Formula on a Multiplier Field (Doc ID 265776.1)

Last updated on OCTOBER 10, 2012

Applies to:

Oracle Financial Data Manager - Version 4.5 and later
Information in this document applies to any platform.
Oracle Financial Services Applications (OFSA)
Oracle Financial Data Manager (FDM) - Version: 4.5
Oracle Balance & Control (BC) - Version: 4.5

Checked for relevance on 10-Oct-2012.

Symptoms

In Oracle Balance & Control (BC) 4.5, a General Protection Fault (GPF) when running a Correction Process Id containing a Correction Rule with a Direct Assignment to Formula Id. The Formula ID causing the problem is a Lookup on a multiplier field. If using a Formula ID with a Lookup on another field, the Correction Process Id runs to completion.

For example:

Correction Rule:
Data Filter - COMMON_COA_ID = 30324

Column Assignment -
MORTGAGES.COMPOUND_BASIS_CD
MORTGAGES.AMORT_TERM

MORTGAGES.ACCRUAL_BASIS_CD
MORTGAGES.ADJUSTABLE_TYPE_CD
MORTGAGES.AMORT_TERM_MULT
You have created 5 Formula IDs with Lookup Ids:

Formula #1:
Lookup(Mortgages.Common Chart Of Accounts Id,PAT_LOOKUP.Common Chart of
Accounts ID,PAT_LOOKUP.Accrual Basis Code)

Formula #2:
Lookup(Mortgages.Common Chart Of Accounts Id,PAT_LOOKUP.Common Chart of
Accounts ID,PAT_LOOKUP.Adjustable Type Code)

Formula #3:
Lookup(Mortgages.Common Chart Of Accounts Id,PAT_LOOKUP.Common Chart of
Accounts ID,PAT_LOOKUP.Amortization Term)

Formula #4:
Lookup(Mortgages.Common Chart Of Accounts Id,PAT_LOOKUP.Common Chart of
Accounts ID,PAT_LOOKUP.Amortization Term Multiplier) <-------Multiplier

Formula #5:
Lookup(Mortgages.Common Chart Of Accounts Id,PAT_LOOKUP.Common Chart of
Accounts ID,PAT_LOOKUP.Compounding Basis Code)


When you run the Correction Processing Id with this Correction Rule(as shown above), it will GPF if you use the Multiplier Formula Lookup (Formula #4 shown above). If you remove the Formula Id with the Multiplier, the process runs to completion. Also, if you run the Multiplier Formula Lookup by itself (For example, Formula #4 in its own Correction Rule and Correction Processing Id), the Correction Processing Id will GPF as well.

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