Table of Contents

Search

  1. Preface
  2. Understanding PowerExchange for Oracle E-Business Suite
  3. PowerExchange for Oracle E-Business Suite Configuration
  4. Oracle E-Business Suite Sources and Targets
  5. Application Source Qualifier Transformation
  6. Oracle E-Business Suite Mappings
  7. Oracle E-Business Suite Sessions
  8. Datatype Reference
  9. Error Messages
  10. Glossary

PowerExchange for Oracle E-Business Suite User Guide for PowerCenter

PowerExchange for Oracle E-Business Suite User Guide for PowerCenter

Working with Oracle E-Business Suite Sources

Working with Oracle E-Business Suite Sources

Use the Import from Oracle E-Business Suite Wizard to import an Oracle E-Business Suite source definition. You can import the following types of Oracle E-Business Suite metadata as an Oracle E-Business Suite source definition:
  • Tables
  • Views
  • Flexfields
When you connect to Oracle E-Business Suite, the wizard lists each application. Each application contains tables, views, and flexfields. These are child objects of the application.
You can select tables, views, or flexfields to import. When you import a source definition with a flexfield, the Designer adds a field called CONCATENATED_PORT. This field concatenates all other fields separated by the delimiter defined in Oracle E-Business Suite.
When you select a child object, the name, description, datatype, precision, and scale display on the Field List tab. If you select an application, the Field List tab remains blank.

0 COMMENTS

We’d like to hear from you!