Original value gross GetBD 1.0000
Original value gross GetBD + double 1.0
Original value gross 1.0 In BD format 1
Bill 776454602688block flag null
Remaining Qty 1.0
Remaining Mass 1.0
Remaining SAD Qty 1.0
Remaining SAD Mass 1.0
[22-04-07 13:06:03] Scan Doc Date Criteria = Thu Apr 07 00:00:00 AST 2022
[22-04-07 13:06:03] Number of documents found = 1
[22-04-07 13:06:14] Scan Doc Date Criteria = Thu Apr 07 00:00:00 AST 2022
[22-04-07 13:06:14] Number of documents found = 1
This is not an ex-warehose declaration
This is not a credit declaration
[22-04-07 13:06:16] ***********************R_doTaxation started*******************
[22-04-07 13:06:16] ### R_doTaxation executed ### 
Is aref  false
JAVA PARSER : false
working date Thu Apr 07 00:00:00 AST 2022
working date Thu Apr 07 00:00:00 AST 2022
itm count 1
Total docs 0
Old inlisttar()
Old inlisttar()
Old inlisttar()
Old inlisttar()
Old inlisttar()
Old inlisttar()
Old inlisttar()
Is aref  false
[22-04-07 13:06:17] ***********************R_doTaxation FINISHED*******************
[22-04-07 13:06:17] Set registration serial:2022 VCAIC C20257
Flags falseFlags false
[22-04-07 13:06:17] Set assessment serial:2022 VCAIC L20257
[22-04-07 13:06:17] Event Id : 1289
[22-04-07 13:06:17] Event Id : 1289
[22-04-07 13:06:17] Start ReqNum: 1412
[22-04-07 13:06:17] gtx_sds.countDocuments() = 0
SR_OPERATION ADDING RESULT 
docs == null
The tex watermark is added to the image.
The tex watermark is added to the image.
 WRITER OFFtrue
[22-04-07 13:06:24] Don't use Bureau interface

{22-04-07 13:06:24} Error: GCFServerBinder.rollbackTransaction: The document is NOT locked
[22-04-07 13:06:26] Scan Doc Date Criteria = Thu Apr 07 00:00:00 AST 2022
[22-04-07 13:06:26] Number of documents found = 1
Flags falseFlags false
[22-04-07 13:06:34] Criteria expected 100.0:0.0:0.0:0.0
[22-04-07 13:06:34] Selectivity :params not found !!
[22-04-07 13:06:34]  color out of criteria 
[22-04-07 13:06:34] Red
[22-04-07 13:06:34] 
 size of selparams 0
[22-04-07 13:06:34]  color out of max hits params 
[22-04-07 13:06:34] Red
[22-04-07 13:06:34] 
Totals: 
[22-04-07 13:06:34] 0:
[22-04-07 13:06:34] 0:
[22-04-07 13:06:34] 4:
[22-04-07 13:06:34] 1867:
[22-04-07 13:06:34] 

[22-04-07 13:06:34]  item 1 criterion HIGHRISK
[22-04-07 13:06:34]  color 
[22-04-07 13:06:34] Red
[22-04-07 13:06:34] 
[22-04-07 13:06:34] Final Color : 3
[22-04-07 13:06:34] Updating DB.
 checking other administrations selectivity 
Migrate date is set to: 19/04/2019
The tex watermark is added to the image.
[22-04-07 13:06:40] Don't use Bureau interface
[22-04-07 13:06:43] Committing: 0 0
[22-04-07 13:06:49] Previous taxes: 42745.17
[22-04-07 13:06:49] Current taxes: 42745.17
[22-04-07 13:06:49] Inspection act already created
 checking other administrations selectivity 
select valid_from, valid_to from UNHS6TAB where FLG_REM<>1 and HS6_COD=?  order by valid_from 
Start Date : Sat Jan 01 00:00:00 AST 2000
End Date : null
Migrate date is set to: 19/04/2019
The tex watermark is added to the image.
select valid_from, valid_to from UNTARTAB where FLG_REM<>1 and HS6_COD=?  and TAR_PR1=?  and ( TAR_PR2 like ?  or TAR_PR2 like ?  )  order by valid_from 
Start Date : Wed Jan 01 00:00:00 AST 1997
End Date : Thu Jan 01 00:00:00 AST 2009
Start Date : Thu Jan 01 00:00:00 AST 2009
End Date : Sun Oct 13 00:00:00 AST 2013
Start Date : Mon Oct 14 00:00:00 AST 2013
End Date : Sun Feb 15 00:00:00 AST 2015
Start Date : Sun Feb 15 00:00:00 AST 2015
End Date : Mon May 01 00:00:00 AST 2017
Start Date : Mon May 01 00:00:00 AST 2017
End Date : Tue Jun 01 00:00:00 AST 2021
Start Date : Tue Jun 01 00:00:00 AST 2021
End Date : null
select valid_from, valid_to from UNTARTAB where FLG_REM<>1 and HS6_COD=?  and TAR_PR1=?  and TAR_PR2=?  order by valid_from 
Start Date : Wed Jan 01 00:00:00 AST 1997
End Date : Thu Jan 01 00:00:00 AST 2009
Start Date : Thu Jan 01 00:00:00 AST 2009
End Date : Sun Oct 13 00:00:00 AST 2013
Start Date : Mon Oct 14 00:00:00 AST 2013
End Date : Sun Feb 15 00:00:00 AST 2015
Start Date : Sun Feb 15 00:00:00 AST 2015
End Date : Mon May 01 00:00:00 AST 2017
Start Date : Mon May 01 00:00:00 AST 2017
End Date : Tue Jun 01 00:00:00 AST 2021
Start Date : Tue Jun 01 00:00:00 AST 2021
End Date : null

{22-04-07 13:07:19} Error: GCFServerBinder.rollbackTransaction: The document is NOT locked
This is not an ex-warehose declaration
This is not a credit declaration
[22-04-07 13:07:22] ***********************R_doTaxation started*******************
[22-04-07 13:07:22] ### R_doTaxation executed ### 
Is aref  false
JAVA PARSER : false
working date Thu Apr 07 00:00:00 AST 2022
working date Thu Apr 07 00:00:00 AST 2022
itm count 1
Total docs 0
Old inlisttar()
Old inlisttar()
Old inlisttar()
Old inlisttar()
Old inlisttar()
Old inlisttar()
Old inlisttar()
Is aref  false
[22-04-07 13:07:22] ***********************R_doTaxation FINISHED*******************
[22-04-07 13:07:22] Set registration serial:2022 VCCHQ C1698
Flags falseFlags false
[22-04-07 13:07:22] Set assessment serial:2022 VCCHQ L1698
[22-04-07 13:07:22] Event Id : 1289
[22-04-07 13:07:22] Event Id : 1289
[22-04-07 13:07:22] Start ReqNum: 1412
[22-04-07 13:07:22] gtx_sds.countDocuments() = 0
SR_OPERATION ADDING RESULT 
docs == null
[22-04-07 13:07:25] ERROR: LCT = null class un.broker.asysad.server.printing.Print_Sad
SR_GetSSADPermission:  owner: 
[22-04-07 13:07:28] Don't use Bureau interface
The tex watermark is added to the image.
The tex watermark is added to the image.
SELECT 
SAD_GENERAL_SEGMENT.WHS_COD,
UNWHSTAB.WHS_NAM,
SAD_GENERAL_SEGMENT.CMP_CON_COD AS CMP_COD,
IMPCMP.CMP_NAM AS CMP_NAM,
SAD_GENERAL_SEGMENT.IDE_REG_DAT,
SAD_GENERAL_SEGMENT.IDE_TYP_SAD,
SAD_GENERAL_SEGMENT.IDE_TYP_PRC,
SAD_GENERAL_SEGMENT.IDE_REG_SER,
SAD_GENERAL_SEGMENT.IDE_REG_NBR,
SAD_GENERAL_SEGMENT.DEC_COD AS KEY_DEC,
SAD_GENERAL_SEGMENT.DEC_REF_YER AS KEY_YEAR,
SAD_GENERAL_SEGMENT.DEC_REF_NBR AS KEY_NBER,
SAD_GENERAL_SEGMENT.IDE_CUO_COD AS KEY_CUO,
SAD_GENERAL_SEGMENT.PTY_NBR_ITM AS TOT_ITEM,
PRV_SAD_TRANSACTIONS.DOC_REF,
SAD_ITEM.KEY_ITM_NBR,
SAD_ITEM.TAR_HSC_NB1 AS HSC_COD,
SAD_ITEM.TAR_HSC_NB2 || ' ' || SAD_ITEM.TAR_HSC_NB5 AS HSC_COD2,
TO_CHAR(SAD_ITEM.GDS_DSC) AS TAR_DSC,
SAD_ITEM.GDS_ORG_CTY AS CTY_COD,
PRV_SAD_TRANSACTIONS.DOC_OPE_DAT AS OUTDAT,
PRV_SAD_TRANSACTIONS.DOC_INSTANCE_ID AS DOC_REF_ID,
PRV_SAD_TRANSACTIONS.DOC_TYP
FROM PRV_SAD_TAB
INNER JOIN PRV_SAD_GDS ON PRV_SAD_TAB.INSTANCE_ID = PRV_SAD_GDS.INSTANCE_ID
INNER JOIN PRV_SAD_TRANSACTIONS ON PRV_SAD_TRANSACTIONS.INSTANCE_ID = PRV_SAD_TAB.INSTANCE_ID AND PRV_SAD_GDS.SAD_ITEM_NBR = PRV_SAD_TRANSACTIONS.SAD_ITEM_NBR AND PRV_SAD_GDS.HSC_COD = PRV_SAD_TRANSACTIONS.HSC_COD AND PRV_SAD_GDS.CTY_COD = PRV_SAD_TRANSACTIONS.CTY_COD
INNER JOIN SAD_GENERAL_SEGMENT ON PRV_SAD_TAB.SAD_INSTANCE_ID = SAD_GENERAL_SEGMENT.INSTANCEID
INNER JOIN SAD_ITEM ON SAD_GENERAL_SEGMENT.INSTANCEID = SAD_ITEM.INSTANCEID AND PRV_SAD_GDS.SAD_ITEM_NBR = SAD_ITEM.KEY_ITM_NBR
LEFT JOIN SAD_SUPPLEMENTARY_UNIT ON SAD_ITEM.INSTANCEID = SAD_SUPPLEMENTARY_UNIT.INSTANCEID AND SAD_ITEM.KEY_ITM_NBR = SAD_SUPPLEMENTARY_UNIT.KEY_ITM_NBR AND SAD_SUPPLEMENTARY_UNIT.KEY_SUP_RNK = 1
LEFT JOIN UNCP4TAB ON SAD_ITEM.TAR_PRC_EXT = UNCP4TAB.CP4_COD AND UNCP4TAB.VALID_FROM <= SAD_GENERAL_SEGMENT.IDE_REG_DAT AND (UNCP4TAB.VALID_TO IS NULL OR UNCP4TAB.VALID_TO > SAD_GENERAL_SEGMENT.IDE_REG_DAT)
LEFT JOIN UNCMPTAB IMPCMP ON SAD_GENERAL_SEGMENT.CMP_CON_COD = IMPCMP.CMP_COD AND IMPCMP.VALID_FROM <= SAD_GENERAL_SEGMENT.IDE_REG_DAT AND (IMPCMP.VALID_TO IS NULL OR IMPCMP.VALID_TO > SAD_GENERAL_SEGMENT.IDE_REG_DAT)
LEFT JOIN UNWHSTAB ON SAD_GENERAL_SEGMENT.WHS_COD = UNWHSTAB.WHS_COD AND UNWHSTAB.VALID_FROM <= SAD_GENERAL_SEGMENT.IDE_REG_DAT AND (UNWHSTAB.VALID_TO IS NULL OR UNWHSTAB.VALID_TO > SAD_GENERAL_SEGMENT.IDE_REG_DAT)

WHERE
BITAND(PRV_SAD_TAB.INDICATOR,2) = 0 -- // SAD not cancelled
AND BITAND(PRV_SAD_GDS.INDICATOR,4) = 4 -- Goods ara active
--AND PRV_SAD_TRANSACTIONS.DOC_INSTANCE_ID <> SAD_GENERAL_SEGMENT.INSTANCEID
AND PRV_SAD_TRANSACTIONS.TRANSACTION_RNK = 
(
SELECT MAX(P.TRANSACTION_RNK) FROM PRV_SAD_TRANSACTIONS P WHERE 
P.INSTANCE_ID = PRV_SAD_TRANSACTIONS.INSTANCE_ID AND P.SAD_ITEM_NBR = PRV_SAD_TRANSACTIONS.SAD_ITEM_NBR AND P.HSC_COD = PRV_SAD_TRANSACTIONS.HSC_COD AND P.CTY_COD = PRV_SAD_TRANSACTIONS.CTY_COD
)
 AND PRV_SAD_GDS.ACT_COD IN ('77','07') AND ((PRV_SAD_GDS.QTY_SUP > 0 AND PRV_SAD_TRANSACTIONS.REM_SUP <= 0) OR (PRV_SAD_GDS.QTY_SUP <= 0 AND PRV_SAD_TRANSACTIONS.REM_WGT <= 0)) AND SAD_GENERAL_SEGMENT.WHS_COD = 'S0002624'
Flags falseFlags false
[22-04-07 13:07:34] Criteria expected 100.0:0.0:0.0:0.0
[22-04-07 13:07:34] Selectivity :params not found !!
[22-04-07 13:07:34]  color out of criteria 
[22-04-07 13:07:34] Red
[22-04-07 13:07:34] 
 size of selparams 0
[22-04-07 13:07:34]  color out of max hits params 
[22-04-07 13:07:34] Red
[22-04-07 13:07:34] 
Totals: 
[22-04-07 13:07:34] 0:
[22-04-07 13:07:34] 0:
[22-04-07 13:07:34] 2:
[22-04-07 13:07:34] 188:
[22-04-07 13:07:34] 

[22-04-07 13:07:34]  item 1 criterion HIGHRISK
[22-04-07 13:07:34]  color 
[22-04-07 13:07:34] Red
[22-04-07 13:07:34] 
[22-04-07 13:07:34] Final Color : 3
[22-04-07 13:07:34] Updating DB.
 checking other administrations selectivity 
No Manifest used for this declaration. Therefore, item release order is being generated
The tex watermark is added to the image.
[22-04-07 13:07:36] Scan Doc Date Criteria = Thu Apr 07 00:00:00 AST 2022
[22-04-07 13:07:36] No Scan documents found for:P0002005 IV05 LC 05 Thu Apr 07 00:00:00 AST 2022
[Handled exception] ErrorCode: 17008 | SQLState: 08003
Can not access database! Try to reconnect...
Create new connection...		OK
[22-04-07 13:07:38] Committing: 0 0
[22-04-07 13:07:40] Don't use Bureau interface
This is not an ex-warehose declaration
This is not a credit declaration
[22-04-07 13:07:52] ***********************R_doTaxation started*******************
[22-04-07 13:07:52] ### R_doTaxation executed ### 
Is aref  false
JAVA PARSER : false
working date Thu Apr 07 00:00:00 AST 2022
working date Thu Apr 07 00:00:00 AST 2022
itm count 73
Total docs 0
Old inlisttar()
Old inlisttar()
Total docs 0
Old inlisttar()
Old inlisttar()
Total docs 0
Old inlisttar()
Old inlisttar()
Total docs 0
Old inlisttar()
Old inlisttar()
Total docs 0
Old inlisttar()
Old inlisttar()
Total docs 0
Old inlisttar()
Old inlisttar()
Total docs 0
Old inlisttar()
Old inlisttar()
Total docs 0
Old inlisttar()
Old inlisttar()
Total docs 0
Old inlisttar()
Old inlisttar()
Total docs 0
Old inlisttar()
Old inlisttar()
Total docs 0
Old inlisttar()
Old inlisttar()
Total docs 0
Old inlisttar()
Old inlisttar()
Total docs 0
Old inlisttar()
Old inlisttar()
Total docs 0
Old inlisttar()
Old inlisttar()
Total docs 0
Old inlisttar()
Old inlisttar()
Total docs 0
Old inlisttar()
Old inlisttar()
Total docs 0
Old inlisttar()
Old inlisttar()
Total docs 0
Old inlisttar()
Old inlisttar()
Total docs 0
Old inlisttar()
Old inlisttar()
Total docs 0
Old inlisttar()
Old inlisttar()
Total docs 0
Old inlisttar()
Old inlisttar()
Total docs 0
Old inlisttar()
Old inlisttar()
Total docs 0
Old inlisttar()
Old inlisttar()
Total docs 0
Old inlisttar()
Old inlisttar()
Total docs 0
Old inlisttar()
Old inlisttar()
Total docs 0
Old inlisttar()
Old inlisttar()
Total docs 0
Old inlisttar()
Old inlisttar()
Total docs 0
Old inlisttar()
Old inlisttar()
Total docs 0
Old inlisttar()
Old inlisttar()
Total docs 0
Old inlisttar()
Old inlisttar()
Total docs 0
Old inlisttar()
Old inlisttar()
Total docs 0
Old inlisttar()
Old inlisttar()
Total docs 0
Old inlisttar()
Old inlisttar()
Total docs 0
Old inlisttar()
Old inlisttar()
Total docs 0
Old inlisttar()
Old inlisttar()
Total docs 0
Old inlisttar()
Old inlisttar()
Total docs 0
Old inlisttar()
Old inlisttar()
Total docs 0
Old inlisttar()
Old inlisttar()
Total docs 0
Old inlisttar()
Old inlisttar()
Total docs 0
Old inlisttar()
Old inlisttar()
Total docs 0
Old inlisttar()
Old inlisttar()
Total docs 0
Old inlisttar()
Old inlisttar()
Total docs 0
Old inlisttar()
Old inlisttar()
Total docs 0
Old inlisttar()
Old inlisttar()
Total docs 0
Old inlisttar()
Old inlisttar()
Total docs 0
Old inlisttar()
Old inlisttar()
Total docs 0
Old inlisttar()
Old inlisttar()
Total docs 0
Old inlisttar()
Old inlisttar()
Total docs 0
Old inlisttar()
Old inlisttar()
Total docs 0
Old inlisttar()
Old inlisttar()
Total docs 0
Old inlisttar()
Old inlisttar()
Total docs 0
Old inlisttar()
Old inlisttar()
Total docs 0
Old inlisttar()
Old inlisttar()
Total docs 0
Old inlisttar()
Old inlisttar()
Total docs 0
Old inlisttar()
Old inlisttar()
Total docs 0
Old inlisttar()
Old inlisttar()
Total docs 0
Old inlisttar()
Old inlisttar()
Total docs 0
Old inlisttar()
Old inlisttar()
Total docs 0
Old inlisttar()
Old inlisttar()
Total docs 0
Old inlisttar()
Old inlisttar()
Total docs 0
Old inlisttar()
Old inlisttar()
Total docs 0
Old inlisttar()
Old inlisttar()
Total docs 0
Old inlisttar()
Old inlisttar()
Total docs 0
Old inlisttar()
Old inlisttar()
Total docs 0
Old inlisttar()
Old inlisttar()
Total docs 0
Old inlisttar()
Old inlisttar()
Total docs 0
Old inlisttar()
Old inlisttar()
Total docs 0
Old inlisttar()
Old inlisttar()
Total docs 0
Old inlisttar()
Old inlisttar()
Total docs 0
Old inlisttar()
Old inlisttar()
Total docs 0
Old inlisttar()
Old inlisttar()
Total docs 0
Old inlisttar()
Old inlisttar()
Total docs 0
Old inlisttar()
Old inlisttar()
Is aref  false
[22-04-07 13:07:55] ***********************R_doTaxation FINISHED*******************
[22-04-07 13:07:55] Set registration serial:2022 VCAIA C2014
Flags falseFlags false
[22-04-07 13:07:55] Criteria expected 0.0:100.0:0.0:0.0
[22-04-07 13:07:55]  code[0] = EXPDOCCHK color 
[22-04-07 13:07:55] Yellow
[22-04-07 13:07:55] 
[22-04-07 13:07:55]  code[0] = EXPDOCCHK color 
[22-04-07 13:07:55] Yellow
[22-04-07 13:07:55] 
[22-04-07 13:07:55]  code[0] = EXPDOCCHK color 
[22-04-07 13:07:55] Yellow
[22-04-07 13:07:55] 
[22-04-07 13:07:55]  code[0] = EXPDOCCHK color 
[22-04-07 13:07:55] Yellow
[22-04-07 13:07:55] 
[22-04-07 13:07:55]  code[0] = EXPDOCCHK color 
[22-04-07 13:07:55] Yellow
[22-04-07 13:07:55] 
[22-04-07 13:07:55]  code[0] = EXPDOCCHK color 
[22-04-07 13:07:55] Yellow
[22-04-07 13:07:55] 
[22-04-07 13:07:55]  code[0] = EXPDOCCHK color 
[22-04-07 13:07:55] Yellow
[22-04-07 13:07:55] 
[22-04-07 13:07:55]  code[0] = EXPDOCCHK color 
[22-04-07 13:07:55] Yellow
[22-04-07 13:07:55] 
[22-04-07 13:07:55]  code[0] = EXPDOCCHK color 
[22-04-07 13:07:55] Yellow
[22-04-07 13:07:55] 
[22-04-07 13:07:55]  code[0] = EXPDOCCHK color 
[22-04-07 13:07:55] Yellow
[22-04-07 13:07:55] 
[22-04-07 13:07:55]  code[0] = EXPDOCCHK color 
[22-04-07 13:07:55] Yellow
[22-04-07 13:07:55] 
[22-04-07 13:07:55]  code[0] = EXPDOCCHK color 
[22-04-07 13:07:55] Yellow
[22-04-07 13:07:55] 
[22-04-07 13:07:55]  code[0] = EXPDOCCHK color 
[22-04-07 13:07:55] Yellow
[22-04-07 13:07:55] 
[22-04-07 13:07:55]  code[0] = EXPDOCCHK color 
[22-04-07 13:07:55] Yellow
[22-04-07 13:07:55] 
[22-04-07 13:07:55]  code[0] = EXPDOCCHK color 
[22-04-07 13:07:55] Yellow
[22-04-07 13:07:55] 
[22-04-07 13:07:55]  code[0] = EXPDOCCHK color 
[22-04-07 13:07:55] Yellow
[22-04-07 13:07:55] 
[22-04-07 13:07:55]  code[0] = EXPDOCCHK color 
[22-04-07 13:07:55] Yellow
[22-04-07 13:07:55] 
[22-04-07 13:07:55]  code[0] = EXPDOCCHK color 
[22-04-07 13:07:55] Yellow
[22-04-07 13:07:55] 
[22-04-07 13:07:55]  code[0] = EXPDOCCHK color 
[22-04-07 13:07:55] Yellow
[22-04-07 13:07:55] 
[22-04-07 13:07:55]  code[0] = EXPDOCCHK color 
[22-04-07 13:07:55] Yellow
[22-04-07 13:07:55] 
[22-04-07 13:07:55]  code[0] = EXPDOCCHK color 
[22-04-07 13:07:55] Yellow
[22-04-07 13:07:55] 
[22-04-07 13:07:55]  code[0] = EXPDOCCHK color 
[22-04-07 13:07:55] Yellow
[22-04-07 13:07:55] 
[22-04-07 13:07:55]  code[0] = EXPDOCCHK color 
[22-04-07 13:07:55] Yellow
[22-04-07 13:07:55] 
[22-04-07 13:07:55]  code[0] = EXPDOCCHK color 
[22-04-07 13:07:55] Yellow
[22-04-07 13:07:55] 
[22-04-07 13:07:55]  code[0] = EXPDOCCHK color 
[22-04-07 13:07:55] Yellow
[22-04-07 13:07:55] 
[22-04-07 13:07:55]  code[0] = EXPDOCCHK color 
[22-04-07 13:07:55] Yellow
[22-04-07 13:07:55] 
[22-04-07 13:07:55]  code[0] = EXPDOCCHK color 
[22-04-07 13:07:55] Yellow
[22-04-07 13:07:55] 
[22-04-07 13:07:55]  code[0] = EXPDOCCHK color 
[22-04-07 13:07:55] Yellow
[22-04-07 13:07:55] 
[22-04-07 13:07:55]  code[0] = EXPDOCCHK color 
[22-04-07 13:07:55] Yellow
[22-04-07 13:07:55] 
[22-04-07 13:07:55]  code[0] = EXPDOCCHK color 
[22-04-07 13:07:55] Yellow
[22-04-07 13:07:55] 
[22-04-07 13:07:55]  code[0] = EXPDOCCHK color 
[22-04-07 13:07:55] Yellow
[22-04-07 13:07:55] 
[22-04-07 13:07:55]  code[0] = EXPDOCCHK color 
[22-04-07 13:07:55] Yellow
[22-04-07 13:07:55] 
[22-04-07 13:07:55]  code[0] = EXPDOCCHK color 
[22-04-07 13:07:55] Yellow
[22-04-07 13:07:55] 
[22-04-07 13:07:55]  code[0] = EXPDOCCHK color 
[22-04-07 13:07:55] Yellow
[22-04-07 13:07:55] 
[22-04-07 13:07:55]  code[0] = EXPDOCCHK color 
[22-04-07 13:07:55] Yellow
[22-04-07 13:07:55] 
[22-04-07 13:07:55]  code[0] = EXPDOCCHK color 
[22-04-07 13:07:55] Yellow
[22-04-07 13:07:55] 
[22-04-07 13:07:55]  code[0] = EXPDOCCHK color 
[22-04-07 13:07:55] Yellow
[22-04-07 13:07:55] 
[22-04-07 13:07:55]  code[0] = EXPDOCCHK color 
[22-04-07 13:07:55] Yellow
[22-04-07 13:07:55] 
[22-04-07 13:07:55]  code[0] = EXPDOCCHK color 
[22-04-07 13:07:55] Yellow
[22-04-07 13:07:55] 
[22-04-07 13:07:55]  code[0] = EXPDOCCHK color 
[22-04-07 13:07:55] Yellow
[22-04-07 13:07:55] 
[22-04-07 13:07:55]  code[0] = EXPDOCCHK color 
[22-04-07 13:07:55] Yellow
[22-04-07 13:07:55] 
[22-04-07 13:07:55]  code[0] = EXPDOCCHK color 
[22-04-07 13:07:55] Yellow
[22-04-07 13:07:55] 
[22-04-07 13:07:55]  code[0] = EXPDOCCHK color 
[22-04-07 13:07:55] Yellow
[22-04-07 13:07:55] 
[22-04-07 13:07:55]  code[0] = EXPDOCCHK color 
[22-04-07 13:07:55] Yellow
[22-04-07 13:07:55] 
[22-04-07 13:07:55]  code[0] = EXPDOCCHK color 
[22-04-07 13:07:55] Yellow
[22-04-07 13:07:55] 
[22-04-07 13:07:55]  code[0] = EXPDOCCHK color 
[22-04-07 13:07:55] Yellow
[22-04-07 13:07:55] 
[22-04-07 13:07:55]  code[0] = EXPDOCCHK color 
[22-04-07 13:07:55] Yellow
[22-04-07 13:07:55] 
[22-04-07 13:07:55]  code[0] = EXPDOCCHK color 
[22-04-07 13:07:55] Yellow
[22-04-07 13:07:55] 
[22-04-07 13:07:55]  code[0] = EXPDOCCHK color 
[22-04-07 13:07:55] Yellow
[22-04-07 13:07:55] 
[22-04-07 13:07:55]  code[0] = EXPDOCCHK color 
[22-04-07 13:07:55] Yellow
[22-04-07 13:07:55] 
[22-04-07 13:07:55]  code[0] = EXPDOCCHK color 
[22-04-07 13:07:55] Yellow
[22-04-07 13:07:55] 
[22-04-07 13:07:55]  code[0] = EXPDOCCHK color 
[22-04-07 13:07:55] Yellow
[22-04-07 13:07:55] 
[22-04-07 13:07:55]  code[0] = EXPDOCCHK color 
[22-04-07 13:07:55] Yellow
[22-04-07 13:07:55] 
[22-04-07 13:07:55]  code[0] = EXPDOCCHK color 
[22-04-07 13:07:55] Yellow
[22-04-07 13:07:55] 
[22-04-07 13:07:55]  code[0] = EXPDOCCHK color 
[22-04-07 13:07:55] Yellow
[22-04-07 13:07:55] 
[22-04-07 13:07:55]  code[0] = EXPDOCCHK color 
[22-04-07 13:07:55] Yellow
[22-04-07 13:07:55] 
[22-04-07 13:07:55]  code[0] = EXPDOCCHK color 
[22-04-07 13:07:55] Yellow
[22-04-07 13:07:55] 
[22-04-07 13:07:55]  code[0] = EXPDOCCHK color 
[22-04-07 13:07:55] Yellow
[22-04-07 13:07:55] 
[22-04-07 13:07:55]  code[0] = EXPDOCCHK color 
[22-04-07 13:07:55] Yellow
[22-04-07 13:07:55] 
[22-04-07 13:07:55]  code[0] = EXPDOCCHK color 
[22-04-07 13:07:55] Yellow
[22-04-07 13:07:55] 
[22-04-07 13:07:55]  code[0] = EXPDOCCHK color 
[22-04-07 13:07:55] Yellow
[22-04-07 13:07:55] 
[22-04-07 13:07:55]  code[0] = EXPDOCCHK color 
[22-04-07 13:07:55] Yellow
[22-04-07 13:07:55] 
[22-04-07 13:07:55]  code[0] = EXPDOCCHK color 
[22-04-07 13:07:55] Yellow
[22-04-07 13:07:55] 
[22-04-07 13:07:55]  code[0] = EXPDOCCHK color 
[22-04-07 13:07:55] Yellow
[22-04-07 13:07:55] 
[22-04-07 13:07:55]  code[0] = EXPDOCCHK color 
[22-04-07 13:07:55] Yellow
[22-04-07 13:07:55] 
[22-04-07 13:07:55]  code[0] = EXPDOCCHK color 
[22-04-07 13:07:55] Yellow
[22-04-07 13:07:55] 
[22-04-07 13:07:55]  code[0] = EXPDOCCHK color 
[22-04-07 13:07:55] Yellow
[22-04-07 13:07:55] 
[22-04-07 13:07:55]  code[0] = EXPDOCCHK color 
[22-04-07 13:07:55] Yellow
[22-04-07 13:07:55] 
[22-04-07 13:07:55]  code[0] = EXPDOCCHK color 
[22-04-07 13:07:55] Yellow
[22-04-07 13:07:55] 
[22-04-07 13:07:55]  code[0] = EXPDOCCHK color 
[22-04-07 13:07:55] Yellow
[22-04-07 13:07:55] 
[22-04-07 13:07:55]  code[0] = EXPDOCCHK color 
[22-04-07 13:07:55] Yellow
[22-04-07 13:07:55] 
[22-04-07 13:07:55]  code[0] = EXPDOCCHK color 
[22-04-07 13:07:55] Yellow
[22-04-07 13:07:55] 
[22-04-07 13:07:55]  code[0] = EXPDOCCHK color 
[22-04-07 13:07:55] Yellow
[22-04-07 13:07:55] 
[22-04-07 13:07:55] Selectivity :params not found !!
[22-04-07 13:07:55]  color out of criteria 
[22-04-07 13:07:55] Yellow
[22-04-07 13:07:55] 
 size of selparams 0
[22-04-07 13:07:55]  color out of max hits params 
[22-04-07 13:07:55] Yellow
[22-04-07 13:07:55] 
Totals: 
[22-04-07 13:07:55] 22:
[22-04-07 13:07:55] 15:
[22-04-07 13:07:55] 107:
[22-04-07 13:07:55] 108:
[22-04-07 13:07:55] 

[22-04-07 13:07:55]  item 0 criterion EXPDOCCHK
[22-04-07 13:07:55]  color 
[22-04-07 13:07:55] Yellow
[22-04-07 13:07:55] 
[22-04-07 13:07:55] Final Color : 2
[22-04-07 13:07:55] Updating DB.
[22-04-07 13:07:55] Set assessment serial:2022 VCAIA L2014
[22-04-07 13:07:55] Event Id : 1289
[22-04-07 13:07:55] Event Id : 1289
[22-04-07 13:07:55] Start ReqNum: 1412
[22-04-07 13:07:55] gtx_sds.countDocuments() = 0
SR_OPERATION ADDING RESULT 
docs == null
select valid_from, valid_to from UNTARTAB where FLG_REM<>1 and HS6_COD=?  and TAR_PR1=?  and ( TAR_PR2 like ?  or TAR_PR2 like ?  )  order by valid_from 
Start Date : Wed Jan 01 00:00:00 AST 1997
End Date : Thu Jan 01 00:00:00 AST 2009
Start Date : Thu Jan 01 00:00:00 AST 2009
End Date : Sun Oct 13 00:00:00 AST 2013
Start Date : Mon Oct 14 00:00:00 AST 2013
End Date : Sun Feb 15 00:00:00 AST 2015
Start Date : Sun Feb 15 00:00:00 AST 2015
End Date : Mon May 01 00:00:00 AST 2017
Start Date : Mon May 01 00:00:00 AST 2017
End Date : Tue Jun 01 00:00:00 AST 2021
Start Date : Tue Jun 01 00:00:00 AST 2021
End Date : null
[22-04-07 13:08:13] ERROR: LCT = null class un.broker.asysad.server.printing.Print_Sad
[22-04-07 13:08:15] Don't use Bureau interface
[Handled exception] ErrorCode: 17008 | SQLState: 08003
Can not access database! Try to reconnect...
Create new connection...		OK
[22-04-07 13:08:25] Scan Doc Date Criteria = Thu Apr 07 00:00:00 AST 2022
[22-04-07 13:08:25] Number of documents found = 1
SELECT 
SAD_GENERAL_SEGMENT.WHS_COD,
UNWHSTAB.WHS_NAM,
SAD_GENERAL_SEGMENT.CMP_CON_COD AS CMP_COD,
IMPCMP.CMP_NAM AS CMP_NAM,
SAD_GENERAL_SEGMENT.IDE_REG_DAT,
SAD_GENERAL_SEGMENT.IDE_TYP_SAD,
SAD_GENERAL_SEGMENT.IDE_TYP_PRC,
SAD_GENERAL_SEGMENT.IDE_REG_SER,
SAD_GENERAL_SEGMENT.IDE_REG_NBR,
SAD_GENERAL_SEGMENT.DEC_COD AS KEY_DEC,
SAD_GENERAL_SEGMENT.DEC_REF_YER AS KEY_YEAR,
SAD_GENERAL_SEGMENT.DEC_REF_NBR AS KEY_NBER,
SAD_GENERAL_SEGMENT.IDE_CUO_COD AS KEY_CUO,
PRV_SAD_TAB.EXPIRATION_DATE AS END_DAT,
SAD_ITEM.KEY_ITM_NBR,
SAD_ITEM.TAR_HSC_NB1 AS HSC_COD,
SAD_ITEM.TAR_HSC_NB2 || ' ' || SAD_ITEM.TAR_HSC_NB5 AS HSC_COD2,
TO_CHAR(SAD_ITEM.GDS_DSC) AS TAR_DSC,
SAD_ITEM.GDS_ORG_CTY AS CTY_COD,
PRV_SAD_GDS.QTY_WGT AS WGT_BEG,
PRV_SAD_GDS.QTY_SUP AS SUP_BEG,
PRV_SAD_TRANSACTIONS.REM_SUP,
PRV_SAD_TRANSACTIONS.REM_WGT,
SAD_SUPPLEMENTARY_UNIT.TAR_SUP_COD,
UNCTYTAB.CTY_DSC AS CTY_NAM,
PRV_SAD_TAB.EXPIRATION_DATE AS WHS_TIM
FROM PRV_SAD_TAB
INNER JOIN PRV_SAD_GDS ON PRV_SAD_TAB.INSTANCE_ID = PRV_SAD_GDS.INSTANCE_ID
INNER JOIN PRV_SAD_TRANSACTIONS ON PRV_SAD_TRANSACTIONS.INSTANCE_ID = PRV_SAD_TAB.INSTANCE_ID AND PRV_SAD_GDS.SAD_ITEM_NBR = PRV_SAD_TRANSACTIONS.SAD_ITEM_NBR AND PRV_SAD_GDS.HSC_COD = PRV_SAD_TRANSACTIONS.HSC_COD AND PRV_SAD_GDS.CTY_COD = PRV_SAD_TRANSACTIONS.CTY_COD
INNER JOIN SAD_GENERAL_SEGMENT ON PRV_SAD_TAB.SAD_INSTANCE_ID = SAD_GENERAL_SEGMENT.INSTANCEID
INNER JOIN SAD_ITEM ON SAD_GENERAL_SEGMENT.INSTANCEID = SAD_ITEM.INSTANCEID AND PRV_SAD_GDS.SAD_ITEM_NBR = SAD_ITEM.KEY_ITM_NBR
LEFT JOIN UNCTYTAB ON SAD_ITEM.GDS_ORG_CTY = UNCTYTAB.CTY_COD AND UNCTYTAB.VALID_FROM <= SAD_GENERAL_SEGMENT.IDE_REG_DAT AND (UNCTYTAB.VALID_TO IS NULL OR UNCTYTAB.VALID_TO > SAD_GENERAL_SEGMENT.IDE_REG_DAT)
LEFT JOIN SAD_SUPPLEMENTARY_UNIT ON SAD_ITEM.INSTANCEID = SAD_SUPPLEMENTARY_UNIT.INSTANCEID AND SAD_ITEM.KEY_ITM_NBR = SAD_SUPPLEMENTARY_UNIT.KEY_ITM_NBR AND SAD_SUPPLEMENTARY_UNIT.KEY_SUP_RNK = 1
LEFT JOIN UNCP4TAB ON SAD_ITEM.TAR_PRC_EXT = UNCP4TAB.CP4_COD AND UNCP4TAB.VALID_FROM <= SAD_GENERAL_SEGMENT.IDE_REG_DAT AND (UNCP4TAB.VALID_TO IS NULL OR UNCP4TAB.VALID_TO > SAD_GENERAL_SEGMENT.IDE_REG_DAT)
LEFT JOIN UNCMPTAB IMPCMP ON SAD_GENERAL_SEGMENT.CMP_CON_COD = IMPCMP.CMP_COD AND IMPCMP.VALID_FROM <= SAD_GENERAL_SEGMENT.IDE_REG_DAT AND (IMPCMP.VALID_TO IS NULL OR IMPCMP.VALID_TO > SAD_GENERAL_SEGMENT.IDE_REG_DAT)
LEFT JOIN UNWHSTAB ON SAD_GENERAL_SEGMENT.WHS_COD = UNWHSTAB.WHS_COD AND UNWHSTAB.VALID_FROM <= SAD_GENERAL_SEGMENT.IDE_REG_DAT AND (UNWHSTAB.VALID_TO IS NULL OR UNWHSTAB.VALID_TO > SAD_GENERAL_SEGMENT.IDE_REG_DAT)

WHERE
BITAND(PRV_SAD_TAB.INDICATOR,2) = 0 -- // SAD not cancelled
AND BITAND(PRV_SAD_GDS.INDICATOR,4) = 4 -- Goods are active
AND PRV_SAD_TRANSACTIONS.TRANSACTION_RNK = 
(
SELECT MAX(P.TRANSACTION_RNK) FROM PRV_SAD_TRANSACTIONS P WHERE 
P.INSTANCE_ID = PRV_SAD_TRANSACTIONS.INSTANCE_ID AND P.SAD_ITEM_NBR = PRV_SAD_TRANSACTIONS.SAD_ITEM_NBR AND P.HSC_COD = PRV_SAD_TRANSACTIONS.HSC_COD AND P.CTY_COD = PRV_SAD_TRANSACTIONS.CTY_COD
)
 AND PRV_SAD_GDS.ACT_COD IN ('77','07') AND ((PRV_SAD_GDS.QTY_SUP > 0 AND PRV_SAD_TRANSACTIONS.REM_SUP > 0) OR (PRV_SAD_GDS.QTY_SUP <= 0 AND PRV_SAD_TRANSACTIONS.REM_WGT > 0)) AND SAD_GENERAL_SEGMENT.WHS_COD = 'S0002624' AND PRV_SAD_TAB.EXPIRATION_DATE >= TO_DATE('07-APR-2022', 'DD-MON-YYYY', 'nls_date_language = American')
select valid_from, valid_to from UNHS4TAB where FLG_REM<>1 and HS4_COD=?  order by valid_from 
Start Date : Sat Jan 01 00:00:00 AST 2000
End Date : null
This is not an ex-warehose declaration
This is not a credit declaration
[22-04-07 13:08:33] ***********************R_doTaxation started*******************
[22-04-07 13:08:33] ### R_doTaxation executed ### 
Is aref  false
JAVA PARSER : false
working date Thu Apr 07 00:00:00 AST 2022
working date Thu Apr 07 00:00:00 AST 2022
itm count 6
Total docs 1
Rule att 
Old inlisttar()
Old inlisttar()
Total docs 0
Old inlisttar()
Old inlisttar()
Total docs 0
Old inlisttar()
Old inlisttar()
Total docs 0
Old inlisttar()
Old inlisttar()
Total docs 0
Old inlisttar()
Old inlisttar()
Total docs 0
Old inlisttar()
Old inlisttar()
Is aref  false
[22-04-07 13:08:33] ***********************R_doTaxation FINISHED*******************
[22-04-07 13:08:33] Set registration serial:2022 VCKTN C8215
Flags falseFlags false
[22-04-07 13:08:33] Criteria expected 0.0:100.0:0.0:0.0
[22-04-07 13:08:33]  code[0] = EXPDOCCHK color 
[22-04-07 13:08:33] Yellow
[22-04-07 13:08:33] 
[22-04-07 13:08:33]  code[0] = EXPDOCCHK color 
[22-04-07 13:08:33] Yellow
[22-04-07 13:08:33] 
[22-04-07 13:08:33]  code[0] = EXPDOCCHK color 
[22-04-07 13:08:33] Yellow
[22-04-07 13:08:33] 
[22-04-07 13:08:33]  code[0] = EXPDOCCHK color 
[22-04-07 13:08:33] Yellow
[22-04-07 13:08:33] 
[22-04-07 13:08:33]  code[0] = EXPDOCCHK color 
[22-04-07 13:08:33] Yellow
[22-04-07 13:08:33] 
[22-04-07 13:08:33]  code[0] = EXPDOCCHK color 
[22-04-07 13:08:33] Yellow
[22-04-07 13:08:33] 
[22-04-07 13:08:33] Selectivity :params not found !!
[22-04-07 13:08:33]  color out of criteria 
[22-04-07 13:08:33] Yellow
[22-04-07 13:08:33] 
 size of selparams 0
[22-04-07 13:08:33]  color out of max hits params 
[22-04-07 13:08:33] Yellow
[22-04-07 13:08:33] 
Totals: 
[22-04-07 13:08:33] 32:
[22-04-07 13:08:33] 14:
[22-04-07 13:08:33] 287:
[22-04-07 13:08:33] 54:
[22-04-07 13:08:33] 

[22-04-07 13:08:33]  item 0 criterion EXPDOCCHK
[22-04-07 13:08:33]  color 
[22-04-07 13:08:33] Yellow
[22-04-07 13:08:33] 
[22-04-07 13:08:33] Final Color : 2
[22-04-07 13:08:33] Updating DB.
[22-04-07 13:08:33] Set assessment serial:2022 VCKTN L8215
[22-04-07 13:08:33] Event Id : 1289
[22-04-07 13:08:33] Event Id : 1289
[22-04-07 13:08:33] Start ReqNum: 1412
[22-04-07 13:08:33] gtx_sds.countDocuments() = 0
SR_OPERATION ADDING RESULT 
docs == null
select valid_from, valid_to from UNHS6TAB where FLG_REM<>1 and HS6_COD=?  order by valid_from 
Start Date : Sat Jan 01 00:00:00 AST 2000
End Date : null
[22-04-07 13:08:38] ERROR: LCT = null class un.broker.asysad.server.printing.Print_Sad
[22-04-07 13:08:41] Don't use Bureau interface
[Handled exception] ErrorCode: 17008 | SQLState: 08003
Can not access database! Try to reconnect...
Create new connection...		OK

{22-04-07 13:08:45} Error: GCFServerBinder.rollbackTransaction: The document is NOT locked