Communities
A collaborative platform to connect and grow with like-minded Informaticans across the globe
Product Communities
Connect and collaborate with Informatica experts and champions
Discussions
Have a question? Start a Discussion and get immediate answers you are looking for
User Groups
Customer-organized groups that meet online and in-person. Join today to network, share ideas, and get tips on how to get the most out of Informatica
Get Started
Community Guidelines
Knowledge Center
Troubleshooting documents, product guides, how to videos, best practices, and more
Knowledge Base
One-stop self-service portal for solutions, FAQs, Whitepapers, How Tos, Videos, and more
Support TV
Video channel for step-by-step instructions to use our products, best practices, troubleshooting tips, and much more
Documentation
Information library of the latest product documents
Velocity (Best Practices)
Best practices and use cases from the Implementation team
Learn
Rich resources to help you leverage full capabilities of our products
Trainings
Role-based training programs for the best ROI
Certifications
Get certified on Informatica products. Free, Foundation, or Professional
Product Learning Paths
Free and unlimited modules based on your expertise level and journey
Resources
Library of content to help you leverage the best of Informatica products
Tech Tuesdays Webinars
Most popular webinars on product architecture, best practices, and more
Product Availability Matrix
Product Availability Matrix statements of Informatica products
SupportFlash
Monthly support newsletter
Support Documents
Informatica Support Guide and Statements, Quick Start Guides, and Cloud Product Description Schedule
Product Lifecycle
End of Life statements of Informatica products
Ideas
Events
Change Request Tracking
Marketplace
English
  • Data Integration Connectors
  • All Products

Table of Contents

Search

  1. Preface
  2. Introduction to Oracle Financials Cloud V1 Connector
  3. Oracle Financials Cloud V1 connections
  4. Mappings and mapping tasks with Oracle Financials Cloud V1 Connector
  5. Troubleshooting

Oracle Financials Cloud V1 Connector

Oracle Financials Cloud V1 Connector

Back Next

Midstream transformation mapping example

Midstream transformation
mapping
 example

To read data from an Oracle Financials Cloud V1 source and to write the data to a flat file, perform the following tasks:
  1. Create an Oracle Financials Cloud V1 connection to read data from an Oracle Financials Cloud V1 source.
  2. In
    Data Integration
    , click
    New
    Components
    Business Sevice
    .
    The
    Business Sevice Details
     dialog box appears.
    The following image shows the configured business service that associates an Oracle Financials Cloud V1 connection and an operation:
  3. On the Web Services transformation, specify a name and description in the general properties.
    The following image shows the source, web service, and target in the Oracle Financials Cloud V1 mapping:
  4. On the
    Web Service
     tab, select the business service and the operation that you configured.
    The following image shows the configured web service:
  5. On the
    Request Mapping
     tab, map the incoming fields from the source to the elements of Request Structure to form a web service request.
    The following image shows the fields that you map:
  6. On the
    Response Mapping
     tab, select the source details fields that you want to write to the target file on the
    Response Structure
    .
    The following image shows the source details fields that you want to write to the target file:
  7. On the
    Advanced
     tab, provide the value for the required advanced property. You can specify the cache size details.
    The fields that you select from the
    Response Structure
     of the Web Service transformation appear as incoming fields for the target object.
  8. If required, map the incoming fields to the flat file fields.
    The following image shows the mapped fields between the source field and the target field:
  9. Click
    Task Wizards
    Mapping Task
    , and select the mapping for the task.
  10. When you save and run the mapping, the Secure Agent reads the data that you map on the
    Request Mapping
     tab from the Oracle Financials Cloud application and writes the data to the corresponding flat files.
0 COMMENTS
We’d like to hear from you!