Update sql statement in Application engine fails with ORA-01438 error
We have a couple of application engine processes go down on an Update sql statement that does an arithmetic operation like multiplication. Here is one that fails when trying to reset the amount value to negative amount value. This process was working fine until recently when we did a database upgrade to Oracle 19C. When the same sql statement is executed from a SQL developer it works with no issues. can some one take a look and let me know what may be the problem. thanks
UPDATE PS_FCST_DTL_TAO4 SET AMOUNT = -AMOUNT WHERE PROCESS_INSTANCE = 341087 AND SETID = 'SHARE' AND WORKSHEET_ID = 'OPERATING FCST' AND LINE_ITEM_TYPE = '1' AND LINE_NBR = 6 AND WRKSHEET_LINE_ITEM = 'MATERIALS' AND SOURCE_SET = 'FORECAST' AND POS_SOURCE_ID = 'FCST_AP_DUE_SPR' / -- Row(s) affected: 0 -- 11:11:49.114 Process 341087 ABENDED at Step TR_FCST_CALC.PosnSrce.RevAmt (Action SQL) -- RC = 1438
0