ORA-00904 Errors in Allocation Debug Log After Adding New User Defined Column for Data Filter (Doc ID 2825395.1)

Last updated on MAY 24, 2023

Applies to:

Symptoms

On PFT 8.0.7.4.0, allocation engine is failing for for an allocation due to a new Data Filter on a user defined column. The following error is displayed in the PFT debug log file with incorrect Data Filter syntax:

ERROR

Module Logging OFS errors (203105 Oracle drv_oci error: OCI Error: 904 ORA- 00904 Module Logging OFS errors: (203105) Oracle drv_oci error: OCI Error: 904 ORA- 00904: "D":
invalid identifier SQL:
select distinct a.ISO_CURRENCY_CD
from FSI_D_LOAN_CONTRACTS a
where a.ISO_CURRENCY_CD <> 'CAD'
AND a.ISO_CURRENCY_CD <> '002'
and (((a.PRODUCT_ID = 10122102)
or (a.PRODUCT_ID = 10123300)
or (a.PRODUCT_ID = 10133300)))
and (((a.CU_SECCODE < 1
or a.CU_SECCODE > 1)))
and (((a.CU_SECCODE < d <== INCORRECT missing ' '
or a.CU_SECCODE > d)  <== INCORRECT
and (a.CU_SECCODE < D   <== INCORRECT
or a.CU_SECCODE > D))) <== INCORRECT
and a.as_of_date='08/ 31/ 2021'
order by a.ISO_CURRENCY_CD

When running an allocation the filter syntax seems to be causing the rule to fail. This same filter is included in a rule in a different environment, that rule is successful but also has different syntax. This seems to have been changed after running a data model upload.

The issue can be reproduced at will with the following steps:
1. Run Model upload with new user defined column to be used in Data Filter
2. Run allocation with Data Filter on custom column

Changes

Cause

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