
Closed
Posted
Paid on delivery
Role: OIC Developer (Fusion ERP ↔️ OTM Integration) Location: Offshore – India (Remote) Duration: 5–6 weeks (Contract, extendable) ⸻ About the Role We’re looking for an experienced OIC Developer to help us integrate Oracle Fusion ERP with Oracle Transportation Management (OTM). The project involves building 3 simple master data interfaces and customizing a prebuilt shipment integration. ⸻ Key Responsibilities • Build and deploy integrations in Oracle Integration Cloud (OIC). • Develop Fusion ERP → OTM master data flows (Locations, Items, Carriers). • Configure and extend OTM → Fusion ERP planned shipment flow. • Handle mappings, transformations, and error handling in OIC. • Support system integration testing and documentation. ⸻ Requirements • 2+ years of hands-on OIC development experience. • Strong knowledge of Fusion ERP & OTM adapters, SOAP/REST APIs. • Experience with XSLT mappings and BI Publisher extracts. • Prior experience with ERP ↔️ OTM integrations preferred. • Good communication skills, ability to work independently from offshore. ⸻ Engagement Details • Location: Offshore (India – remote) • Duration: ~5 weeks (25 developer-days effort, extendable) • Start Date: Immediate / within 2 weeks Requirement You’re essentially looking at setting up a set of OIC (Oracle Integration Cloud) integrations between Oracle Fusion ERP and OTM (Oracle Transportation Management). Let’s break this down orthogonally so it’s clear what’s involved: ⸻ Interfaces to Build 1. Master Data Interfaces (Fusion → OTM) Typically, OTM requires some core master data from Fusion ERP to be in sync before transactional data can flow. The 3 simple ones you mentioned are likely: • Location Master (sites, warehouses, customers, suppliers) • Item/Product Master (goods being shipped, with attributes) • Carrier/Service Provider Master (or sometimes Units of Measure / reference data, depending on scope) These flows are usually outbound from Fusion ERP → OTM. • Trigger: Fusion publishes events (or scheduled extracts). • Transformation: OIC maps Fusion’s payload (SOAP/REST/BI Publisher extract) into OTM’s inbound XML/CSV structure. • Delivery: Send to OTM via its web services (often TransmissionService API). ⸻ 2. Planned Shipment (OTM → Fusion ERP) This is the more critical/complex interface: • OTM plans the shipments and generates the transportation plan. • Fusion ERP (typically SCM Logistics or Purchasing/Order Management side) needs the shipment confirmation to update supply chain execution. • Prebuilt flows exist in OIC under OTM-Fusion SCM adapters that handle: • Listening for shipment events in OTM (via OTM’s OutboundTransmission or Integration layer). • Mapping into Fusion ERP’s InboundShipment or ShipmentAdvice service. • Usually needs some extension mapping (e.g., Fusion expects certain costing, organization, or UOM codes). ⸻ Integration Flow Setup in OIC 1. Source Connector (Adapter) • Fusion ERP adapter (SOAP/REST/BI Publisher extract). • OTM adapter (via web service / REST API / file if batch). 2. Mapping & Transformation • Use OIC mapper to transform fields between Fusion ERP schemas and OTM inbound XML schemas. • Handle code conversions (Org codes, UOM, currency, carrier IDs). 3. Error Handling & Logging • Standard OIC fault handlers. • Error notifications to functional team (email, OCI logging). 4. Scheduling / Triggers • Master data flows: usually scheduled or event-driven from Fusion. • Planned shipment flow: event-driven from OTM (real-time push). ⸻ Suggested Approach to Build 1. Start with the 3 master data flows since they’re simpler. • Get payload structures from Fusion ERP. • Align with OTM inbound service requirements. • Test in sequence (Locations → Items → Carriers). 2. Then configure the OTM → Fusion planned shipment interface using the prebuilt integration: • Deploy the prebuilt OIC integration for Shipment. • Customize the mapping for your client’s org-specific fields. • Test with an end-to-end order → shipment cycle. ⸻ End result: OTM will always have synchronized master data from Fusion, and Fusion ERP will receive planned shipments from OTM with minimal custom build.
Project ID: 39723748
38 proposals
Remote project
Active 8 mos ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
38 freelancers are bidding on average $3,234 USD for this job

Hi I have extensive Experience working as Oracle Fusion Techno Functional for fusion financial and supply chain HR Automation and integration using below technologies OIC, VBCS, PCS , BIP , i can work on this project end to end please do review my profile and send message to discuss further Regards
$2,500 USD in 7 days
6.8
6.8

⭐⭐⭐⭐⭐ Hello Valuable Client, CnELIndia, led by Raman Ladhani, can fully support your Oracle Fusion ERP ↔ OTM integration project within the required 5–6 week timeline. Our OIC developers bring proven experience in building ERP–OTM flows, XSLT-based transformations, and working with Fusion/OTM adapters. We propose the following approach: Master Data Integrations – Build and deploy 3 Fusion → OTM interfaces (Locations, Items, Carriers) using Fusion extracts and OIC transformations, ensuring alignment with OTM inbound services. Planned Shipment Flow – Configure and extend the prebuilt OTM → Fusion ERP shipment integration, customizing mappings for organization codes, UOMs, and costing as needed. Error Handling & Monitoring – Implement OIC fault handling, notifications, and logging to provide real-time visibility to your functional team. Testing & Handover – Conduct SIT across all flows, validate end-to-end order-to-shipment cycles, and deliver documentation for seamless knowledge transfer. Our offshore team in India ensures cost-effective delivery, rapid onboarding, and flexible extension if additional scope arises.
$2,250 USD in 7 days
5.7
5.7

I've successfully integrated Fusion ERP and OTM using Oracle Integration Cloud (OIC) in a similar project, leveraging REST APIs and ICS (Integration Cloud Service) for robust data transformation and error handling. My expertise includes developing and deploying OIC integrations, ensuring high availability and performance through optimized processes and robust exception management. My approach involves a phased implementation: initial requirements gathering, design and development using OIC's built-in features like mapping and orchestration, followed by rigorous testing and deployment. I will meticulously handle data mapping, transformation, and error handling, employing best practices for security and performance optimization. This includes thorough documentation at each stage. Ready to discuss your specific Fusion ERP and OTM integration needs? Could you share details on the current data volume and frequency of integration to ensure I tailor the solution to optimize performance and scalability for your business?
$2,441.62 USD in 21 days
5.2
5.2

Hello, I hope this message finds you well. I have reviewed the project requirements for the OIC Developer role involving the integration of Oracle Fusion ERP with Oracle Transportation Management (OTM). Your idea to set up these integrations is quite innovative and holds great potential for streamlining operations. Based on the provided project description and requirements, I recommend starting with the development of the 3 master data interfaces from Fusion ERP to OTM. These interfaces, including Location Master, Item/Product Master, and Carrier/Service Provider Master, will serve as the foundation for seamless data flow between the systems. Following this, configuring the Planned Shipment interface from OTM to Fusion ERP will enhance supply chain execution. To showcase my experience and expertise, please find below links to some of my past projects: 1. Teachmint 2. BigBlueButton 3. EuroCupid 4. TaskDrive 5. Unibet 6. Travelocity 7. Bitstamp By clicking on these links, you can see the quality and user-friendliness of the websites I have developed over the years. I believe that my 8+ years of experience in website development, particularly in building high-quality, user-friendly platforms, align perfectly with the requirements of this project. In approaching this project, I suggest starting with the master data flows to establish a strong data foundation before customizing the planned shipment interface. This phased approach will ensure a smooth integration process and timely delivery of the project. Thank you for considering my proposal. I am confident in my ability to deliver a high-quality solution that meets your expectations. Best regards,
$1,840 USD in 28 days
4.8
4.8

With over [X] years of hands-on experience in Oracle Integration Cloud (OIC) development, I am confident that I possess the skill-set and expertise to successfully build and deploy robust integrations between Oracle Fusion ERP and OTM. My specialization in working with, configuring, and extending OIC for various complex integration requirements aligns perfectly with what this project demands, which include building 3 critical master data interfaces and customizing a prebuilt shipment integration. In addition, I have a deep understanding of both Fusion ERP & OTM adapters, SOAP/REST APIs - an essential facet of the task at hand. My proficiency in handling mappings, transformations, churning through error handing - all using OIC - will guarantee a streamlined integration process throughout your planned timely shipments. Furthermore, I am used to working independently offshore while ensuring good communication with on-site teams. . As you search for an experienced professional that can confidently integrate your Oracle platforms, my track record speaks volumes. I look forward to discussing more details about how we can collaborate to bring enhanced efficiency and effectiveness to your business operations. Allow me the opportunity to grant you the best possible outcome!
$2,250 USD in 7 days
4.6
4.6

⚠ NO PAYMENT UNLESS YOU'RE SATISFIED ⚠ I’ve worked on multiple Fusion ERP ↔ OTM integrations using OIC, including building master data flows (locations, items, carriers) and extending the prebuilt shipment interface with custom mappings. I’m comfortable with SOAP/REST APIs, BI Publisher extracts, and XSLT transformations, plus setting up error handling and notifications in OIC for smooth operations. I can commit full-time from offshore and ensure your flows are delivered within the 5–6 week timeline. Would you like me to start by aligning with your team on the exact payload structures expected by OTM for the master data?
$2,250 USD in 7 days
4.5
4.5

Hello, I liked your project Oracle cloud integration Developer , which aligns perfectly with my professional expertise. I bring extensive experience in Cloud Computing, Oracle, XSLT, I can ensure timely delivery within 3 days. I'm committed to exceeding your expectations and would welcome the opportunity to discuss your requirements in detail.
$1,500 USD in 3 days
3.6
3.6

Hello, I thoroughly understand you need an OIC Developer for the Fusion ERP ↔ OTM Integration project. It seems that you've got a clear picture of the interfaces to build, the data flows involved, and the setup in OIC. Your approach to starting with master data flows and then moving on to the planned shipment interface is spot on. To kick things off, could you please provide details on the specific Fusion ERP and OTM adapters you are currently using or planning to use for this integration? Understanding the adapter versions and configurations can greatly impact the seamless integration process. Looking forward to diving into this project together! Could you provide details on the specific Fusion ERP and OTM adapters you are currently using or planning to use for this integration? Thank you for considering my proposal, Roshan
$2,500 USD in 5 days
2.7
2.7

Hello, I am an experienced OIC Developer with over 2 years of hands-on experience integrating Oracle Fusion ERP with OTM. I can set up the three master data flows from Fusion → OTM (Locations, Items, Carriers) and configure/customize the prebuilt planned shipment flow (OTM → Fusion ERP) to handle your organization-specific mappings and codes. I have strong expertise with Fusion and OTM adapters, SOAP/REST APIs, XSLT mapping, and BI Publisher extracts. I can implement error handling, logging, and scheduling in OIC to ensure smooth and reliable data synchronization. I am comfortable working remotely from India and can start immediately, delivering the project efficiently within the 5–6 week timeline. I look forward to helping you get these integrations up and running seamlessly. Best regards, Fizza Nadeem
$1,960 USD in 7 days
2.4
2.4

Hi there, I understand that you need an experienced OIC Developer to integrate Oracle Fusion ERP with Oracle Transportation Management (OTM), including the creation of 3 master data interfaces and customization of a prebuilt shipment integration. We have extensive experience in Oracle technologies, and our team is equipped with the necessary skills to carry out your project effectively. I'm curious about the current state of your Fusion ERP and OTM systems. Have they been customized for your business processes, or are they still in their vanilla state? Also, could you provide more details on the specific transformations required in the OIC mappings? We have successfully executed similar projects in the past and I am confident that we can meet your needs with high-quality results. Our immediate availability aligns with your project timeline and we can start within the next two weeks. We would love to connect with you further via a call or message to discuss more about your project requirements. Please feel free to contact us for any additional information or clarifications. We look forward to the potential of working together. Best Regards, Rohit
$2,700 USD in 30 days
0.7
0.7

Hi there! I was impressed by the detailed project description for the Oracle cloud integration developer role. It seems like integrating Oracle Fusion ERP with OTM is crucial for streamlining operations. I've successfully simplified complex flows, automated tasks, and ensured team synchronization in similar projects. Would you like me to sketch out a quick outline of my approach for this integration? Looking forward to potentially collaborating on this project. Talk soon!
$2,400 USD in 7 days
0.0
0.0

Hey Undertech, this project is right up our alley! We have hands-on experience in OIC development and Oracle Fusion ERP ↔️ OTM integrations. Our team can swiftly build master data interfaces (Locations, Items, Carriers) and enhance prebuilt shipment integrations. We excel in mappings, transformations, and system testing. Despite being new to Freelancer, we guarantee top-notch quality work at a competitive rate. Let's make your integration seamless and hassle-free. Looking forward to collaborating with you. Best Regards, CJ & Team
$1,800 USD in 10 days
0.0
0.0

I am a perfect fit for your project, with extensive hands-on experience in Oracle Integration Cloud (OIC) development. I understand the need to seamlessly integrate Oracle Fusion ERP with OTM, focusing on clean and efficient master data interfaces and customized shipment integrations. While I am new to Freelancer, I have vast experience completing similar projects off-site. I have the expertise required to handle mappings, transformations, and error handling in OIC, ensuring a professional, user-friendly, and automated integration process. I would love to chat more about your project! Regards, Hishaam
$1,500 USD in 14 days
0.0
0.0

bring solid experience in Oracle Integration Cloud (OIC) with a focus on Fusion ERP ↔ OTM integrations. I’ve delivered similar projects involving master data synchronization, shipment flows, and custom OIC mappings (XSLT, SOAP/REST, BI Publisher). I can ensure clean, tested, and documented integrations aligned to your 5–6 week timeline. Proposed Milestones & Pricing: Milestone 1 (USD 1,800) – Build & deploy Fusion → OTM Location, Item, Carrier master data flows. Milestone 2 (USD 1,500) – Configure & extend prebuilt OTM → Fusion ERP planned shipment interface. Milestone 3 (USD 700) – Error handling, notifications, code conversions, logging setup. Milestone 4 (USD 500) – SIT/UAT support, documentation, knowledge transfer. Total: USD 4,500 (~25 developer-days, 5–6 weeks). I’m available to start immediately and will ensure robust, future-ready OIC integrations with proper error handling and documentation.
$2,250 USD in 7 days
0.0
0.0

"I see a great alignment between the project needs and my capabilities! I understand the need to develop seamless Fusion ERP → OTM master data flows, with a focus on clean mappings, transformations, and error handling in Oracle Integration Cloud. I may be new to Freelancer, but I have a strong background and a proven track record with projects I've completed off-platform. I'd really love to hear more about your project! I'm happy to offer a free initial consultation to help get things started and see how I can best support your goals. Kind Regards, Juan K"
$1,500 USD in 14 days
0.0
0.0

"I am a perfect fit for your project, focused on Oracle Integration Cloud development. The task of integrating Oracle Fusion ERP with OTM aligns perfectly with my skill set. While I am new to freelancer, I have extensive experience in similar projects off-site. I am well-versed in building master data interfaces and customizing shipment integrations in OIC. I have strong expertise in SOAP/REST APIs, XSLT mappings, and ERP ↔️ OTM integrations. I would love to chat more about your project! Regards, Dan van Zweel."
$1,500 USD in 10 days
0.0
0.0

"Hi there, I can help with your OIC Development project to integrate Oracle Fusion ERP with OTM. Experienced in building master data interfaces and customizing prebuilt shipment integrations. While new to Freelancer, I have years of experience offsite. Let's chat more about your project! Regards, Gordon"
$1,500 USD in 14 days
0.0
0.0

Im excited to see this project! I've just recently completed a similar project integrating Oracle Fusion ERP with OTM. I ensure client satisfaction - if not happy, you don't pay. I offer expertise in OIC development, SOAP/REST APIs, and XSLT mappings. Looking to build my reviews and trust, you are my only focus, getting the most for your project. I would love to chat more and showcase my commitment to your success!
$1,500 USD in 10 days
0.0
0.0

I am a perfect fit for your project. I have reviewed the details and am confident in my ability to deliver the high-quality solution you're looking for. My focus is always on creating reliable and scalable products. With extensive experience in end-to-end software development, meticulous quality assurance, and innovative problem-solving, I can help you achieve your goals. While I am new to freelancer, I have tons of experience and have done other projects off-site. I would love to chat more about your project! Regards, Graham Valentyn
$1,500 USD in 10 days
0.0
0.0

"Our expertise aligns perfectly with your project's goals. We specialize in OIC development and have a deep understanding of Oracle Fusion ERP and OTM integration. With 2+ years of experience, we excel in building clean, professional, and user-friendly interfaces. While I am new to Freelancer, I have extensive experience completing similar projects off-site. I’d welcome the chance to talk through your vision and how we can help realize it. Regards, Herman Steyn"
$1,500 USD in 14 days
0.0
0.0

KOLKATA, India
Payment method verified
Member since Jan 25, 2012
$10-30 USD
$10-30 USD
$15-25 USD / hour
$10-30 USD
₹12500-37500 INR
₹12500-37500 INR
$10-30 USD
$750-1500 USD
$30-250 USD
$15-25 USD / hour
₹1500-12500 INR
₹5000-8000 INR
₹600-1500 INR
₹1500-12500 INR
₹600-1500 INR
₹1500-12500 INR
$1500-3000 USD
$10-30 USD
$30-250 CAD
$15-25 USD / hour
$25-50 USD / hour
$10000-20000 USD
$250-750 USD
$30-250 USD
$250-750 USD