Cannot Finish Work Order Task When BI Trigger Is Enabled. Error: Calling swop_finish_task.ORA-20001:ERROR: SDBT_BI_AIU_WRK_ORD_TASK Generating primary Key for insert/update action ORA-06502:PL/SQL :numeric or (Doc ID 1516821.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

Cannot Finish Work Order Task When the "SDBT_BI_AIU_WRK_ORD_TASK" BI Trigger is enabled. Receive the following error :

Error: Calling swop_finish_task.ORA-20001:ERROR: SDBT_BI_AIU_WRK_ORD_TASK Generating primary Key for insert/update action ORA-06502:PL/SQL :numeric or
value error: character to number conversion error.

This problem occurs only for the work orders where the work_order_no starts with an alpha character(For ex: W0000001)

Steps to Reproduce:
-------------------------------
1.Enable the "SDBT_BI_AIU_WRK_ORD_TASK" trigger.
2.Create a Work Order.  Make sure the work order no starts with an alpha character.
3.Activate the WO.
4.Go to WO task. Finish the WO task.
5.WO task finishing wizard opens up.
6.When you click the Finish button, on the last Screen of the finishing wizard,the following error pops up:

Error: Calling swop_finish_task.ORA-20001:ERROR: SDBT_BI_AIU_WRK_ORD_TASK Generating primary Key for insert/update action ORA-06502:PL/SQL :numeric or
value error: character to number conversion error.



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