Interfaces and Conversions in Oracle Apps Technical

Interfaces and Conversions in Oracle Apps Technical, available at $19.99, has an average rating of 3.1, with 5 lectures, based on 14 reviews, and has 50 subscribers.

You will learn about Creation of Staging Table, Flat Files and Control Files Create Staging Table and SQL*Loader (Control File) Conversion Flow Run SQL*Loader Program to load data into staging table Run Standard Concurrent Program/API to import data into Oracle Apps Tables Mapping of Source data with Target Data columns This course is ideal for individuals who are Any Graduate It is particularly useful for Any Graduate.

Enroll now: Interfaces and Conversions in Oracle Apps Technical

Summary

Title: Interfaces and Conversions in Oracle Apps Technical

Price: $19.99

Average Rating: 3.1

Number of Lectures: 5

Number of Published Lectures: 5

Number of Curriculum Items: 5

Number of Published Curriculum Objects: 5

Original Price: ?1,499

Quality Status: approved

Status: Live

What You Will Learn

Creation of Staging Table, Flat Files and Control Files

Create Staging Table and SQL*Loader (Control File)

Conversion Flow

Run SQL*Loader Program to load data into staging table

Run Standard Concurrent Program/API to import data into Oracle Apps Tables

Mapping of Source data with Target Data columns

Who Should Attend

Any Graduate

Target Audiences

Any Graduate

Interfaces and Conversions in Oracle Apps Technical

Interfaces and Conversions are data loading program which is used to migrate data from one legacy system to another. Interface and Conversion Programs are part of RICE component of Oracle Apps Technical Work.

It is a part of  Oracle Apps Technical.

Difference between Conversion & Interface:

Interface:

Interface is periodic activity, it may be daily or weekly or monthly or quarterly or Yearly.
Both Legacy system and oracle system are active.
It is Scheduled Concurrent Process to execute multiple times.
We will not be knowing the volume of the Flat file.

Conversions:

Conversions is one time Activity.
This is used in Upgrade and Migration Projects.
We will be knowing the volume of the Flat file.
Conversion is not a Scheduled Process.

From this course you will get clear idea of  

Create Staging Table and SQL*Loader (Control File).
Run SQL*Loader Program to load data into staging table.
Perform Validation of Data using PLSQL Package.
Mapping of Source data with Target Data columns.
Transfer Data into Standard Interface Table.
Run Standard Concurrent Program/API to import data into Oracle Apps Tables

Create Staging Table and SQL*Loader (Control File).
Run SQL*Loader Program to load data into staging table.
Perform Validation of Data using PLSQL Package.
Mapping of Source data with Target Data columns.
Transfer Data into Standard Interface Table.
Run Standard Concurrent Program/API to import data into Oracle Apps Tables.

Course Curriculum

Chapter 1: Interfaces and Conversions in Oracle Apps

Lecture 1: Oracle Apps Interfaces and Conversions Demo

Lecture 2: Diff bet. Interfaces & Conversions,Types, Inbound Interfaces, Using SQL * Loader

Lecture 3: Working with Staging Table Scripts, Dev. Validations Package, Interface Tables

Lecture 4: Introduction to Conversions, Conversion Flow

Lecture 5: Interfaces Script Files and APIs

Instructors

Koduru Sridevi
Oracle Apps & Fusion Techno Functional Consultant & Trainer

Rating Distribution

1 stars: 3 votes

2 stars: 3 votes

3 stars: 2 votes

4 stars: 4 votes

5 stars: 2 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!