My Oracle Support Banner

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

Last updated on MARCH 26, 2019

Applies to:

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


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
  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




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

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