Oracle Apps R12 Technical & Financials Interview Q&A Videos

Oracle Apps R12 Technical & Financials Interview Questions & Answers Videos

Ratings: 4.00 / 5.00




Description

Oracle Apps R12 Technical & Financials Interview Questions and Answers


  • 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


  • What is XML Report. Difference between BI Publisher and XML


  • How do you Display the Company Logo


  • What is a Data Template


  • Name Some Business Cases in BI Reports


  • What is the Role of Work Flow in Oracle Applications


  • How We Can Download the Work Flow Files from Oracle Applications without Backend


  • What are the Steps Involved in Developing of Oracle Work Flow


  • What is Work Flow and Benefit's of Using Work Flow


  • What is Performer in Oracle Work Flow


  • Where do you Register Data and Layout Templates


  • What does Lexical Section Contains


  • How Do You Move Your Layout and Data Template Across Instances


  • How many flex fields are there in Oracle Financials


  • What are the benefits of flex fields


  • What is segment qualifier


  • Implication of dynamic inserts


  • What is key flex field qualifier


  • Types of key flex field qualifiers


  • What is short hand aliases


  • What is a period in oracle general ledger and types of periods


  • What is value set security type


  • What are the types of value sets


  • What are the cross validating rules


  • What is a value set and value set list types


  • What are the types of flex fields


  • Difference between key and descriptive flex fields


  • What are the essential components of GL primary ledger


  • What are concepts used during definition


  • How many types of conversion rates are there in general ledger


  • What is retained earnings account


  • What is the purpose of translation adjustment account


  • Different statuses of accounting periods


  • What is a adjusting period and its implication


  • What are the steps for creating primary ledger


  • Ledger options


  • What are the journal types


  • Integrating journal entries with general ledger module


  • Define Accounting cycle


  • What is accounts payable


  • What is the meaning of invoice


  • P2P cycle flow


  • Sample process flow for p2p cycle


  • Pay cycle


  • How many types of purchase orders and agreements are there


  • Difference between AP invoice and AR invoice


  • What is invoice


  • Types of invoice


  • Difference between standard invoice and mixed invoice


  • What is pre payment in AP


  • Types of AP invoices


  • Difference between debit memo and credit memo


  • What is invoice validation process


  • Explain the receipt routing methods


  • What are the purchasing modes in receiving


  • What are the different matching levels, explain them


  • What is payment terms and how to define payment terms


  • What are the different types of transaction types in receivables



Who should take this course

Any Professional with Basic Knowledge on SQL, PL/SQL and Financials Concepts

What You Will Learn!

  • Oracle Apps R12 Technical Interview Questions
  • Oracle Apps R12 Financials Interview Questions

Who Should Attend!

  • Any Professional with Knowledge on SQL and PLSQL and Financials Concepts