Sorry to hear you were unsuccessful in your attempt. You were very close to a passing mark which should hopefully give you comfort that a pass is in reach.
It's advisable that if you are retaking an OD CBE, to not leave too long a gap before booking a resit. However, the decision of when to book the next attempt should be based on how confident you feel in the technical knowledge.
Have you explored the resources on the ACCA website for Financial Accounting? This includes access to a specimen which we'd encourage you to work through to gauge your exam readiness.
You may find that with a bit more question practice, focus on exam technique and practicing questions to time, you'll be prepared to pass.
Good luck! :)