Oracle Fusion UK VAT Return – Tax Box Allocation and Custom Reporting

Hello All, We are migrating from Oracle EBS to Oracle Fusion Cloud Financials and would like to understand the best approach for UK VAT return reporting in line with HMRC requirements.
1. How are VAT return boxes (Boxes 1–9) mapped to values from standard Oracle Fusion tax reports?
2. Can standard reports provide all the required values, or do we need to combine multiple columns or reports to derive the final tax box amounts?
3. Has anyone implemented a custom OTBI, BI Publisher, or other report to consolidate the required values and generate an HMRC-compliant VAT return?
If you have implemented a similar solution, could you share which standard reports were used, how the tax box values were derived, and whether a custom report was required?