Archives
now browsing by author
Oracle Apps Technical Course + Interview Questions Videos
Oracle Apps R12 Technical Course + Interview Questions Course Bundle
Oracle Apps Technical Course + Interview Questions Course Bundle Contains 65 Session Videos of 26 hrs of Recordings
You can buy from the below link and get 25% OFF when you buy the videos from Udemy for $35 / 2,400 INR on your purchase
https://www.udemy.com/course/oracle-apps-technical-course-and-interview-questions/?couponCode=OATANDIQ
Oracle Apps Technical Course + Interview Questions Explained Clearly through Videos Course Bundle Consists of
1. Oracle Apps R12 Technical Course
2. Interview Questions on Oracle Apps R12 Technical Explained through Videos
Please find the below details
1. Oracle Apps R12 Technical Online Training Videos
Oracle Apps R12 Technical is the Enterprise Resource Package (ERP) package. It has designed on the base of Generally Acceptable Accounting Principles (GAAP). This Oracle Application has the business software or else application software of the Oracle Corporation.
Oracle Apps Technical Course is a collection of complete end-to-end solutions that serve businesses with their own functionality. Oracle Apps Technical Video Tutorials Course provides an in-depth explanation on the technical module of data integration. This module makes you understand the architecture, table relations, designing reports and forms using Oracle Apps.
From oracle apps technical course content, you get a clear idea of
Types of Roles, Application Object Library, Application Development, Registration of Custom Objects, Interfaces and Conversions, Flex fields, Profiles, Value Sets, Multi-org Concepts, Functional Modules Overview, Reports and Forms in Oracle Applications and development of XML Reports.
There are incredible job opportunities for the desired aspirants with highest paid salary range. It will be a great career advantage by taking Oracle Apps Technical Course.
Who should take this oracle Apps technical course
Any Professional with Basic Knowledge on SQL and PL/SQL
2. Oracle Apps Technical Interview Questions are Clearly Explained through 40+ Videos
What is ERP
What is Architecture of ERP
What are the Different Types of API’S for Customer Interface
What are the Parameters in PLSQL Stored Procedures
What are the Steps Required for Customizing the Form
What are the Steps Required for Attaching Report with Oracle Applications
What is Data Link
In which Tables the Flexfields are Stored
What is the Difference Between Key Flexfield and Descriptive Flexfield
Which Procedure should be called to enable a Descriptive Flexfield
What is the Difference between Flexfield Qualifier and Segment Qualifier
Where do the Concurrent Request Logfile and Output file go
What is Apps Schema. Differentiate Apps Schema and other Schemas
What is the Purpose of US Folder in Appl Directory
Explain Custom.pll, forms, reports, sql loader, control file
When will we use custom.pll
How do you find whether Multiorg is Installed
What are the Data Handlers
What are the Steps for Customizing the Standard Oracle Report
Difference between Bind Parameter and Lexical Parameter
How to find the Report short name for customizing the report
what is the structure of visappl
How to migrate the custom tables from 11.5.10 to r12
What is the Difference between Conversion and Interface
How to register a table and columns through backend
Explain the Functions fnd_req, submit_req
What are Cursors, where we have to use
Explain about the Report triggers
What is token
What are the Steps Required for Registering the Report into Apps
What are Security Attributes, Profiles
What are the Steps for Developing the Flexfields
What are Profile Options. At what level we setup the profile options
How can you know the form(fmb) name
What is the Relation between Responsibility, Menu and Request Group
What is a Function, Appl_top
What are the Supported Version of Forms and Reports Used for Developing an Oracle Apps Release 11i/r12
What is the responsibility, request group, dff
What is a Data Group and where we have to use
What is Responsibility
What is E Business Suite
What are Different Types of Responsibilities
What is a Template
What is the adhoc report
What is Value Set
What are the Different Validations Types
What is Multi Org Structure
What is the Maximum number of records we can display in one page in xml reports
What is Primary Ledger
How can we call standard interface program
Where can you find the release name from backend
Tell me what are the base tables in AR Module
Where do we create tables, sequence
Where do we create views, procedures and new profile options
What is Formula Column and Summary Column
TCA (Trading Community Architecture)
What is Flex Mode and Confine Mode
What is Place holder Column
What is Apps Architecture
What are the API’s
Difference between Application Developer and System Administrator
Use of Triggers in Forms and Types of Triggers
What is TCA (Trading Community Architecture)
Difference Between Inbound and Outbound Interfaces
Form Personalization
What is MRC (Multiple Reporting Currency)
What are the Different Types of Interfaces
What is the Difference between Operating Unit and Inventory Organization
What is Item Validation Organization
Oracle Apps R12 Technical Interview Questions Videos
Oracle Apps R12 Technical Interview Questions Videos Course
Oracle Apps R12 Technical Interview Questions Videos Course contains 40+ Session Videos of 9 Hours of Recordings.
You can buy from the below link and get 75% OFF when you buy the videos from Udemy for $21 / 1,440 INR on your purchase
https://www.udemy.com/course/oracle-apps-technical-interview-questions/?couponCode=OATIQNEW
Oracle Apps Technical Interview Questions are Clearly Explained through Videos
What is ERP
What is Architecture of ERP
What are the Different Types of API’S for Customer Interface
What are the Parameters in PLSQL Stored Procedures
What are the Steps Required for Customizing the Form
What are the Steps Required for Attaching Report with Oracle Applications
What is Data Link
In which Tables the Flexfields are Stored
What is the Difference Between Key Flexfield and Descriptive Flexfield
Which Procedure should be called to enable a Descriptive Flexfield
What is the Difference between Flexfield Qualifier and Segment Qualifier
Where do the Concurrent Request Logfile and Output file go
What is Apps Schema. Differentiate Apps Schema and other Schemas
What is the Purpose of US Folder in Appl Directory
Explain Custom.pll, forms, reports, sql loader, control file
When will we use custom.pll
How do you find whether Multiorg is Installed
What are the Data Handlers
What are the Steps for Customizing the Standard Oracle Report
Difference between Bind Parameter and Lexical Parameter
How to find the Report short name for customizing the report
what is the structure of visappl
How to migrate the custom tables from 11.5.10 to r12
What is the Difference between Conversion and Interface
How to register a table and columns through backend
Explain the Functions fnd_req, submit_req
What are Cursors, where we have to use
Explain about the Report triggers
What is token
What are the Steps Required for Registering the Report into Apps
What are Security Attributes, Profiles
What are the Steps for Developing the Flexfields
What are Profile Options. At what level we setup the profile options
How can you know the form(fmb) name
What is the Relation between Responsibility, Menu and Request Group
What is a Function, Appl_top
What are the Supported Version of Forms and Reports Used for Developing an Oracle Apps Release 11i/r12
What is the responsibility, request group, dff
What is a Data Group and where we have to use
What is Responsibility
What is E Business Suite
What are Different Types of Responsibilities
What is a Template
What is the adhoc report
What is Value Set
What are the Different Validations Types
What is Multi Org Structure
What is the Maximum number of records we can display in one page in xml reports
What is Primary Ledger
How can we call standard interface program
Where can you find the release name from backend
Tell me what are the base tables in AR Module
Where do we create tables, sequence
Where do we create views, procedures and new profile options
What is Formula Column and Summary Column
TCA (Trading Community Architecture)
What is Flex Mode and Confine Mode
What is Place holder Column
What is Apps Architecture
What are the API’s
Difference between Application Developer and System Administrator
Use of Triggers in Forms and Types of Triggers
What is TCA (Trading Community Architecture)
Difference Between Inbound and Outbound Interfaces
Form Personalization
What is MRC (Multiple Reporting Currency)
What are the Different Types of Interfaces
What is the Difference between Operating Unit and Inventory Organization
What is Item Validation Organization
Who should take this oracle Apps technical course
Any Professional with Basic Knowledge on SQL and PL/SQL
Oracle Fusion Financials Online Training(One to One)
Oracle R13 Fusion Financials Online Training(One to One Online Training)
Duration : 40 Sessions
Each Session Duration : 1 Hr
Oracle Fusion Financials Course Content
Introduction to Fusion Financials
. Fusion Financials vs Oracle Apps Financials
Introduction to Oracle Fusion Enterprise Structure
. Enterprise Structure Definition
. Rapid Implementation using Spreadsheets
. Data Imports & Exports Process in FSM
. Third Party Application Integration with Fusion Cloud Applications
. Invoice Imaging Solution
. Querying data from Database
. BPM Approvals
Oracle Fusion Functional Setup Manager (FSM)
. Introduction to Functional Setup Manager (FSM)
. Understanding Application Implementation Process through FSM
. Understanding Offerings
. Understanding Options
. Enabling Offerings
. Implementation Project Creation
. Task Assignments to Team Members
. Status Tracking
. Understating Task Lists/Tasks
. Overview on Offerings Documentation
. Overview on Rapid Implementation Process
Oracle Fusion General Ledger
General Ledger Basic Configuration
. Create Accounting Calendar
. Create/Enable Currencies
. Create Value Sets
. Create Chart of Accounts
. Create Chart of Accounts Instance
. Create Primary Ledger
. Setup Ledger Options
. Create Legal Entity
. Complete Primary Ledger Definition
. Review General Ledger Role Template
. Assign Data Roles to User
. Run LDAP Job
. Open GL Periods
. Account Hierarchy Creation
Transaction Process
. Understanding Role Based Dashboards
. Create Journals & Post
. Journal Approval Configuration & Testing
. Create Journals in ADFdi
. Loading Journals from FBDI Templates
. Foreign Currency Journals Setups & Process
. Reverse Journals Setups & Process
. Data Access Set Setups & Process
. Security Rules Setups & Process
. Cross Validation Rules Setups & Process
. Create Ledger Set Setups & Process
. Create Reporting Ledger/Reporting Currency Setups & Process
. Create Secondary Ledger Setups & Process
. Auto Posting Setups & Process
. Auto Reversal Setups & Process
. Revaluation Setups & Process
. Translation Setups & Process
. Consolidation Setups & Process
. Generating Reports from Financial Reporting Studio (FRS)
. Generating Reports from Smart View
. Generating Reports from Account Inspector
. Generating Reports Account Monitor
. GL Period Close Process
Oracle Fusion Purchasing
Purchasing Configuration
. Create Inventory Location
. Assign Business Unit Business Function for Procurement
. Define Facilities for Procurement
– Facility Shifts
– Facility Workday Pattern
– Facility Schedules
. Create Item Master Inventory Organization
. Create Actual Inventory Organization
. Configure Procurement Business Function
. Configure Requisitioning Business Function
. Manage Common Options for Payables and Procurement
. Receiving Parameters
. Procurement Agent
. Manage Transaction Account Definitions
. Manage Account Rules
. Transaction Account Definition
. Setting Subledger Accounting Options
. Create Approval Group
. Manage Purchasing Document Approvals – Setup Approvals – Parallel
. Assign Data Roles to User
. Run LDAP Job for Roles Synchronization
Transaction Process
. Purchase Order Creation & Approvals
. Create Invoice in AP Matching PO
Oracle Fusion Accounts Payables
Payables Basic Configuration
. Create Business Unit Locations
. Create Reference Data Sets
. Create Business Units
. Assign Business Unit Functions to Business Unit
. Create Legislative Data Group
. Assign Legislative Data Group to LE
. Create Employee User
. Assign Implementation Consultant Roles to User
. Create Procurement Agents
. Common Options for Payables and Procurement
. Invoice Options Configuration
. Payment Options Configuration
. Create Payment Terms
. Create Distribution Sets
. Setting up Suppliers Number
. Assign Supplier Roles to User
. Create Supplier
. Create Supplier Addresses
. Create Supplier Sites
. Assigning Supplier Sites to Procurement Business Units
. Create Banks
. Create Branches
. Create Bank Accounts
. Create Payables Documents
. Create Payment Method
. Defining Payment Formats
. Create Payment Process Profile
. Introduction to Payables Role Templates
. Assigning Data Roles to User
. Submitting LDAP Job
. Open Payables Periods
Transaction Process:
. Standard Invoice Creation
. PO Based Invoice Creation
. Invoice Creation via Spreadsheet
. Debit Memo Invoice Creation
. Credit Memo Invoice Creation
. Payment Creation Process
. Creating Payment Process Request
. Prepayment Invoice Process
. Withholding Tax Setups & Process
. Bills Payables Configuration & Process
. Pay Alone Configuration & Process
. Foreign Currency Invoice & Payment Configuration & Process
. Supplier Merge Process
. Interest Invoice Configuration & Process
. Recurring Invoice Configuration & Process
. Third Party Payments Configuration & Process
. Cross Currency Payments Configuration & Process
. Invoice Approval Configuration & Testing
. Security Profile Configuration & Testing
. Create Hold & Release Reason
. Supplier Refund Process
. Create Aging Periods & Testing
. Custom Job, Duty, Data Roles Creation
. File Based Data Import (FBDI) Process – Suppliers Conversion Process
. File Based Data Import (FBDI) Process – Open Invoices Conversion Process
. Creating Accounting Entries & Transferring to GL
. Payables Period Close Process
. Payables to General Ledger Reconciliation
. Creating BI Reports
. Creating OTBI Reports
Oracle Fusion Accounts Receivables
Receivables Basic Configuration
. Receivables System Options Configuration
. Define Transaction Types
. Define Transaction Sources
. Auto Accounting Configuration
. Create Payment Terms
. Create Statement Cycles
. Collector Creation
. Create Customer Profile Class
. Create Reference Data Set for Customer Site
. Create Customer
. Create Customer Site/Address
. Create Remit-to-Address
. Memo Lines Creation
. Create Receivable Activities
. Create Receipt Classes & Methods
. Create Receipt Source
. Overview on AR Role Template
. Assign Receivables Data Roles to User
. Submitting LDAP Job
. Open Receivables Periods
Transaction Process:
. Invoice Transaction Creation
. Credit Memo Transaction Creation
. Debit Memo Transaction Creation
. Transaction with Memo Lines
. Chargeback Setups & Transaction Creation
. Standard Receipt Creation
. Misc. Receipt Setups & Process
. Receipt/Batch Creation in Spreadsheet & Process
. Standard Receipt Reversal
. Debit Memo Receipt Reversal
. Reciprocal Customers Configuration & Process
. Cross Currency Receipts Configuration & Process
. Receipt Write-Off Configuration & Process
. Customer Refund Configuration & Process
. Aging Methods/Buckets & Testing
. Revenue Reorganization Configuration & Process
. Create Automatic Receipts
. Balance Forward Billing Configuration & Process
. Reviewing Customer Account Details
. File Based Data Import (FBDI) Process – Customers Conversion Process
. File Based Data Import (FBDI) Process – AutoInvoice Conversion Process
. Create Accounting Entries & Transfer to GL
. Receivables Period Close Process
. Receivables to General Ledger Reconciliation
Oracle Fusion Fixed Assets
Fixed Assets Configuration
. Create Value Sets for Category KFF
. Create Value Sets for Location KFF
. Create Value Sets for Asset Key KFF
. Create Category KFF Structure
. Create Location KFF Structure
. Create Asset Key KFF Structure
. Create Category KFF Structure Instance
. Create Location KFF Structure Instance
. Create Asset Key KFF Structure Instance
. Create Segment Values to 3 KFF Segments
. Configure System Controls
. Create Fiscal Year Calendar
. Create Asset Calendar
. Define Prorate Convention
. Create Prorate Calendar
. Create Asset Book
. Create Tax Book
. Create Asset Categories
. Overview on Asset Book Role Template
. Assign Data Roles to User
Transaction Process
. Manual Additions
. Asset Creation using Spreadsheet/ADFdi
. Mass Additions
. Merge Asset Lines
. Split Asset Lines
. CIP Asset & CIP Capitalization
. Reclassification
. Run Depreciation (Draft/Final)
. Mass Copy
. What-if Analysis
. Rollback Depreciation
. Asset Retirement
. Asset Reinstatements
. File Based Data Import (FBDI) Process – Assets
. Create Accounting Entries & Transfer to GL
. Assets Period Close Process
. Assets to General Ledger Reconciliation
Oracle Fusion Cash Management
. Cash Management Basic Configurations
Transaction Process
. Manual Bank Statement Creation
. Manual Reconciliation
. Automatic Reconciliation
. Generating External Cash Transactions – Automatic
. Creating External Cash Transactions – Manual
D5 Creation