My Oracle Support Banner

Transaction Workbench Issue: Creating an Invoice with Rules FRM-40735: ON-INSERT Trigger Raised Unhandled Exception ORA-06502 (Doc ID 2007964.1)

Last updated on JUNE 22, 2020

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

Attempting to create an Invoice with the Rules and receive the following error:

FRM-40735: ON-INSERT trigger raised unhandled exception ORA-06502

Steps to Reproduce:
Responsibility:  Receivables
Navigation:  Transactions > Transactions
1  Create invoice with “Invoice Rule”
2. Click line Items, enter line information
3. Click “Rules” Tab
4. Select “Accounting” from drop down
5. Click “Save”

The FRD Log shows the following:

Executing NAME_IN Built-in:
In Argument 0 - Type: String   Value: tlin_lines.tax_code  
Out Argument 0 - Type: String   Value: NULL                  

Unhandled Exception ORA-06502
State Delta:

Error Message: FRM-40735: ON-INSERT trigger raised unhandled exception ORA-06502.

The FND Debug Log shows the following:

ar.plsql.arp_dates.prepare_val_gl_pds_sql_stmt EXCEPTION:  arp_dates.prepare_val_gl_pds_sql_stmt()
ar.plsql.prepare_val_gl_pds_sql_stmt ---- parameters for prepare_val_gl_pds_sql_stmt() -----
ar.plsql.prepare_val_gl_pds_sql_stmt p_ai_flag   = FALSE
ar.plsql.arp_dates.val_gl_periods_for_rules EXCEPTION:  arp_dates.val_gl_periods_for_rules()
ar.plsql.val_gl_periods_for_rules ------- parameters for val_gl_periods_for_rules() -------
ar.plsql.val_gl_periods_for_rules p_request_id       =
ar.plsql.val_gl_periods_for_rules p_acc_rule_id      = 3000
ar.plsql.val_gl_periods_for_rules p_acc_duration     = 13
ar.plsql.val_gl_periods_for_rules p_rule_start_date  = 22-APR-15
ar.plsql.val_gl_periods_for_rules p_sob_id           = 2061
ar.plsql.arp_process_line.val_insert_line EXCEPTION:  arp_process_line.val_insert_line()
ar.plsql.val_insert_line ------ parameters for val_insert_line() -------
ar.plsql.arp_ctl_pkg.display_line_rec.begin arp_ctl_pkg.display_line_rec()+
ar.plsql.arp_ctl_private_pkg.display_line_rec.begin arp_ctl_private_pkg.display_line_rec()+


Upgraded the database from to


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
 Still Have Questions?

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