My Oracle Support Banner

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 MARCH 24, 2019

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

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
Symptoms
Cause
Solution
References


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