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

Last updated on JULY 27, 2017

Applies to:

Oracle Financial Services Profitability Management - Version 6.1.0.3 and later
Oracle Financial Services Analytical Applications Infrastructure - Version 7.3 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

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.

 

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