Interfaces and Conversions in Oracle Apps Technical
2.8 (5 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
22 students enrolled

Interfaces and Conversions in Oracle Apps Technical

Learn Interfaces and Conversions in Oracle Apps Technical Module | Interfaces in Oracle Apps with Live Meeting Support
2.8 (5 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
22 students enrolled
Created by Koduru Sridevi
Last updated 2/2018
English
English
Current price: $48.99 Original price: $69.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 2 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll 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
Requirements
  • Basic Knowledge of SQL and PLSQL is required
Description

Interfaces and Conversions in Oracle Apps Technical with Live Meeting Support to clear your queries on every Sunday. You will receive the meeting link for the support session on every Friday to your Udemy registered mail id through Udemy educational announcement mails.


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.

Who this course is for:
  • Any Graduate
Course content
Expand 5 lectures 02:05:31
+ Interfaces and Conversions in Oracle Apps
5 lectures 02:05:31
  • Demo Session of Oracle Apps Interfaces and Conversions
Preview 13:28
  • Introduction to Interfaces
  • Difference between Interfaces and Conversions
  • Types of Interfaces
  • Inbound Interfaces
  • Using SQL * Loader
Diff bet. Interfaces & Conversions,Types, Inbound Interfaces, Using SQL * Loader
33:01
  • Working with Staging Table Scripts
  • Developing Validations Package
  • Interface Tables and Error Tables
Working with Staging Table Scripts, Dev. Validations Package, Interface Tables
39:48
  • Introduction to Conversions
  • Conversion Flow
Introduction to Conversions, Conversion Flow
23:08
  • Interfaces Script Files and API's
Interfaces Script Files and API's
16:06