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

Last updated on OCTOBER 31, 2016

Applies to:

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

Symptoms

On Oracle Financial Services Profitability Management (OFSPM) 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 PFTDOM_200010_EXEC_20110204_1 Allocation Task1 20110204 200010 PFTUSER 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: PFTDOM_Task1_200010_EXEC_20110204_1
Error(Oracle Financial Services Application error) (203055) Error Executing SQL statement.
done.

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