Can I add any geography to the geography hierarchy in Oracle Fusion Financials?

Yes. however, the geography type for the geography that you want to add must be already added to the country geography structure.