Approving Adjustment Error FRM-40735: ON-UPDATE trigger raised unhandled exception ORA-01403

(Doc ID 2122614.1)

Last updated on MARCH 13, 2018

Applies to:

Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.


On : 12.1.3 version, Transactions Related

You are attempting to approve an Adjustment, using a non-MOAC responsibility, and receive the following error:

ORA-01403: no data found
FRM-40735: ON-UPDATE trigger raised unhandled exception ORA-01403.

FND log file shows:

ar.plsql.sum 13336986 t_prorated_amt =-6.35 =-6.31
ar.plsql.sum before swap: 13336986 line=-.04 tax=-6.31
ar.plsql.sum after swap: 13336986 line=-.04 tax=-6.31
ar.plsql.sum element_index 13336889 line=-.04 tax=0
ar.plsql.sum element_index 13336890 line=-.04 tax=0
ar.plsql.sum element_index 13336891 line=-.04 tax=0
ar.plsql.sum element_index 13336892 line=-.04 tax=0
ar.plsql.sum element_index 13336893 line=-.04 tax=0
ar.plsql.sum element_index 13336894 line=-.04 tax=0
ar.plsql.ar_process_adjustment.update_adjustment EXCEPTION: ar_process_adjustment.update_adjustment()
ar.plsql.arp_process_adjustment.update_adj_cover EXCEPTION: arp_process_adjustment.update_adj_cover()


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