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

Last updated on JULY 20, 2023

Applies to:

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

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