My Oracle Support Banner

OFSAA PFT Allocation Rule Filter Condition Fails For Some Rulles When Written In Filter With Or Without Quotes (Doc ID 2602927.1)

Last updated on OCTOBER 31, 2019

Applies to:

Oracle Financial Services Profitability Management - Version 8.0.6.1.0 and later
Information in this document applies to any platform.
Oracle Financial Services Profitability Management - OFS PFT

Symptoms

On PFT 8.0.6.1.0 version, Allocation rule failing due to invalid identifier Driver


ERROR
-----------------------

UPDATE PFT_ACCT_SUMMARY
SET IDENTITY_CODE_CHG = 436 , BR_VAR_CON_BANKING =
NVL(BR_VAR_CON_BANKING, 0) + ( NVL(NII, 0) * .1 )
WHERE JOB_TITLE_GROUP_ID=2
and (((FLAG_LENDING_FUNDING = F)))
and as_of_date='01/ 31/ 2019' ;

Flag value not coming in quotes "FLAG_LENDING_FUNDING = F" but when check in view sql of filter it shows in single quotes as per above screenshot.

Some rules are running if in the data filter the quotes are put, but some rules are failing because of the same quotes in the filter. If the quotes are removed from the filter and run the rule which failed because of quotes, then it runs successfully. Flag value is coming in quotes "FLAG_LENDING_FUNDING = "F" "

"GROUP BY m.identity_code, m.balance_type_cd) VV UNION ALL
SELECT 433, '01/ 31/ 2019', '01/ 31/ 2019', 'D', VV.* , 105
FROM (SELECT COUNT(m.identity_code), SUM(NVL(NII, 0) ),
NVL(m.identity_code_chg, 0)
FROM PFT_ACCT_SUMMARY m
WHERE m.AS_OF_DATE = '01/ 31/ 2019'
AND m.FLAG_LENDING_FUNDING IN (''F'')              <-------
GROUP BY NVL(m.identity_code_chg, 0)) VV


Module Logging OFS errors: (203105) Oracle drv_oci error: OCI Function: [4] - oexec(),
oexn() SQL Function: [0] - SQL function not found! Oracle Error:
ORA- 00907: missing right parenthesis Driver Function:
drv_oci::Execute()"
 


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
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.