PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center