DBMS_XPLAN not able to retrieve execution plan of a SQL ID

 
Hi

In our 10.2.0.4 database, we executed the following query couple of times


select SUM(il.charge_amt) totcharge from INVOICE_LINES il where exists
(select null from INVOICE_HEADER ih where ih.FILE_NO=il.file_no and ih.SUFFIX=il.SUFFIX and ih.INVOICE_PREPARED!='Y' and ih.BILL_TO_CUST='F1015' )
and il.CHARGE=99


We then retrieved the SQL_ID of this query from v$sql as follows


SQL> select sql_id,sql_text from v$sql where sql_text like 'select SUM(il.charge_amt)%';

SQL_ID
-------------
SQL_TEXT
------------------------------------------------------------------------------------------------------------------------
c0n5hxan19xt9