Sdbp_Cost_Invoice Batch error: User-Defined Exception,ORA-06502 (Doc ID 1490248.1)

Last updated on OCTOBER 16, 2016

Applies to:

Oracle Utilities Work and Asset Management - Version 1.9.0 and later
Information in this document applies to any platform.

Symptoms

The dbms_activity variable utilized in the sdbp_approve_invoice procedure is set at 100 characters. There is a statement in the procedure that sets the variable to a string that contains 102 characters causing an error when the cost_invoice process to post invoices runs. The value is set prior to an insert to the storeroom log for an invoice with a price variance between the invoice and po price. This causes the user defined exception when the invoice is to be posted. The invoice cannot be posted with the variance.

This shows the code causing the issue:

IF v_diff_amount != 0
THEN
  dbms_activity := 'Insert in sa_storeroom_log table: v_unit_diff * invoice_rec.invoice_quantity and invoice_rec.pi_ratio.'; -- 19-2

Error Codes
---------------------------------------------------
User-Defined Exception,ORA-06502

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