ORA-01747: Invalid User.table.column When Running Allocation with Data Filter (Doc ID 2080083.1)

Last updated on MAY 01, 2023

Applies to:

Symptoms

When attempting to run an allocation rule, the following error occurs in the log file showing Multiplier field as blank.

Error
ORA- 01747: invalid user.table.column, table.column,
or column specification Driver Function: drv_oci::Execute() SQL
Statement: MERGE INTO FSI_D_CONSUMER_LOAN TARGET USING (
SELECT IDENTITY_CODE, ID_NUMBER, NVL(AVG_BOOK_BAL, 0) * .000906616 TARGET_AMOUNT
from FSI_D_CONSUMER_LOAN a
where a.PRODUCT_ID=2000
and (((a.AMRT_TERM>=0.00
and a.AMRT_TERM<=365.00
and a.null = 'D')              <----- blank multiplier
or (a.AMRT_TERM>=0.00
and a.AMRT_TERM<=12.00
and a.null = 'M')             <----- blank multiplier
or (a.AMRT_TERM>=0
and a.AMRT_TERM<=1
and a.null = 'Y')))           <----- blank multiplier
and a.as_of_date='09/ 30/ 2015' ) SOURCE ON (SOURCE.IDENTITY_CODE = TARGET.IDENTITY_CODE
AND SOURCE.ID_NUMBER = TARGET.ID_NUMBER
AND TARGET. AS_OF_DATE = '09/ 30/ 2015' ) WHEN MATCHED THEN
UPDATE
SET IDENTITY_CODE_CHG = 14115.000000 , TARGET.ATM_EXP =
(SOURCE.TARGET_AMOUNT * 1)

Module Logging OFS errors: (908001) Fatal error during processing.

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.