get app

    Oracle Apps R12 Technical Training Bundle Technical D2K

    BY
    Udemy

    Acquire a comprehensive understanding of the core concepts and principles associated with Oracle Apps R12 technicals including SQL, PL/SQL, and D2K.

    Brochure Enquire
    Mode

    Online

    Fees

    ₹ 799

    Quick Facts

    particular details
    Medium of instructions English
    Mode of learning Self study
    Mode of Delivery Video and Text Based

    Course overview

    Oracle Apps R12 Technical Training Bundle (Technical, D2K) online certification is developed by Koduru Sridevi - Certified Oracle Apps & Fusion Techno-Functional Consultant & Trainer and is delivered by Udemy and is designed for candidates who want to become Oracle Apps specialists to advance in their professional careers. The Oracle Apps R12 Technical Training Bundle (Technical, D2K) online course focuses on teaching the fundamentals of Oracle SQL, Oracle PL/SQL, and Oracle D2K.

    Oracle Apps R12 Technical Training Bundle (Technical, D2K) online classes provide an in-depth explanation of the technical aspects of data integration and help applicants grasp the architecture, table relationships, and generating reports and dashboards utilizing Oracle Apps. This course covers a wide range of Oracle Apps R12 technical subjects, including system administration, application object library, flex fields, conversions, data connections, interfaces, clauses, queries, value sets, multi-org concepts, custom object registration, and much more.

    The highlights

    • Certificate of completion
    • Self-paced course
    • 35.5 hours of pre-recorded video content
    • 1 article
    • 5 downloadable resources

    Program offerings

    • Online course
    • Learning resources. 30-day money-back guarantee
    • Unlimited access
    • Accessible on mobile devices and tv

    Course and certificate fees

    Fees information
    ₹ 799
    certificate availability

    Yes

    certificate providing authority

    Udemy

    What you will learn

    After completing the Oracle Apps R12 Technical Training Bundle (Technical, D2K) certification course, candidates will gain a better understanding of the Oracle Apps R12 features. Candidates will learn the principles of SQL, PL/SQL, and D2K, as well as the differences between subqueries and clauses in SQL. Candidates will acquire knowledge of system administration, application object library, flex fields, interfaces, triggers, and conversions strategies. Candidates will learn how to work with data linkages and a variety of commands such as DDL, DCL, DML, and TCL.

    The syllabus

    D2K (Oracle Forms & Reports 10g) Course

    • Oracle D2K | Oracle Forms and Reports Demo Session
    • Introduction to Forms 10g and Role in Oracle Apps, Fundamentals of D2K
    • Creation of Data blocks Through wizard and Manually
    • Different types of Triggers
    • Creation of alerts and Calling of Alerts
    • Creation of Editors, Types of Editors and Calling editors through Code
    • Creating and Using Object Groups, Creating and Using Object Libraries
    • Creation of Lov through wizard and Manually
    • Creation of Master-Detail Data Blocks parameters
    • Creation of Menus and attaching menus to Forms
    • Working with Procedures, Functions and Packages in Forms
    • Introduction to Reports, Fundamentals of Reports
    • Creation of Different types of Reports
    • Working with Formula Columns, Working with Summary Columns
    • Working with Data Links
    • Developing Reports Manually
    • Reports in Triggers
    • Creation of Layout in Reports, Drill Down Reports

    Oracle Apps R12 Technical Course

    • Oracle Apps R12 Technical Course Demo
    • Definition of ERP, Introduction to Oracle Applications, Types of Data
    • Functional Consultant and Roles, Technical Consultant and Roles
    • Oracle Application Architecture, Data Base Structure of Oracle Application
    • System Administration and Application Object Library (AOL)
    • FND Tables and Understanding AOL and its Components
    • Report Registration Steps, Register the Report in AOL Module
    • Defining the Concurrent Program, Creation of Request Group
    • Register the Parametric Report in AOL Module, Introduction to Report Parameters
    • Developing a Report from Scratch
    • Introduction to Forms, Form registration in Oracle Applications
    • Creating Functions in AOL Module, Creation of New Menu
    • Introduction to Template.FMB, Appstand.FMB
    • Creating of New Template, Creating of New Block, Canvas in Template
    • Overview of Flex Fields, Types of Flex Fields
    • Steps for Creation of DFF, Flex Field Tables, and Relations
    • Overview of Profiles Options, Different Levels in Setting Profiles
    • Multiple Organization Concepts, Introduction to Multi Org, What is Multi Org
    • Defining Multi Org Structure Continued
    • Multi Org Tables, Overview of Procure to Pay (P2P Cycle)
    • Introduction to Interfaces, Difference between Interfaces and Conversions
    • Working with Staging Table Scripts, Developing Validations Package
    • Introduction to Conversions, Conversion Flow
    • Introduction to AIM Documentation
    • Introduction to Business Documents
    • Functional Flows of GL, AP, AR
    • Introduction of XML Reports, Developing XML Reports
    • Steps for Registering the XML Reports in AOL Module
    • Oracle Apps R12 Technical Course Demo
    • Oracle Application Architecture, Data Base Structure of Oracle Applications
    • Introduction to Business Documents

    Oracle SQL & PL/SQL Course

    • Introduction to RDBMS
    • Oracle data types
    • DDL and DML Commands
    • DDL and DML Commands Continued
    • Integrity Constraints
    • SQL Functions, Character Functions, Number Functions
    • SQL Functions Continued, Date Functions, Group Functions
    • Introduction to PL/SQL
    • Joins
    • Sub Queries and Clauses
    • Database Objects
    • Database Objects Continued
    • DCL and TCL Commands
    • Data Types and PL/SQL Blocks
    • Looping Structures
    • Looping Structure While and Nested Loops
    • Looping Structure While and Nested Loops Continued
    • Conditional Statements
    • Cursors
    • Exceptions
    • Exceptions Continued
    • Procedures
    • Functions
    • Packages

    Study Material

    Instructors

    Ms Koduru Sridevi

    Ms Koduru Sridevi
    Trainer
    Udemy

    Trending Courses

    Digital Marketing Courses Fashion Design Courses Data Science Courses Interior Design Courses Graphic Designing Courses Cyber Security Courses Nursing Courses Tally Courses Data Analysis Courses Web Designing Courses Artificial Intelligence Courses Ethical Hacking Courses Free Digital Marketing Courses And certifications Free Artificial Intelligence Courses And Certifications Free Data Analysis Courses And Certifications Free Cyber Security Courses And Certifications Free Data Science Courses And Certifications Free Cloud Computing Courses And Certifications Free Python Courses And Certifications Free Fashion And Textiles Courses And Certifications Free Graphic Designing Courses And Certifications Free Web Designing Courses And Certifications

    Popular Courses

    General Management Courses Public Health Courses Teaching and Education Courses Financial Management Courses Web Development Courses Mathematics Courses Data Science Courses Cyber Security Courses Programming Courses Digital Marketing Courses Law Courses Leadership Courses Explore all courses

    Popular Platforms

    upGrad Courses Udemy Courses Edx Courses Swayam Courses Coursera Courses Futurelearn Courses Mindmajix Technologies Courses Vskills Courses IIT Kharagpur Courses Emeritus Courses IIT Kanpur Courses NPTEL Courses Explore all platforms

    Learn more about the Courses

    10 Reasons to Enrol Yourself in a Digital Marketing Course 8 Must-Have Skills for AWS Cloud Architects Planning to Upskill Yourself? Enrol for a Program in Data Science 25+ Tips for Improving Your Graphic Design Skills Top Universities in India Offering Cyber Security Courses 15+ Courses for Learning Data Mining How to Make a Career in the Field of Artificial Intelligence Top 10 Benefits Of Holding A Certification In Business Intelligence Which are the best certification courses for Photography in India A Beginner's Guide to Pursue Python Programming Want to Pursue a Career in Blockchain Technology? Here is all that you need to Know How Entrepreneurs Can Use Machine Learning to Make their Business Successful? The Scope of Artificial Intelligence in India Top 10 Online Courses for Travel Lovers 10 Best Certification Courses After Hospital and Healthcare Management
    Providers
    Close

    Download the Careers360 App on your Android phone

    Regular exam updates, QnA, Predictors, College Applications & E-books now on your Mobile

    Careers360 App
    150M+ Students
    30,000+ Colleges
    500+ Exams
    1500+ E-books