Could you describe the end-to-end governance framework and best practices you implement within Oracle Integration Cloud (OIC) to ensure security, compliance, and lifecycle management? When designing integration solutions for Oracle Fusion Applications, what strategies and validation mechanisms do you employ to maintain data integrity and transactional consistency across various modules? Walking through a specific project from your experience, could you detail your end-to-end architectural methodology, from initial requirement gathering to final solution design and deployment? How do you leverage the OIC Process Automation engine to design complex business workflows, and what are the key components you use to manage state and transitions? Can you provide a comparative analysis of OTBI, HCM Extracts, and BI Publisher (BIP) reports, specifically highlighting the technical constraints and ideal use cases for each tool?