SQL> select count(*) from AP.AP_INVOICES_ALL;
 
  COUNT(*)
----------
     11255
 
SQL> /
 
  COUNT(*)
----------
     11255

Enter user-name: sys as sysdba
Enter password:
 
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
 
SQL> select count(*) from AP.S_AP_INVOICES_ALL;
 
  COUNT(*)
----------
     11219 ---------------------> Records Mismatch
 

SQL> exec dbms_mview.refresh('AP.S_AP_INVOICES_ALL','F')
/
 
PL/SQL procedure successfully completed.
 
SQL>
  COUNT(*)
----------
     11219
 
SQL> select count(*) from AP.S_AP_INVOICES_ALL;
 
  COUNT(*)
----------
     11219
 
 
SQL> exec dbms_mview.refresh('AP.S_AP_INVOICES_ALL','F')
/
 
PL/SQL procedure successfully completed.
 
 
SQL> exec dbms_mview.refresh('AP.S_AP_INVOICES_ALL','F');
 
PL/SQL procedure successfully completed.
 
SQL> select count(*) from AP.S_AP_INVOICES_ALL;
 
  COUNT(*)
----------
     11219
 
SQL> exec dbms_mview.refresh('AP.S_AP_INVOICES_ALL');
 
PL/SQL procedure successfully completed.
 
SQL> select count(*) from AP.S_AP_INVOICES_ALL;
 
  COUNT(*)
----------
     11219
 
SQL>  exec dbms_mview.refresh('AP.S_AP_INVOICES_ALL','C');
 
PL/SQL procedure successfully completed.
 
SQL> select count(*) from AP.S_AP_INVOICES_ALL;
 
  COUNT(*)
----------
     11255 ---------------------> Now this issue solved.