In most of the cases deleting the AWE for the particular effective date is difficult because deletion need to perform in multiple tables 

Here we listed all the tables   

DELETE FROM PS_EOAW_STEP WHERE EOAWPRCS_ID = 'process_name' AND EOAWDEFN_ID = 'defn_name' AND EFFDT = '30-11-2022'; 
 
DELETE FROM PS_EOAWCRTA WHERE EOAWCRTA_ID LIKE '%Process_nameDefn_name30-11-2022%'; 
 
 DELETE FROM PS_EOAWCRTA_REC WHERE EOAWCRTA_ID LIKE '%Process_nameDefn_name30-11-2022%'; 
 
 DELETE FROM PS_EOAWCRTA_VAL WHERE EOAWCRTA_ID LIKE '%Process_nameDefn_name30-11-2022%'; 
 
 DELETE FROM PS_EOAW_TIMEOUT WHERE EOAWPRCS_ID = 'TheProcess_name' AND EOAWDEFN_ID = 'TheDefn_name' AND EFFDT='30-11-2022'; 
 
 DELETE FROM PS_EOAW_PATH WHERE EOAWPRCS_ID = 'TheProcess_name' AND EOAWDEFN_ID = 'TheDefn_name' AND EFFDT='30-11-2022'; 
 
 DELETE FROM PS_EOAW_STAGE WHERE EOAWPRCS_ID = 'TheProcess_name' AND EOAWDEFN_ID = 'TheDefn_name' AND EFFDT='30-11-2022'; 
 
 DELETE FROM PS_EOAW_PRCS WHERE EOAWPRCS_ID = 'TheProcess_name' AND EOAWDEFN_ID = 'TheDefn_name' AND EFFDT='30-11-2022'; 
commit;

By admin

Leave a Reply

Your email address will not be published. Required fields are marked *