Dönemsel Muhasebe “Dönemi Bekleyen İşlemler “Hatası

 
 
DECLARE
   l_per_id   NUMBER;
BEGIN
   FOR aa IN (SELECT ROWID rwid, t.*
                FROM mtl_transactions_interface t
               WHERE transaction_date < '01.11.2016')
   LOOP
      SELECT acct_period_id
        INTO l_per_id
        FROM org_acct_periods
       WHERE organization_id = aa.organization_id AND period_name = '11-16';
 
      UPDATE mtl_transactions_interface
         SET transaction_date = '01.11.2016',
             acct_period_id = l_per_id
       WHERE ROWID = aa.rwid;
   END LOOP;
 
 
COMMIT;
 
END;