My Oracle Support Banner

PFT Lookup Table Driver Allocation Failing With ORA-04098 Trigger is Invalid Error (Doc ID 1293103.1)

Last updated on AUGUST 11, 2020

Applies to:

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

Symptoms

On Oracle Financial Services Profitability Management (PFT) 5.2.2, when attempting to run an Lookup Table Driver allocation with a hierarchy leaf filter,the following error occurs:

ERROR

Module Logging OFS errors: (203105) Oracle drv_oci error: OCI Function: [4] - oexec(),
oexn() SQL Function: [5] -
UPDATE Oracle Error: ORA- 04098: trigger
'<ATOMIC>.TIV7DB30D4A4C40BB10_TRG' is invalid
and failed re- validation Driver Function: drv_oci::Execute() SQL
Statement:
update TIV7DB30D4A4C40BB10 a
set identity_code_chg=10001.000000, CURRENT_FC_BALANCE=greatest(-
999999999999, least(999999999999, decode(a.identity_code_chg,
10001.000000, a.CURRENT_FC_BALANCE, 0)+
(NVL(TRANSACTION_CURRENCY_BAL, 0) * NVL(pg1lkup2, 0) )* 1))
where a.GL_ACCOUNT_ID IN (SELECT leaf_node
FROM ofsa_idt_rollup
WHERE (node_01=117613)
AND sys_id_num=200089)
and a.as_of_date='03/ 02/ 2011'

The issue can be reproduced at will with the following steps:
1. Run allocation command line:
./ofspa OFSAADOM_200010_EXEC_20110204_1 Allocation Task1 20110204 200010 <USER> AsOfDate=03/02/2011

2. Check debug log and command for errors:

Error(Oracle Financial Services Application error) (203105) Oracle drv_oci error:

OCI Function: [4] - oexec(), oexn()
SQL Function: [5] - UPDATE
Oracle Error: ORA-04098: trigger '<ATOMIC>.TIV7DB30D4A4C3E4B10_TRG' is invalid and failed re-validation

Driver Function: drv_oci::Execute()

SQL Statement: update TIV7DB30D4A4C3E4B10 a set identity_code_chg=10001.000000,CURRENT_FC_BALANCE=greatest(-999999999999,least(999999999999,decode(a.identity_code_chg,10001.000000,a.CURRENT_FC_BALANCE,0)+(NVL(TRANSACTION_CURRENCY_BAL, 0) * NVL(pg1lkup2, 0) )*1)) where a.GL_ACCOUNT_ID IN (SELECT leaf_node FROM ofsa_idt_rollup WHERE (node_01=117613) AND sys_id_num=200089) and a.as_of_date='03/02/2011'
Error: (20005) Internal Error.
See table FSI_MESSAGE_LOG for more details. Job Number: OFSAADOM_Task1_200010_EXEC_20110204_1
Error(Oracle Financial Services Application error) (203055) Error Executing SQL statement.

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.