How to Get the Period Close Exception Reports in FA

Hi

We have Multiple  Corp Books in FA in single Entity and during Create Accounting Process many Requests have ended in Warning with Error of  the CCID is end dated.

I have run the Subledger Period Close Exceptions Report in GL with Source Assets but output shows only Asset Number,Transaction Number and Corp  Book but does not show the Invalid CCID with is having issues.

How can we get the List of such Accounts which are end dated or is there any Report in FA or how can we get  the extract or exceptions of  of such end dated CCID;s  or from back end at once for all such Corp Books