-- |                                                                   |
-- | NAME       : Rule_start_date_correction_script.sql                |
-- |                                                                   |
-- |                                                                   |
-- | DESCRIPTION: Script to correct rule start date correction         |
-- |               in ra_interface_lines_all                           |
-- |                                                                   |
Update  apps.ra_interface_lines_all ria
 set rule_start_date ='01-APR-18' -- Change this to starting day as per current month
 where interface_line_id in (select ria.interface_line_id 
                              from apps.ra_interface_lines_all ria,
							        apps.ra_interface_errors_all rie
                               where   1=1 
                                and ria.interface_line_id=rie.interface_line_id
                                and interface_line_context='SKP'
                                and message_text='Ensure that supplied rule start date will generate GL Dates that are in Open or Future periods when the GL Date in a Closed Period option is set to Reject in the Transaction Sources window.'
                                  ) ;
								  
Commit:

/* Run the Autoinvoice Master Program in the application*/