Datanory Production » Datanory - SUNTORY

Waiting for user upload database

hi ~Cris Neoh , Based on our checking from our side, we notice that all the setup for this promotion related tot this sales order are made in good manner.
from our side we suspect two possibilities:
1) the promotion could be disappeared during admin approve process
2) the promo could be miss when the admin do modification on that particular sales order.
Further action that has to be done:
1) for temporary workaround ~Joe requested to do patching the on the promotion on that particular product
2) Simulation
3) Escalate to technical team with the simulation finding.

Tomorrow Patching has to be done tomorrow

---------------------------------------------------------------------------------------------------------------------------------
select updated_date,* from txn_sales_order_header where order_no= 'SOSR03000198-240606' --2024-06-10 15:15:16.780
select * from txn_sales_order_details where ord_hdr_id= 'f2892860-81bb-45de-8fd4-540a30d37320' and product_id='53811206AAB04ED7AB65A6B23D1527E8'

--in di_table got promotion_ id
select * from di_mobile_txn_sales_orders where sales_orders_id= 'f2892860-81bb-45de-8fd4-540a30d37320'
select * from mobile_promotion_header where promotion_id= 'e49ed498ab0549feac44003f23aff6d6'

select * from product_item where item_id='53811206AAB04ED7AB65A6B23D1527E8'
select a.at_date, a.at_type, * from txn_sales_order_details_at a where ord_hdr_id= 'f2892860-81bb-45de-8fd4-540a30d37320' and product_id='53811206AAB04ED7AB65A6B23D1527E8' order by created_date desc -- 2024-06-10 15:15:15.180
select * from txn_sales_order_approval_history where order_id= 'f2892860-81bb-45de-8fd4-540a30d37320'
-- 2024-06-10 15:15:16.777

select a.at_date, a.at_type,* from mobile_promotion_header_at a where promition_code= '66DOUBLEPROMO' order by a.at_date desc
-- 2024-06-04 17:41:45.420 created
--2024-06-06 06:00:11.903 delete
--2024-06-06 06:00:11.987 insert again