Oracle E-Business Suite VM Install and Developer Essentials

Name: Oracle E-Business Suite VM Install and Developer Essentials
Rating: 4.8 (65 reviews)

Install Oracle EBS 12.2.10 Vision on Virtual Machine, run it locally and learn developer and functional topics around it

Created byGoran David

Last updated 3/2023

English

What you'll learn

Install Oracle E-Business Suite locally on Virtual Machine
Developer Basics around Install Oracle E-Business Suite
Functional Basics around Install Oracle E-Business Suite
Use Forms and Menus
Install and use jDeveloper for OAF
Create OAF Extensions
Search for Data and Enter Data Using Forms
Create Responsibilites, Functions, Menus, Request Groups
Creating Custom Tops/Applications
Create Concurrent Programs
Install Workflow Builder and Create Workflows
Use FNDLOAD to upload and download varios components
Create Reports with XML Publisher
Create Custom WebADI - Application Desktop Integrator
Installing APEX on the same machine alongside EBS and connecting to it

Course content

16 sections • 89 lectures • 7h 15m total length

About this course2:25
What you'll learn and do across the course
Hardware and Software Requirements1:40
How powerful machine I need for installation
How much does it cost?1:27
How much do I have to spend for tools necessary to go through this course?

VirtualBox Download and Installation2:40
Where to download VirtualBox and the installation procedure
e-Business Suite Vision 12.2.10 Installation Files Download3:07
Where and how to download all of the necessary files for Oracle EBS VM 12.2.10 Appliance
SSH and sFTP Tool Download and Installation2:12
MobaXterm description and download
SQLDeveloper Download and Installation3:18
How to download SQLDeveloper - Tool to access Oracle database
What I'll need to follow this course

Preparing VM Image - Shell Script (method 1)5:52
How to prepare/get final file for VM import from the downloaded ones.
Preparing VM Image – Zip Tool and Concatenation (method 2)4:30
Alternative method of preparing the final file for import into VirtualBox
Importing the Image in VirtualBox1:15
First boot5:18
First boot and setting up of initial system users that we are going to use through the course
VirtualBox Tips6:35
Networking tips and shutting down the box with preserving the state of it
Configuring Windows host file2:35
How to configure hosts file (win or linux) so we can access particular IP address over URI
Connecting to box from SSH/sFTP Tool4:46
How to make SSH/sFTP connection to VirtualBox running VM
Configuration Before First Use12:01
All of the necessary steps to enable access to the EBS Appliance
Accessing E-Business Suite from Browser2:31
How we'll be accessing EBS from browser
How to Start DB and Apps Tiers2:21
What to do in case your machine has been powered off and the DB, mid and apps tiers are down (EBS not accessible)
Accessing Forms3:02
Things to do to be able to access Oracle EBS Forms
Access Database with SQLDeveloper3:11
How to enable DB access and connecting to it from SQLDeveloper app
Access WebLogic Console4:59
How to enable access and hot to access the WebLogic Console
Section Summary1:18
Section summary, what we achieved with this section....

Creating New Users + Demo Vision Users7:20
How to create new users through Forms (System Administrator responsibility) and accessing with demo users
Creating New User Through API3:25
Create an user with PLSQL API call
Creating New Request Group4:48
Creating a Request group - A list of programs that can be assigned to responsibility to be accessible from it.
Creating New Functions and Menus9:01
Steps on creating Menus and Functions for menu items
Creating New Responsibility and Assigning it5:51
Creating new Responsibility and assigning it to our newly created user, so he can have some functionalities when logged in.
Basics around Users and its accessibilities
Reponsibility, Request Group... APIs0:54
Useful API code snippets for this section.

Profile Options7:10
What are profile options and how to create custom ones
Profile Options - Fetching from Backend and FNDLOAD6:30
Ways on fetching profile option values + download definition of it
Profile Options from Functional Administrator2:41
Different Access for Profile Options
Profile Options - SQL Validation6:58
How to make list of values for profile options with special validation SQL
Messages6:01
How to create custom messages and use them
Lookups5:49
What are and how to create lookups
Misc EBS Components

What are Workflows?2:26
Definition of workflows and why we should use it.
Install Workflow Builder2:28
Where to get Workflow Builder
Create Basic Workflow7:16
Creating simple workflow in Workflow Builder with PLSQL background logic
Using WFLOAD6:19
Ways on uploading workflow to environment
Starting Workflow Manually1:57
How to start workflow process manually from frontend
Checking Status of a Started Workflow2:26
Starting Workflow from PL/SQL5:57
How to initiate workflow process from backend
Workflow Definitions Loader5:05
Alternate (from Java Forms) way of uploading/downloading workflows

Requirements

Basic knowledge of Information Technology
Basic SQL/PLSQL (but all the code is provided in the resources)

Description

Oracle E-Business Suite (EBS) is a set of combined business applications that are provided by Oracle. It’s often referred to as, Oracle EBS, Oracle ERP or E-Biz. It consists of multiple enterprise applications that help large businesses with all kinds of processes in fields of Finance, Human Resources, Supply Chain, Procurement, Order Management, Warehouse Management, Resource Planning, Expenses, Customer Relations, Leave & Absence, Reporting and much more, with the ability to extend the system according to customer needs.

EBS is used across the globe by large number of big companies and has a long term support from Oracle.

Participants of this course will learn how to have fully running Oracle e-Business Suite instance on their own machine over Virtual Machine. This Virtual instance will also have sample data with which users can play around, test it and develop around it. The course guides participants in depth with steps to have this instance running on their machine with step-by-step resources.

Even if you have access to some development or test environment where e-Business Suite is present you can benefit from this course as it covers various development and functional topics.

The course covers creating custom tops, how to get around must know EBS functionalities, creating concurrent programs from scratch, more advanced topics around Concurrent Programs, migration of extensions between environments, about different EBS components and how to create them, Workflows with Workflow Builder, Oracle Application Framework with jDeveloper, Building reports with XML Publisher, Creating Custom WebADI (Application Desktop Integrator),even Oracle Apex and how to connect it to EBS.

So regardless if you are developer, functional person, database administrator or just curious regarding Oracle e-Business Suite, you can find something for yourself.

Who this course is for:

Functional Implementer
Business Analyst
Technical Consultant
End Users
EBS Developers
DBAs
Anyone who want to learn an ERP Application

Oracle E-Business Suite VM Install and Developer Essentials

What you'll learn

Explore related topics

Course content

Introduction3 lectures • 6min

Necessary Tools and Files4 lectures • 11min

E-Business Suite Setup on Virtual Machine14 lectures • 1hr

Creating a Custom Application in Oracle E-Business Suite Release 12.1.3 and abov3 lectures • 21min

Basics Around EBS Users and Associated Items6 lectures • 31min

Concurrent Programs4 lectures • 19min

Using FNDLOAD3 lectures • 11min

Misc EBS Components6 lectures • 35min

eTRM - Electronic Technical Reference Manual1 lecture • 3min

Workflows8 lectures • 34min

Requirements

Description

Who this course is for: