D2K | DEVELOPER 2000 | ORACLE FORMS AND REPORTS TRAINING ONLINE

D2K | DEVELOPER 2000 | ORACLE FORMS AND REPORTS TRAINING ONLINE

 

Schedule/Purchase	Training Formats	Price	Duration	Course Materials	Language
	Live Virtual Class	12000 INR	Full Week	English	English

 

 

• What You Will Learn
• Audience
• Course Topics
• Course Objectives

Forms 10g

. Introduction and Role in Oracle APPS
. Fundamentals of D2K

Types of Blocks

. Creation of blocks Through wizard and Manually
. Creation of Master-Detail Data Blocks

Canvases

. Creation of Different Types of Canvases and Working with Canvases

Windows

. Types of windows and working with windows and changing windows properties

Triggers in Forms

. Different types of Triggers
. Working with Triggers and Applying to Different Controls

Alerts

. Creation of alerts and Calling of Alerts Changing Properties at runtime and Re-using Alerts

Editors

Creation of Editors, Types of Editors and Calling editors through Code

Creation of Object Groups

. Creating and Using Object Groups
. Creating and Using Object Libraries

Using Image Items

. Storing and Retrieving Images
. Working With Image Items

Record Groups

. Creation of Record Groups Based On Query and Using Static Values

Lovs

. Creation of Lov through wizard and Manually
. Working with Lov Properties

Menus

. Creation of Menus, popup Menus and attaching menus to Forms

Program Units

. Working with Procedures, Functions and Packages in Forms

PL/SQL Libraries

. Usage of PL/SQL Libraries in Forms and Attached Libraries
. Using Database Objects and Creating Database objects through forms.

Reports 10g

. Introduction
. Fundamentals of Reports
. Advantages, Features and role of Reports in D2K

Creation of Reports using Wizards

. Creation of Different types of Reports
. Creation of Reports Manually
. Creation of Reports with different Parameters
. User Parameters
. System Parameters
. Manual Reports
. Creation of Reports through Data Model SQL Query
. Working with Formula Columns
. Working with Summary Columns
. Working with Place Holder Columns
. Working with Data links
. Working with Cross Products
. Creating Report With Parameters

Reports in Triggers

. Before Parameter Form
. After Parameter Form
. Before Report
. Between Pages
. After Report

Creation of Templates

. Creation of Layout in Reports
. Drill Down Reports
. Calling Reports from Forms
. Calling Reports from Reports

Opraprofiles links:-

Facebook

Twitter

LinkedIn

Google+

Youtube

Pinterest

ORACLE APPS TECHNICAL WEEK END ONLINE TRAINING (ONE TO ONE ONLINE TRAINING)

Schedule/Purchase	Training Formats	Price	Duration	Course Materials	Language
	Live Virtual Class	25000 INR	Week Ends	English	English

• What You Will Learn
• Audience
• Course Topics
• Course Objectives
• Related Training

Introduction to ERP

• Definition of ERP
• Overview of popular ERP’S
• Comparison of Oracle Apps with other ERP’S
• AIM documentation standards
• Oracle Application Architecture.
• Database structure of OA
• Using TOAD

Types of Roles

• Functional Consultant and Roles
• Technical Consultant and Roles
• Techno-Functional Consultant and Roles
• Oracle Application DBA and Roles

Application Object Library

• System Administration and Application Object Library (AOL)
• Defining an Applications User and Assigning the Responsibilities.
• Understanding AOL and its Components
• WHO columns
• Creating Responsibilities
• Request group creation
• Menu Creation

Application development

• Defining concurrent program
• Concurrent programs with parameters
• Working with multiple concurrent programs
• Concurrent Program incompatibilities
• Creating Request Set
• Default Types
• Value sets

Registration of Custom Objects

• Report registration
• Registration of a Table
• Using AD_DD Package to register Database Component in AOL

Interfaces and Conversions

• Introduction to Interfaces
• Difference Between Interfaces and Conversions
• Outbound Interfaces
o Using UTL_FILE package
• Inbound Interfaces
o Using SQL * Loader tool
• SQL * Loader Concepts o Data File.
o Control File.
o Bad File.
o Discard File.
o Log File.
• Working with staging table blocked
• Developing validations package
• Standards to be followed in conversions
• Using oracle API’s in Interfaces and Conversions
• Interface Tables and Error Tables

Flex Fields

• Overview of flex fields
• Types of Flex Fields
o Deblockedive Flex Fields
o Key Flex Fields
• Step in creation of DFF
• Flex fields tables and relations

Profiles

• Overview of profile options
• Different levels in Setting profiles
• Steps in setting a profile option
• Some important profile options
• Some important API’s of profiles

Value sets

• Overview of value sets
• Options in value sets
• Types of value sets
• Creation of value set
• Overview of value set tables
• Usage of $FLEX and $PROFILE

Multi Org Concepts

• What is Multi Org and why we need.
• Multi Org Tables.
• Multi Org Viiews.

Functional Modules Overview

• Overview of Procure to Pay Flow (P2P Cycle)
• Overview of Order to Cash Flow (O2C Cycle)
• Major setups and transactions
• Overview of important tables in PO,INV,OM,AP,AP,GL

Reports in Oracle Applications

• Introduction and Usage of USER_EXITS.
• Developing a Report from scratch as per Client Requirement.
• Developing a Report based on MD 50 Document.
• Customization of Oracle Standard Reports.
• Reports Registration Steps in Oracle Applications
• Standards to develop a report in Oracle Apps

Forms in Oracle Applications

• New Form Development Process
• Form Registration in Oracle Applications.
• Calling one Form to another Form by using Button
• Master-Detailed Forms
• Form Personalization in Oracle Applications
• Form Personalization v/s Form Customization

Development of XML Reports

Opraprofiles links:-

Facebook

Twitter

LinkedIn

Google+

Youtube

Pinterest

Fusion Incentive Compensation by oraprofiles

Fusion Incentive Compensation

Schedule/Purchase	Training Formats	Price	Duration	Course Materials	Language
	Live Virtual Class	15000 INR	Full Week	English	English

• What You Will Learn
• Audience
• Course Topics
• Course Objectives

S.No. Topics Sub Topics
1 Create Base Configuration for FIC 
1.1 Introduction of Incentive Compensation Tasks
1.2 Incentive Compensation Roles
1.3 Create Business Unit
1.4 Describe Flexfields
1.5 Manage Open Period Process, Calendars and Intervals
1.6 Manage Currencies
1.7 Describe Manage Parameters
1.8 Manage Participant Import
1.9 Configure Tables and Columns
2 Configure Incentive Compensation Plans 
2.1 Describe Plan Components and Compensation Plan
2.2 Define Rate Table, Rate Dimension Types
2.3 Define Expressions
2.4 Define Classification Rules and Credit Categories
2.5 Define Performance Measures
3 Assign and Credit Participant 
3.1 Create and Assign Participant Roles
3.2 Individualize Participant Plan
3.3 Define Credit and Rollup Rules
4 Transactions and Calculations 
4.1 Describe Transaction Lifecycle
4.2 Create Manual Transactions
4.3 Import, Collect and Upload Transactions
4.4 Manage Transaction Collection
4.5 Manage Calculation
5 Reports - OBIEE 
5.1 Run Standard Reports
5.2 Configure Reports

Opraprofiles links:-

Facebook

Twitter

LinkedIn

Google+

Youtube

Pinterest

Fusion territory management

Schedule/Purchase	Training Formats	Price	Duration	Course Materials	Language
	Live Virtual Class	12000 INR	Full Week	English	English

• What You Will Learn
• Audience
• Course Topics
• Course Objectives

Create Base Configuration for Territory management 
 Introduction of Territory Management
 Sales Roles
 Create Business Unit
 Describe Flexfields
 Manage Open Period Process, Calendars and Intervals
 Manage Currencies
 
Enable Dimensions 
 Enable Dimensions
 
 
Configure Proposal 
 Create Proposal
 Activate Proposal
 Publish Proposal
Link of Territory Management and Incentive Compensation Linkage of TM and IC

Opraprofiles links:-

Facebook

Twitter

LinkedIn

Google+

Youtube

Pinterest

Oracle apps forms by Oraprofiles

Oracle apps forms

                  

       Oracle {Forms|Types|Kinds|Varieties} isn't just about {data|information}-entry into an Oracle database any {more|much more|a lot more|far more}. {Using|Utilizing|Making use of|Employing} the {latest|newest|most recent|most current} {version|edition|model} you can {easily|effortlessly|very easily|simply} integrate with {nearly|almost|practically|virtually} any {modern|contemporary|modern day|present day} 

              Or legacy {technology|technologies|engineering|technological innovation} your application {requires|demands|needs|calls for}. {Whether|Whether or not|Regardless of whether|No matter whether} your application {needs|requirements|wants|demands} to {include|consist of|contain|incorporate} authentication {using|utilizing|making use of|employing} Oracle {Access|Accessibility|Entry} Manager, or communicating with {Web|Internet|Net|World wide web} {Services|Solutions|Providers|Companies}, or {running|operating|working} {reports|reviews} in Oracle {Reports|Reviews} or Oracle BI-Publisher, or even {working|operating|functioning|doing work} with Microsoft {Office|Workplace} {tools|resources|equipment}, Oracle {Forms|Types|Kinds|Varieties} can get the {job|occupation|work|task} {done|carried out|completed|accomplished}.  {Powerful|Potent|Effective|Strong} desktop applications delivered with the {easy|simple|straightforward|effortless} and scalability of a {web|internet|net|world wide web} applications.

Schedule/Purchase	Training Formats	Price	Duration	Course Materials	Language
	Live Virtual Class	15000 INR	Alternate Days	English	English

• What Will Learn
• Audience
• Course Topics
• Course Objectives

Day 1 : 6 Hours
Topics to be covered:
1) Introduction to OAF.
2) Jdeveloper Setup and Deployment.
3) MVC Architecture and Layers Implementations.
4) BC4J Objects.
5) Basic Hello World page
6) Concepts for List of values.
7) Development of pages incorporating LOV's and Picklists.
8) Search pages.
9) Labs

Day 2 : 6 Hours

Topics to be covered:
1) Advance Tables.
2) Entity Object based Create page and validations.
3) Delete Page.
4) Introduction to Regions and item styles.
5) Creation of new OAF Pages using different regions and item styles.
6) Event Capturing.
7) Labs

Day 3 : 6 Hours
Topics to be covered:
1) Partial Page Rendering
2) How to call Procedures and API's on OAF Page.
3) How to call Concurrent Programs.
4) Page Registration on Application (Commands and Steps).
5) Labs


Day 4 : 6 Hours
Topics to be covered:
1) Various Personalizations.
2) Extensions of VO and CO.
3) Embedding Custom regions into pages.
4) How to migrate personalizations from one instance to another.
5) Labs

Opraprofiles links:-

Facebook

Twitter

LinkedIn

Google+

Youtube

Pinterest

Oracle Advance Supply chain Planning (ASCP) Training by Oraprofiles

Oracle Advance Supply chain Planning (ASCP) Training

Advanced Supply Chain Planning

                            Make better decisions faster—around-the-clock—with a planning model that controls your entire supply chain.

• Evolve from MRP to modern, highly configurable integrated material and capacity planning
• Model the complexities of your supply chain to make better decisions
• Reduce planning cycle time with automation and optimization
• Increase planner productivity with robust exception management and root cause analysis

• What You Will Learn
• Audience
• Course Topics
• Course Objectives

 Identify planning business issues

· Describe key capabilities of Oracle Advanced Supply Chain Planning 

· Explain efficiencies achieved by implementing Oracle Advanced Supply Chain Planning 

· Identify key constraints that influence distribution planning decisions and how to meet them 

· Explain key benefits of using distribution planning 

· Explain integration of distribution planning with other Oracle APS suite products 

· Explain usefulness of different plan types 

· Identify plan classes based on scenarios 

· Identify differences in implementation progression by plan class 

· Describe planning business flow 

· Describe planning data flow

Unconstrained Plans 

· Describe planning concepts

· Create unconstrained plans 

· Launch unconstrained plans

Constrained Plans

· Create demand priority rules

· Create and assign calendars 

· Set constrained plan options 

· Set aggregation levels 

· Run constrained plan 

· View material constraints 

· View resource constraints

Constrained Plans - Enforce Capacity Constraints with Decision Rules 

· Describe Enforce Capacity Constraints with Decision rule plans

· Interpret End item substitution/Substitution components 

· Setup and use Alternate resources/BOMs/Routings 

· Planning Decision rule hierarchy

Global Forecasting

· Describe global forecasting

· Spreading Global Forecasts 

· Consuming Global Forecasts 

· Recommending Sales Order changes

Planning Information and Planner Workbench 

· Explain the significance of various types of data used for planning 

· Explain key functionalities of planner workbench 

· Describe how to research data for planning 

· Describe planning results 

· Describe planner strategies 

· Copy and manage plans

Modeling the Supply Chain 

· Analyze enterprise data

· Analyze organization structure 

· Review planning approach 

· Analyze item information 

· View Bill of material data 

· Explain types of BOM 

· Create and Maintain BOM 

· Create and maintain Routing & Resources 

· Explain Engineering change order (ECO) and its process 

· Analyze sourcing information 

· View supplier data 

· Define lead time 

· Review organization relationship 

· Model the supply chain 

· Describe the usage of MRP plan versus Master Production Plan and Master Production Schedule 

· Describe the benefits of Holistic Plans

Querying Supply Chain Plan Information

· Create personal and public queries

· Manage personal and public queries 

· Create order queries 

· Manage order queries

Constrained Plans - Enforce Demand Due Dates

· Describe Enforce Demand Due Dates constrained plans

· Describe exceptions out of Enforce Demand Due Date Plans

Integrating Advanced Supply Chain Planning with Other Oracle Applications

· Describe the types of manufacturing environments that are integrated with ASCP

· Describe the integration points between ASCP and Oracle Project Manufacturing 

· Describe the integration points between ASCP and Oracle Process Manufacturing 

· Describe the integration points between ASCP and Oracle Flow Manufacturing 

· Describe the integration points between ASCP and Demantra demand Management 

· Describe the integration points between ASCP and Production scheduling 

· Describe the integration points between ASCP and SNO

Demand and Supply 

Opraprofiles links:-

Facebook

Twitter

LinkedIn

Google+

Youtube

Pinterest