751086908.xlsx - Deployment&Data Uploading Plan.

Comments DM approved Proof of

Actual End Link for Extracted Data
Activity GRP Month Day PlanDate Step Activity Activity By CRQ Activities Duration Remarks Actual Duration Actual Start by Approval

Down Time Duration Duration DM approved Proof of

Step Activity Activity By CRQ Activities - Base EBS Comments/Scripts/Responsibilities Remarks Actual Start Date/Time Actual End Date/Time SQL scripts Link for Extracted Data
Required (hh:mm:ss) (hh:mm:ss) by Approval

Objects Locations.

Tables Location:
https://adia.sharepoint.com/:f:/s/ITD-OracleFusionSubsidiaries2/
EoLwUqPtus1MvoS4pN53a44BaSivUY0_DnBk4LCEI2z59Q?e=om4z7l

Indexes Location:
https://adia.sharepoint.com/:f:/s/ITD-OracleFusionSubsidiaries2/
EhiJmgb2jKpPsayQSU3xkKIBk8kn7EiOOo2FEBV2Gi9CCQ?e=jyyevD

Views Location:
https://adia.sharepoint.com/:f:/s/ITD-OracleFusionSubsidiaries2/
Euh0luH2i5lNhkuRBssynuEB7LECTOyHFufMwAawyr54pQ?e=pzMKx7

XXARMS DB OBJECTS CREATION: Packages/Procedures Location:

1. Tables https://adia.sharepoint.com/:f:/s/ITD-OracleFusionSubsidiaries2/EkigafuwnERHnwyzjKfAGzgBErwShaUYGZA-
2. Indexes LvbMIFytXg?e=wGwpug
3. Views
1 Manual ADIA IT Connect to ATP DB as ADMIN user. 3:00:00
4. Packages

Copy the scripts from the given sharepoint location to Run the SQL script: Executes the followings DDL scripts to create DB Tables
ATP server and execute the scripts
1) XXARMS_ATP_MASTER_ITEMS_DB_OBJECTS.sql
2) XXARMS_ATP_AP_MASTER_DB_OBJECTS.sql
3) XXARMS_ATP_PO_REQUISITIONS_DB_OBJECTS.sql
4) XXARMS_ATP_PO_ORDERS_DB_OBJECTS.sql
5) XXARMS_ATP_RCV_TRANSACTIONS_DB_OBJECTS.sql
6) XXARMS_ATP_AP_INVOICES_DB_OBJECTS.sql
7) XXARMS_ATP_FIXED_ASSETS_DB_OBJECTS.sql
8) XXARMS_ATP_GL_GENERAL_LEDGERS_DB_OBJECTS.sql
9) XXARMS_ATP_ONHAND_QTY_DB_OBJECTS.sql

Run the SQL script: Executes the followings DDL scripts to create DB Indexes
10) XXADIA_AP_SUPPLIER_INDEXES.sql
11) XXADIA_AP_INVOICES_INDEXES.sql
12) XXADIA_MASTER_ITEM_INDEXES.sql
13) XXADIA_PO_REQUISITIONS_INDEXES.sql
EBS CP OBJECTS (TFS FILES)
File Location:
https://adia.sharepoint.com/:f:/s/ITD-OracleFusionSubsidiaries2/
EhPK5DirxR1BuzZVnmYXLnYBq8uUdmxHW78zXanzn9lMBQ?e=FA0TeI

Follow Steps mentioned in

2 Manual ADIA IT 2:00:00
XXARMS_DM_CODE_PROD_RELEASE_01.00_a11683

Connect With EBS instance with the user having responsibilty 'Purchasing Super User (ARMS)' and Run the
mentioned Concurrent Requests, One at a time in order mentioned

1) ADIA Inventory Items Data Migration Extract from EBS to ATP

2) ADIA Ap Master Data Migration From EBS to ATP
3) ADIA Purchase Reqs Data Migration Extracts from EBS to ATP
4) ADIA Purchase Orders Data Migration Extracts from EBS to ATP
5) ADIA Purchase Receivings Data Migration Extracts from EBS to ATP
6) ADIA On-Hand Qty Data Migration Extract from EBS to ATP

Connect With EBS instance with the user having responsibilty 'AP Super User (ARMS)' and Run the mentioned
Concurrent Requests, One at a time in order mentioned
3 Manual ADIA Run Concurrent Requests to get data from EBS to PAAS. 7) ADIA Ap Invoices Data Migration Extract from EBS to ATP 3:00:00

Connect With EBS instance with the user having responsibilty 'FA Super User (ARMS)' and Run the mentioned
Concurrent Requests, One at a time in order mentioned

8) ADIA Fixed Assets Data Migration Extract from EBS to ATP

Connect With EBS instance with the user having responsibilty 'GL Super User (ARMS)' and Run the mentioned
Concurrent Requests, One at a time in order mentioned

9) ADIA General Ledgers Master Data Migration Extract form EBS to ATP
10) ADIA General Ledgers Data Migration Extract form EBS to ATP

Follow the Uploading sequence Strictly as mention below

DATA UPLOADING For Suppliers in Fusion
File Location:
https://adia.sharepoint.com/:x:/s/ITD-OracleFusionSubsidiaries2/ERM8xu14-
XRJmW_b2NM1kWoBcs5fGHeXowaUAmGeM21VLw?e=j7yqMY

1 Via FBDI ADIA 1) Follow the instructions given in File 150 minutes 2-Jul-23 2-Jul-23 https://adia.sharepoint.com/sites/ITD-OracleFusionSubsidiaries2/Shared%20Docum

DATA UPLOADING For Supplier Addresses in Fusion

File Location:
https://adia.sharepoint.com/:x:/s/ITD-OracleFusionSubsidiaries2/
EfCYCxsqmQZGi2R9SJckptcBBF8EGju_gcg94kVYH6-E3w?e=WSL1C3

1 via FBDI ADIA 1) Follow the instructions given in File 120 minutes 2-Jul-23 2-Jul-23

https://adia.sharepoint.com/sites/ITD-OracleFusionSubsidiaries2/Shared%20Docum
DATA UPLOADING For Supplier Sites in Fusion
File Location:
https://adia.sharepoint.com/:x:/s/ITD-OracleFusionSubsidiaries2/Eav-ziia2sVNjoBAU0ya0DsBdJZK6LFr-
0hOxPn1UcWFKg?e=NyJYs7

1 Via FBDI ADIA 1) Follow the instructions given in File 150 minutes 2-Jul-23 2-Jul-23

https://adia.sharepoint.com/sites/ITD-OracleFusionSubsidiaries2/Shared%20Docum
DATA UPLOADING For Supplier Site Assignments in Fusion
File Location:
https://adia.sharepoint.com/:x:/s/ITD-OracleFusionSubsidiaries2/
ERG14dYC3b9Ci9x0MaAhJGYB825E6YXccKI4Lipu2NlhcA?e=a0e8Ey

1 Via FBDI ADIA 1) Follow the instructions given in File 90 minutes 2-Jul-23 2-Jul-23

https://adia.sharepoint.com/sites/ITD-OracleFusionSubsidiaries2/Shared%20Docum
DATA UPLOADING For Supplier Business Classifications

# Classification: Internal - ADIA and Business Partners Page 1 of 24 05/04/2024&L Classification: Internal - ADIA and Business Partners
#
751086908.xlsx - Deployment&Data Uploading Plan.

1 Via FBDI ADIA 1) Extract Via Query and upload via FBDI 120 minutes 5-Jul-23 5-Jul-23

https://adia.sharepoint.com/sites/ITD-OracleFusionSubsidiaries2/Shared%20Docum
DATA UPLOADING For Supplier Contacts in Fusion
File Location:
https://adia.sharepoint.com/:x:/s/ITD-OracleFusionSubsidiaries2/
ESUCQ7uAIGZJpvJWAzaH3M8Bl9MV6MaVBqRhx9gDEFuiHw?e=0GNvzp

will be done before golive as it triggers

1 Via FBDI ADIA 1) Follow the instructions given in File
emails to suppliers

DATA UPLOADING For Supplier Bank Accounts in Fusion

File Location:
https://adia.sharepoint.com/:x:/s/ITD-OracleFusionSubsidiaries2/
Ed9rBYKJ0xBAnnApFhOx6_IBmzag7Ej2Y5CpBHSnV4tUiA?e=kaAHtA
Pl refer Dheeraj
Deshmukhs
email dated
19/7/2023 to
Dheeraj
https://adia.sharepoint.com/:f:/s/ITD-OracleFusionSubsidiaries2/EsQCZ3bF4PpMqn
1 Via FBDI ADIA 1) Follow the instructions given in File 7 Hours 24-Jul-23 24-Jul-23 Divesh Kalsi,
Deskmukh
screenshot
attached in a
sheet in this
Excel

DATA UPLOADING For Master Items in Fusion

File Location:
https://adia.sharepoint.com/:x:/s/ITD-OracleFusionSubsidiaries2/Ebit-
NDsYMZDlWWgsvOdHf4BtwZx5KdFcezdgEiBOvZiYQ?e=F7oUh1
Please refer
Sheet 2 for
screen shots of
1 Via FBDI ADIA 1) Follow the instructions given in File 180 minutes 14-Jul-23 17-Jul-23 Item Loads - Allmails
GML/ADIA: Oracle Fusion - FBDIMurugesh dated (sharepoint.com)
Documents
28.6.2023 from
Murugesh
conveying
approval

DATA UPLOADING For Purchase Requisitions in Fusion

File Location:
https://adia.sharepoint.com/:x:/s/ITD-OracleFusionSubsidiaries2/
ETbygc3wq1xNnCs9Bqvgu6sBSVOCxFp2_vEhRhU69tO10Q?e=iqyiaZ

1 Via FBDI ADIA 1) Follow the instructions given in File Murugesh

Requisition Extraction Data Prod

DATA UPLOADING For Purchase Orders in Fusion
File Location:
https://adia.sharepoint.com/:x:/s/ITD-OracleFusionSubsidiaries2/EVqG-
1Tu1DRBoQzRFExY3hkBkln48bnDQLFut8AqXs4WXQ?e=b3mVvZ

1 Via FBDI ADIA 1) Follow the instructions given in File Murugesh Screen shot of
approval on
Teams chat by
Murugesh(Fusio
n- Procurement
-Production) - pl
refer xcel sheet
Screen shot of approval on Teams chat by Murugesh(Fusion- Procurement -Production) - pl refer xcel sheet in this file. in this file.
DATA UPLOADING For Purchase Orders Receiving in Fusion
File Location:
https://adia.sharepoint.com/:x:/s/ITD-OracleFusionSubsidiaries2/
EbrsOUejt_lLtNZaj6QZm84B8QiYqnia6SZVJnl193q7ng?e=d0QoH0

1 Via FBDI ADIA 1) Follow the instructions given in File

DATA UPLOADING For AP Invoices in Fusion

File Location:
https://adia.sharepoint.com/:x:/s/ITD-OracleFusionSubsidiaries2/
ERDhLM7vzy5Cn2l_QcJemz4BdIaVnjV5APIEaTkQjFsR7A?e=OE3dhp Pl refer screen
shot of approval
conveyed in
Teams Chat
Naqeeb during Migration
1 Via FBDI ADIA 1) Follow the instructions given in File 150 minutes 5-Aug-23 5-Aug-23 https://teams.microsoft.com/l/message/19:041a7ac3-cf89-4be9-b298-488097e05fe
Shahzad Mir session on 3rd
AFridi Ullah and 4th August
2023. Screen
shot attached in
a sheet in this
Excel

1)DATA UPLOADING For Fixed Assets in Fusion

File Location:
https://adia.sharepoint.com/:x:/s/ITD-OracleFusionSubsidiaries2/EUEHin3Gx19Cjc8WTmUVkGEB7m-
hPDQhXtnnegZbJr9Pow?e=i6hHSg

Then also follow this one after the above file Pl refer Email
from Dalton
https://adia.sharepoint.com/:x:/s/ITD-OracleFusionSubsidiaries2/EWRiC- dated 4.8.2023.
1 Via FBDI ADIA 1) Follow the instructions given in File EutC9OvBBNq5qFQoABmSSe51DLmESnASVYKV1O3A?e=ktEQlC 1 hour 30 minutes 4-Aug-23 4-Aug-23 https://adia.sharepoint.com/sites/ITD-OracleFusionSubsidiaries2/Shared%20Docum
Justin Dalton screen shot
attached in
another sheet in
this Excel

DATA UPLOADING For General Ledger (Balances from Jan 2018 to Dec 2022) in Fusion

# Classification: Internal - ADIA and Business Partners Page 2 of 24 05/04/2024&L Classification: Internal - ADIA and Business Partners
#
751086908.xlsx - Deployment&Data Uploading Plan.

File Location:
https://adia.sharepoint.com/:x:/s/ITD-OracleFusionSubsidiaries2/
EXXWX_lXLytMhuoFEePawDoBrC9RrsT17lEVpYZPaRejog?e=X0OSMC
Please refer
additional sheets
here for screen
30 minutes for shots of mails
https://adia.sharepoint.com/:x:/s/ITD-OracleFusionSubsidiaries2/ERqTfxXTxFlOoRR
1 Via FBDI ADIA 1) Follow the instructions given in File 17-Jul-23 18-Jul-23 Justin Dalton
each month dated 28.6.2023
from Justin
conveying
approval

DATA UPLOADING For General Ledger ( Journals from Jan 2023) in Fusion
File Location:
https://adia.sharepoint.com/:x:/s/ITD-OracleFusionSubsidiaries2/
EXXWX_lXLytMhuoFEePawDoBrC9RrsT17lEVpYZPaRejog?e=X0OSMC
Screenshot of
chat (Justin
Dalton and
Divesh Kalsi)
30 minutes each https://adia.sharepoint.com/:x:/s/ITD-OracleFusionSubsidiaries2/ERqTfxXTxFlOoRR
via FBDI ADIA 1) Follow the instructions given in File 31-Jul-23 31-Jul-23 Justin Dalton dated 1.8.2023
month
and 4.8.2023
attached in
another sheet in
this Excel

DATA UPLOADING For Inventory Locations in Fusion

File Location:
https://adia.sharepoint.com/:x:/s/ITD-OracleFusionSubsidiaries2/EVbFBAfSn9FGrFNqappWP-
gBi2tLIPFH44HWN7GV7E6xOw?e=0Gs3El
Please refer
additional sheets
here for screen
shots of mail
1 Manual ADIA 1) Follow the instructions given in File 12-Jul-23 12-Jul-23 PROD Item Load Data Murugesh dated 02-Jul-
2023 from
Murugesh
conveying
approval

DATA UPLOADING For OnHand Quantity in Fusion

File Location:
https://adia.sharepoint.com/:x:/s/ITD-OracleFusionSubsidiaries2/
ER9GBj18_URDkt6GgeqUo_QBokBU3pfbdKAL9hya7cewSg?e=g6HYQS

1 Manual ADIA 1) Follow the instructions given in File

# Classification: Internal - ADIA and Business Partners Page 3 of 24 05/04/2024&L Classification: Internal - ADIA and Business Partners
#
Screen shot of Teams Chat group FUSION-PRODUCTION
at group FUSION-PRODUCTION-PROCUREMENT dt.4.8.2023
Teams chat screenshots during AP Invoices Migration on 3/8/2023 and 4/8/2023