GST : Error FRM-40735: On-Insert trigger raised unhandled exception in actions - credit memo (Doc ID 2758026.1)

Last updated on NOVEMBER 10, 2023

Applies to:

Symptoms

Problem Statement
----------------------
Unable to create credit memo via actions - Credit for a manual debit memo in receivables (AR).
An error is observed while trying to save the record. For non-India OU's the same functionality is working fine and there is no error faced.


Expected Behavior
--------------------
Expects that the creation of debit memo via actions - credit should be allowed without any error. 


Error message  ( as per form screnshots)
----------------
FRM-40735: On-Insert trigger raised unhandled exception ORA-06502

Error message ( from fnd debug )
-----------------
ar.plsql.arp_ctl_pkg.insert_line_f_cm_ct_ctl_id EXCEPTION: derive_credit_information
ar.plsql.arp_ctl_pkg.insert_line_f_cm_ct_ctl_id EXCEPTION: arp_process_credit.insert_header
ar.plsql.arp_ctl_pkg.insert_line_f_cm_ct_ctl_id EXCEPTION : arp_process_credit_cover.insert_header_cover
ar.resource.arxtwmai_form_main.arxtwmai_main.begin arxtwmai_form_main.arxtwmai_main(ON-ERROR)+
fnd.forms.ARXTWMAI.ON_ERROR "FND?FND_FORMS_ERROR_LOGGING?N?ERRNO?-6502?N?REASON?ORA-01403: no data found


Steps to reproduce:
----------------------

1. Create a debit memo in AR, apply GST taxes. Complete .
2. Go to Actions - Credit & enter required details.
3. Click on save.
4. An error is observed and because of which the record isn't saved.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.