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 JULY 24, 2017

Applies to:

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

Symptoms

On : 12.1.3 version, Transactions Related

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

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()+

Changes

Upgraded the database from 11.2.0.1.0 to 12.1.0.2.0

Cause

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