[步骤]
p_asin = 'B0CL9JTBLX'
API = bi/list/queryFbaVirtuaInventoryList
SQL：SELECT t1.* FROM t_amz_fba_virtual_inventory t1 JOIN t_amz_fba_virtual_inventory_country t2 ON t1.id = t2.virtual_id AND t1.customer_id = t2. customer_id WHERE t1.asin IN (SELECT asin FROM test_zhcxkj_center_bi.t_amz_product_performance_dim WHERE p_asin = 'B0CL9JTBLX') AND t1.is_deleted = 0 AND t1.fulfillment_country = 'US'
[结果]
返回的数据不应该只有一个来源渠道的明细数据[期望]
003-API =bi/list/queryFbaVirtuaInventoryList
003+ API =bi/list/queryFbaVirtuaInventoryList
003-<p><span style="font-size:18px;"><span style="font-size:14px;">API =</span><span style="color:#1F1F1F;">bi/list/queryFbaVirtuaInventoryList</span></span><span style="color:#1F1F1F;"></span></p>
003+ <p><span style="font-size:18px;"><span style="font-size:14px;">API =</span><span style="color:#1F1F1F;font-size:14px;">bi/list/queryFbaVirtuaInventoryList</span></span><span style="color:#1F1F1F;"></span></p>
001-【产品分析】超180天库龄产品信息数据返回异常
001+ 【产品表现】超180天库龄产品信息数据返回异常
001-【产品分析】超180天库龄产品信息数据返回异常
001+ 【产品表现】超180天库龄产品信息数据返回异常
| 所属项目 | 技术中心-需求池 |
|---|---|
| 所属模块 | / |
| 所属迭代 | 开发项目部 - 虎鲸BI - 迭代28 |
| Bug类型 | 程序BUG |
| 严重程度 | 提示 |
| 优先级 | P2 |
| Bug状态 | 已关闭 |
| 业务部门 | |
| 开发责任人 | |
| 测试责任人 | |
| 解决时效 | 0 |
| 激活次数 | 0 |
| 激活日期 | |
| 当前指派 | Closed 于 2024-01-30 23:42:19 |
| 截止日期 | 0000-00-00 |
| 上线时间 | |
| 上线时效 | |
| 关键词 | |
| 抄送给 |
| 所属迭代 | 开发项目部 - 虎鲸BI - 迭代28 |
|---|---|
| 相关需求 | |
| 相关任务 |
| 由谁创建 | 关依林 于 2023-12-28 14:30:21 |
|---|---|
| 影响环境 |
测试环境-测试反馈 |
| 由谁解决 | 林泓武 于 2023-12-28 15:27:37 |
| 解决版本 | |
| 解决方案 | 非BUG-纯属误判 |
| 由谁关闭 | 关依林 于 2024-01-30 23:42:19 |
| 最后修改 | 关依林 于 2024-01-30 23:42:19 |
| 相关Bug |
|---|
t2.virtual_id,t1.seller_id,t1.*
FROM
t_amz_fba_virtual_inventory t1
JOIN t_amz_fba_virtual_inventory_country t2 ON t1.id = t2.virtual_id
AND t1.customer_id = t2.customer_id
WHERE
(t2.source_id,t2.msku) IN (
(16307,'0G-KFT5-22YV'),
(16307,'74500MXZ15BG7P'),
(16307,'P65CC2584B15Z6'),
(16307,'UJW42MI90510HPIS0'),
(15883,'30BP1408WE2022TC'),
(15883,'FU-6KWB-B4YN'),
(15883,'PC-JQNG-XFFV'),
(15883,'Q4341FWBK11S'),
(15883,'T7DGH075317B3SF8'),
(15883,'U421112GBVN7'),
(15883,'UF3555T17CF'),
(19357,'18703580ZG2VELQ'),
(19357,'Q9-N7HH-R5SJ'),
(7727,'19WKV1M10IDKHJKL15BCH3F67'),
(7727,'XEAOSC528O01025EHJ4P4E4')
)
AND t1.is_deleted = 0
and t1.exist_child = 0
and t2.is_deleted = 0
and (t1.inventory_age_181_to_270_days > 0
OR t1.inventory_age_271_to_365_days > 0
OR t1.inventory_age_365_plus_days > 0 )