PO2DC File Update:
Checkout start time 4 AM EST
SLA 5:30 AM EST
Frequency Monday – Sunday
Team to contact for file delay IPR_AO@[Link]
SN Assignment Group IPR_IT_PO_ASN
We get three counts from IPR team & we update these counts in the below one drive sheet:
1. PO2DC
2. POM_TRANSFER
3. SOM counts
One Drive Sheet Link:
[Link]
nagaprasanth_kothamasuveera_homedepot_com1/_layouts/15/[Link]?sourcedoc=
%7B08DE2355-1A6D-4414-8364-13447B93A00A
%7D&file=Daily_PO2DC_Check.xlsx&action=default&mobileredirect=true
On daily basis, we must run two queries and update PO2DC one drive sheet.
Since we have three environments, we must run these queries in three environments.
Environment Path/Instances
RC
PROD hdw-core/fulfillment-core
C1
1. For Yesterday Count:
We have to run below query with modified date as highlighted in colors and update the count in
Yesterday date (NY Current date -1) Column in the one drive sheet.
Yellow Colour => NY Current date -2
Red Colour => NY Current date -1
select dc_number, order_origin, count(order_id) as count
from orders
where order_origin in ('POM-TRANSFER', 'SOM', 'PO2DC')
and create_date_time > '2024-10-05T23:59:59.969Z' and create_date_time <= '2024-10-06T23:59:59.969Z'
and order_status_id not in (500)
group by 1,2
order by 1,2
2. For Today’s Count:
We have to run below query with modified date as highlighted in colors and update the count in
today’s date (NY Current date) Column in the one drive sheet.
Red Colour => NY current date -1
select dc_number, order_origin, count(order_id) as count
from orders
where order_origin in ('POM-TRANSFER', 'SOM', 'PO2DC')
and create_date_time > '2024-10-06T23:59:59.969Z'
and order_status_id not in (500)
group by 1,2
order by 1,2
What need to do when there is low/missing count for any DC( FDC/BDC, RC, SDC ):
For missing count ( PO2DC, SOM ) liaise with IPR team and send an communication to the respective
DC operation group that there is an delay in receiving POM or SOM and we are working with
upstream to get it sorted out.
Please find the DC operations email list
DC Operations email List:
[Link]
At last, we have to update the reminder which will trigger at 4 AM EST in #offshore-communication
slack channel with these counts in JSON format.