My Oracle Support Banner

Updated table to fail orders but orders are still pending (Doc ID 441810.1)

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Communications ASAP Cartridges - Version 3.1.1 to 3.1.1 [Release 3.1.0]
Oracle Solaris on SPARC (32-bit)

Symptoms

Description

"There were some work orders in NSC-ASAP that stayed in progress and that we wanted to fail. I have written a script 
that would update a table:update TBL_WRK_ORD set WO_STAT = 253 where WO_STAT = 103 and  wo_id like 'EXTCLNT:%' and 
srq_id in (select srq_id from tbl_srq where host_clli = 'XXXXXX') However I can see in the ControlProgramOutput 
that the orders are still in progress, but we do not see them in OCA anymore"

Impact

Since those orders that are in progress are not well formatted they stay in progress.

Error Message

None

Changes

 

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
 Description
 Impact
 Error Message
Changes
Cause
Solution
 Resolution
 WorkAround

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