December 08, 2019

Top 20 Oracle Fusion Applications interview Questions and Answers


Ques: 1. Why do Oracle Fusion Applications so different?

Answer: 

The biggest difference about oracle fusion applications is the usability. While most applications are developed to fulfil functionality, Oracle Fusion Applications were developed with a huge emphasis on usability. Oracle invested much effort in understanding usability needs by conducting multitudes of usability testing sessions. Leveraging this user feedback and best practices from existing applications, the Usability team established guidelines, design patterns and standards that were easily implemented by Oracle Product Development.

Oracle Fusion Applications provide a consistent, role-based user interface that is infused with Web 2.0 capabilities and incorporates embedded decision support. As I’ve started to use Oracle Fusion Applications, I now realize how significantly simpler it is to do your work with intuitive and intelligent user experience.

 

Oracle Fusion Applications interview Questions and Answers

 

Ques: 2. What is the foundation for Fusion Applications?

Answer: 

Oracle Fusion Middleware provides support for security, user interface framework, business intelligence, collaboration, search capabilities, business process orchestration and extensibility of Oracle Fusion Applications.

Oracle Fusion Applications are built on the industry-leading, open-standards Oracle Fusion Middleware platform, which includes some of the most powerful, state-of-the-art technology available.


Oracle Financials Interview questions and Answers

 

Ques: 3. What is File Based Data Import (FBDI) and ADFDI in Fusion?

Answer: 

FBDI is one of the tool available in the Oracle Fusion to import the data from External application. This is the Excel Based Prebuilt Data Templates in which we put the Data to migrate in the Oracle Cloud. This upload the Data in the Form of CSV Files.

ADFDI is another Data Import tool in oracle fusion to insert the data in the Oracle Cloud. ADFDI is the same as WebADI in Oracle Apps which is totally integrated with the application. This works online as compared to the FBDI which works offline means we prepare the data offline so ADFDI provided the real time data validation.

 

Oracle SCM Interview Questions and Answers

 

Ques: 4. What are the Reporting tools available in the Oracle Fusion?

Answer: 

  • BIP Reports 
  • OTBI reports 
  • Smart View Reports 
  • Financial Reporting Studio


Oracle Fusion HCM Interview Questions and Answers

 

Ques: 5. What is OTBI Report?

Answer: 

OTBI is the report tool available in the Oracle Fusion, which is used to create the reports in oracle cloud. OTBI is the very user-friendly tool available in oracle fusion, where we can develop the reports with just drag and drop options. It does not require the SLQ expertise and the Fusion tables knowledge to build the reports. This is the very interesting tool available in Oracle Fusion to extract the data from the system.

 

Oracle ADF Interview Questions and Answers

 

Ques: 6. What is Financial Reporting Studio in Oracle Fusion?

Answer: 

Financial Reporting Studio is a client based Financial Reporting tool which is uses to build the Financial reports in Oracle Fusion. This is more like FSG reports in Oracle Apps. This FR studio works on the GL balances. This Uses drag and drop functionality to create a grid to design the rows, columns and pages of the financial report. This Contains grids and other objects that are reusable across multiple reports. FR Studio Uses the GL Balances Cube dimensions on either rows, columns, pages and Point of Views (POV).

 

Oracle Accounts Payables Interview Questions and Answers

 

Ques: 7. What is Sandbox in Oracle Fusion?

Answer: 

In EBS Sandbox related to Server but in Oracle fusion Sandbox is totally different concept. In Oracle Fusion , We will Use Sandbox to do any kind of Personalizations or Extensions or Page layout changes in Oracle Fusion Web-pages. It means we need to create Sandbox first to make any changes in Oracle Fusion application in terms of Personalizations or Extensions. 

Then all the changes will be done under this sandbox and this is the important feature of the sandbox that , we can do the changes in the application without impacting the complete application so these changes will only apply under the sandbox and other users of the application will not see these changes until unless you have tested the changes under sandbox and publish this sandbox. Once you will publish the sandbox in fusion then all the changes under the sandbox will be published to all the users in the application.

 

Oracle Access Manager Interview Questions and Answers

 

Ques: 8. How many Types of Roles Available in Oracle Fusion?

Answer: 

Oracle has provided these four Types of roles. 

  • Abstract role
  • Job roles 
  • Duty roles 
  • Data roles

 

Oracle PL/SQL Interview Questions and Answers

 

Ques: 9. What Is ESS job in Oracle Fusion?

Answer: 

ESS job is same like concurrent Program in Oracle apps. If we need to run the BIP reports in the Fusion Application then we need to register these reports as a ESS jobs in Oracle Fusion. Then after that we can run this report in the Fusion as a Schedule process same as as    concurrent request in the Oracle apps.

 

Oracle SQL Interview Questions and Answers

 

Ques: 10. What is BPM Worklist in Oracle Fusion?

Answer: 

BPM worklist is list of BPM workflows available in Oracle fusion which we can design as per our business Requirment in oracle fusion. We cannot create the new worklist in BPM, We can only use the existing Workflows in the BPM Worklist. In the BPM worklist, We have the approval for Expenses , AP invoice , GL Journals, PO and Requisition AR Invoices and the Cash Advance approvals and many others.


Oracle Cloud Interview Questions and Answers


Ques: 11. What is Job Set in Oracle Fusion?

Answer: 

Job set is same like Request set in Oracle apps. Like in Oracle apps , We combine multiple concurrent Programs in a Request set in the same way , We Combine Multiple ESS jobs in a Fusion Job set. Job set is the set of Multiple ESS Jobs. When We want to run the same set of ESS jobs Together in Oracle Cloud, then we can add these ESS jobs in the job set and then We only need to run this concurrent Job set and all the ESS jobs under this Job set can be run together in sequentially or Parallelly order.


Oracle RDMS Interview Questions and Answers

 

Ques: 12. What is My Folder and Shared Folder in Fusion Reports?

Answer: 

My Folders: 'My Folders' is your own folder. It means it is specific to each user. when you will create your report under this folder then no one in the application can see and access these reports because these are saved and created under your My folder. so this is totally yours personal Development.

Shared Folders: Shared Folders is your Application Common Folder. It means it is shared across users of the application as per the roles. Shared folders have many Sub-folders related to the Work related and Module Related. 

Oracle has already given standard OTBI reports, Data Models and Dashboards under the sub-folders in the Shared Folders. When you will create any report under the sub-folder of Shared Folders then your report will be visible and accessible to other users of the application as per the Permission and role of that user.


BI Publisher Interview Questions and Answers

 

Ques: 13. How to get the Oracle Fusion application information’s in the BIP reports?

Answer: 

In Oracle Apps R12 reports , we can easily get the user information through Profile option like USER_ID, RESP_ID but in Oracle Fusion to get the user information. you need to user : and then System variable name in your SQL query.

Select  :xdo_user_name, :xdo_user_roles From Dual;


Oracle 10g Interview Questions and Answers

 

Ques: 14. What Is File De Batching?

Answer: 

When a file contains multiple messages, you can choose to publish messages in a specific number of batches. This is referred to as de-batching. During de-batching, the file reader, on restart, proceeds from where it left off in the previous run, thereby avoiding duplicate messages. File de-batching is supported for files in XML and native formats.

 

Ques: 15. What Is Schematron Validation?

Answer: 

You can specify Schematron files for validating an inbound message and its various parts. Schematron version 1.5 is the supported version. Schematron is an XML schema language, and it can be used to validate XML.

 

Ques: 16. What Is the role of Oracle Mediator?

Answer: 

Oracle Mediator provides a lightweight framework to mediate between various components within a composite application. Oracle Mediator converts data to facilitate communication between different interfaces exposed by different components that are wired to build a SOA composite application.

 

Ques: 17. What Are Major Benefits For Psft Financials Users?

Answer: 

  • Cash basis accounting
  • Bill Presentment Architecture
  • Credit Management
  • Advanced Collections
  • credit card processor integrations.

 

Ques: 18. What are major footprints in Fusion Financial Management?

Answer: 

Fusion Financial Management component of the Oracle Fusion Applications suite, it revolutionizes productivity and information access with native, real-time intelligence. Current offering is with these foot prints.

  • General Ledger
  • Accounts Payable
  • Accounts Receivable
  • Asset Management
  • Payments and Collections
  • Cash and Expense Management.

 

Ques: 19. What Are The Other Replacement Feature In Fusion That Makes A Difference To Ebs User?

Answer: 

Yes there are couple of them , here are few:

  • Identity Manager in Fusion apps replaces FND User
  • Business Units is replaced Operating Units
  • Access Control Governor replaces OICM
  • Date Effectivity replaces DateTrack.

 

Ques: 20. Does Fusion Application Have Flex Field Feature?

Answer: 

Yes, similar to EBS, fusion application have flex feild concept. Fusion is supporting mainly three types of flexfields

  1. Descriptive flexfields
  2. Extensible flexfields
  3. Key flexfields

These flexfield enables enable implementers to configure application features without programming and fully supported within Oracle Fusion Applications.

 



Top 20 Oracle Cloud Interview Questions & Answers



Ques: 1. What are the database related public cloud offerings in oracle cloud?

Answer:

Oracle public cloud offering comes with three database related services in the public cloud. They are as follows:

a) Schema as a Service (SAAS).

b) Database as a service (DAAS)– Also known as DBaaS, this public cloud is offered as both Infrastructure as a service IAAS and Platform as a Service PAAS.

c) Oracle database cloud Ex-Data service.

 

Oracle Fusion Applications interview Questions and Answers

 

Ques: 2. How will you provision an oracle database?

Answer:

As an oracle cloud dba, we collect requirements from customers and create it as per given requirements. In case your project needs a clone of production database immediately for testing and UAT purpose. for example, it can be done as per standard specification requirements often based on a template.

 

Oracle Accounts Payables Interview Questions and Answers

 

Ques: 3. Why should I choose oracle cloud over others, as there are many different cloud services available in market?
 

Answer:

Oracle cloud offers database as a service. Oracle database is the popular relational database company that has been in existence so long. With oracle databases supporting enterprise databases, this is a cloud service that can support databases that are used for testing, development, all the way up to live production databases. Oracle cloud offers high availability, scalability options offering business continuity, time save and lot more advantages. A cloud service from a database company to keep it simple.

 

Oracle ADF Interview Questions and Answers                                 

 

Ques: 4. what database management services are included in oracle cloud platform as service offering?

Answer:

Following database management services are included as part of Oracle cloud platform as a service PAAS: 

  • Database
  • Database backup 
  • Big Data
  • Big Data Cloud 
  • Event Hub 
  • MySQL 
  • Autonomous NoSQL Database Cloud 
  • Data hub
  • Autonomous Data Warehouse Cloud.

 

Oracle Access Manager Interview Questions and Answers

 

Ques: 5. Where can you store your oracle database backup in oracle cloud?
 

Answer:

Oracle cloud objects storage solution that is reliable and scalable. As of information from oracle website this is a 8000TB storage that is used for storing and accessing the data in databases that are ever growing. This is storage used for storing oracle database backup data.
 

Oracle Fusion HCM Interview Questions and Answers

 

Ques: 6. What are the unique features of oracle cloud database backup management offering?
 

Answer:

This is a reliable and scalable object data storage from oracle cloud. Some unique features includes:

  • Security – This solution comes with enterprise-grade data protection policies. The privacy policies are in enterprise grade as well. Oracle being the most popular enterprise database solution this cloud offerings from oracle are designed. 
  • Reliability – Redundancy policies ensure high availability of data. 
  • Scalability – Oracle cloud is a pay as you go model solution wherein you can choose to purchase universal credits, BYOL etc. Based on capacity and growing demands storage hardware is allocated making this a scalable solution. 
  • Simplification by using existing RMAN for backups – Even with cloud oracle is still making use of RMAN backup for performing the database backups. This makes backup, restore and recovery operations transparent using RMAN.

 

Oracle SCM Interview Questions and Answers

 

Ques: 7. What is the difference between normal database and Oracle database cloud service?
 

Answer:

Oracle database cloud service is same as single-instance oracle database except for that database is deployed in cloud and computing resources including storage, power etc is provided by Oracle.

 

Oracle Financials Interview questions and Answers


 

Ques: 8. What are the two service levels available with oracle database cloud service?
 

Answer:

Oracle Database Cloud Service Virtual image wherein customer is responsible for installing software, maintenance of software. Customer has root privilege and full database administrative privilege.
 

Oracle Database Cloud Service wherein database deployment is easy using custom options provided online. Oracle database cloud service can perform automated backups. Customer is responsible for setting up maintenance operations, recovery operation setup in the event of failure.


Oracle PL/SQL Interview Questions and Answers

 

Ques: 9. Which component of Oracle cloud provides service console and REST API?
 

Answer:

Platform Service Manager the PSM component of Oracle cloud is responsible for this. This component is the one used in Oracle golden gate and Oracle Java cloud service as well.

 

Oracle SQL Interview Questions and Answers

 

Ques: 10. How does PSM interact with compute nodes to perform predefined cloud service actions like backup, patching?
 

Answer:

PSM uses secure shell the SSH in port 22 of compute nodes. Compute nodes hosts databases which as database deployments in oracle cloud terms. These cations can be initiated over web service console that uses PSM or REST API.

 

Oracle RDMS Interview Questions and Answers

 

Ques: 11. How will you achieve high availability in Oracle Cloud Infrastructure?
 

Answer:

Attach block volume from availability domain 1 to a compute instance in availability domain 2 or vice versa. Distribute application servers across all availability domains within a region.


BI Publisher Interview Questions and Answers

 

Ques: 12. What are the components of backend set of a load balancer?

 

Answer:

a) Load balancing policy
b) list of backend servers
c) health check policy
d) SSL handling
e) session persistence configuration


Oracle 10g Interview Questions and Answers

 

Ques: 13. What are the many different database deployment model available with oracle cloud?
 

Answer:

Following are the many different types of database deployment models that come as part of oracle cloud:

  • Oracle database cloud service. 
  • Oracle database cloud service bare metal. 
  • Oracle Database Exadata Cloud Service. 
  • Oracle Database Exadata Cloud at Customer. 
  • Oracle Database Exadata Express Cloud Service – Managed. 
  • Oracle Database Schema Cloud Service – Managed.

 

Ques: 14. How can I try oracle cloud for free?
 

Answer:

Oracle cloud offers $300 in free credits. You can make use of this credit for building your test, development, production databases, compute options, containers, IoT, bigdata, API, chatbots, integrations and lots more that are valid for 30 days. Create a free account and try these features for free.

 

Ques: 15. How is internal communication between PSM and Oracle cloud compute nodes established?
 

Answer:

SSH key-value pairs are used for this communication in port 22. This key value pair is specific to each database deployment and used for internal communication purposes. This SSH is internal to Oracle and not accessible. If there is an issue here PSM communication with compute node fails.

  

Ques: 16. Who has access to the SSH keys used for PSM communication with compute nodes?
 

Answer:

Only owner of that project has this access. For security purposes even oracle support and operations are not granted this access unless explicitly shared by customers for troubleshooting purposes.

 

Ques: 17. Give some invalid REST API operations for DNS Zone in OCI:
 

Answer:

The below REST API operations are invalid in OCI:

a) ListZones.
b) GetZone.
c) CreateZone.
d) UpdateZone.
e) DeleteZone.

 

Ques: 18. In TCP level health check you send requests to the backend servers at a specific URL. How will you validate the response?

Answer:

a). based on status code.
b). based on entity data returned.
c). based on entity body returned.


Ques: 19. What load balancer components that are mandatory backend set components?

Answer:

a). Load balancing policy.
b). List of backend servers.
c). Health check policy.
d). TCP handling.
 

Ques: 20. What configurations must be made for the process of designing a load balancer to accept incoming traffic?

Answer:

a). Listener must be configured.
b). A certificate must be available.
c). A security list that is open on a listener port must be available.




December 06, 2019

Top 20 Hyperion Technical Interview Questions & Answers


                           Looking for Hyperion technical Interview Questions, the below questions and answer set helpful for experienced or freshers. A lot of opportunities you can find in many IT companies. You will have opportunity to move further in your career. these Hyperion Technical Interview Questions can be a good help as Hyperion Developer.


Ques: 1. What do you understand by Hyperion?

Ans: A database that allows you to access the data at a very fast pace. The Hyperion’s company was bought by Oracle in 2007 and Oracle continuously improving the product. Hyperion is also known as Business Intelligence and it focuses to support better business decision-making.
Hyperion is the market leader in Operational, Financial and Strategic Planning. It contains the applications for reporting, Planning, dashboards, Analysis, score carding, consolidation, Workspace, Master Data Management and Foundation.
So, a BI system can be called a decision support system (DSS). However, Business Intelligence is sometimes used as a synonym for competitive intelligence, because they both support decision making, BI Uses technologies, processes, and application to analyze mostly internal, structured data and business processes while competitive intelligence gathers, analyzes and disseminates information with a topical focus on company competitors.


Ques: 2. What is the significance of Attribute dimensions in report performance?

Ans: For very large number of attribute dimensions displayed in the report, the performance could extremely decrease. While filling the data, you have applied both the selection and the rejection criteria to the same record. The record will be rejected.
Attribute dimension highly impact the report performance as the attributes are calculated vigorously when referenced in the report.


Ques: 3. What is Hyperion Planning?

Ans: Hyperion Planning is a budgeting and forecasting application from Oracle formerly owned by Hyperion Solutions Corporation. Hyperion Planning uses Essbase (s multidimensional database product sold by Hyperion) as a database and calculation engine, a relational repository for business logic, and includes a web-based user interface. This software allows to add planning or forecast data to actuals. You can use Web Forms to add the planning data or use the Excel SmartView tool. Most of the Hyperion reporting tools work great with planning.


Ques: 4. Can you Explain the Attributes?

Ans: Classification of a member in a dimension is known as an attribute. We can do selection of group members based on their associated attributes. We can also specify an attribute while performing calculations and along with we can use calculation functions. As example, the database in Sample Basic with product dimension has some attributes like package type, size, and flavor. We can add attributes to the dimensions and can retrieve data.


Ques: 5. What Are Filters in Hyperion?

Ans: A method of controlling access to database cells in Hyperion essbase. A filter is the most detailed level of security, allowing you to define varying access levels different users can have to individual database values. If you want to grant access to all dimensions, then you wouldn’t use a filter. Just grant read access for the database to the user and/or group. The only reason you would use a filter is if you wanted to restrict access.


Ques: 6. What do you understand by Dense and Sparse Dimensions?

Ans: Dense Dimension: A dimension which has the high probability that data exists for every combination of dimension members.
Sparse Dimension: A dimension which has low probability that data exists for every combination of dimension members.


Ques: 7. What do you understand by TB First and TB Last?

Ans: TB First: in the Sample. Basic database, the accounts member Opening Inventory is tagged as TB First. Opening Inventory consolidates the value of the first month in each quarter and uses that value for that month’s parent. For example, the value for Qtr1 is the same as the value for Jan.

TB Last: in the Sample. Basic database, the accounts member Ending Inventory is tagged as TB Last. Ending Inventory consolidates the value for the last month in each quarter and uses that value for that month’s parent. For example, the value for Qtr1 is the same as the value for Mar.


Ques: 8. What is the key difference between UDA’s and Attribute dimensions?

Ans: Attribute dimensions provides more flexibility than UDA’s. Attribute calculations dimensions which include five members with the default names sum, count, min, max and avg are automatically created for the attribute dimensions and are calculate dynamically.


Ques: 9. How many primary build methods are available in Hyperion for building dimensions?

Ans: There are three primary build methods available for building dimensions. They are:
  • Generation references 
  • Parent-Child references 
  • Level references

Ques: 10. What are the attributes in Hyperion?

Ans: Attributes are the classifications of a member in a dimension. You can select, and group the members based on their associated attributes. You can also specify an attribute when you perform calculations and use calculation functions.
Eg: The database in Sample Basic which has product dimension has some attributes like size, package type, and flavor. We can add these attributes to the dimensions where we can retrieve the data like for example to retrieve “Pepsi with 10 Oz with Cans” this is useful for generating reports.


Ques: 11. What are the three options specified in Username and Password management under the security tab in Essbase server properties?

Ans: 1. Login attempts allowed before username is disabled.
2. Number of inactive days before username is disabled.
3. Number of days before user must change password.


Ques: 12. What are two storage options available in Hyperion Essbase? What are the differences?

Ans: ASO (Aggregate Storage Option):
  • If we have large number of dimensions (generally more than 10).
  • Most of the dimensions are sparse.
  • We cannot write back in ASO. I heard recently that ASO will also have the write back capability.
BSO (Block Storage Option)­:
  • Dimensions are less and dense (recommended values for no of dim are between 4 and 8).
  • We can write back hence much suited for planning applications. Financial applications are generally dense structures and normal analytical cubes are sparse. Here we also need to understand what these dense and sparse members are. When the intersections or cells of two dimensions mostly contain a value, it is dense.

Ques: 13. What is Oracle Hyperion Financial Management (HFM)?

Ans: Oracle Hyperion Financial Management, part of the Oracle EPM Suite, supports the collection, consolidation and reporting of financial results in multiple GAAPs as well as IFRS, and the reconciliation of differences among the various standards.
Oracle Hyperion Financial Management (HFM) is a comprehensive Web-based application that delivers global financial consolidation, reporting and analysis in a single, highly scalable software solution. Hyperion Financial Management can be deployed quickly to integrate data from multiple Oracle and non-Oracle transactional systems, provide top-side reporting that conforms to IFRS requirements, and help organizations make the transition to IFRS.


Ques: 14. What do you understand by LRO's( Linked Reporting Objects)?

Ans: They are specific objects like files, cell notes, or URL's associated with specific data cells of Essbase database. You can link multiple objects to a single data cell. These linked objects are stored in the server. These LRO's can be exported or imported with the database for backup and migration activities.


Ques: 15. Why do objects gets locked and when does this happens?

Ans: Objects gets locked to prevent users to make simultaneous and conflicting changes to Essbase database objects. By default, whenever an object is accessed through Administrative services console or Excel spreadsheet add-in, it gets locked.


Ques: 16. What is custom based macro?

Ans: Hyperion Essbase macros that we write with Essbase calculator functions and special macro functions. Custom-defined macros use an internal Essbase macro language that enables you to combine calculation function and operate on multiple input parameters.


Ques: 17. What Are the types of partitioning options available in Hyperion Essbase?

Ans: Three types of partitioning options are available in Hyperion Essbase:
  1. Replicated partition.
  2. Transparent partition 
  3. Linked partition.

Ques: 18. What Are the different types of Log Files in Hyperion?

Ans: There are many log files hyperion essbase, but the important log files are:
  • Application log
  • Essbase.log
  • Configtool.log
  • Eas_install.log
  • Essbase server-install.log

Ques: 19. On what basis you will decide to invoke a serial or parallel calculation method?

Ans: If we have a single processor, we will use serial calculation but if we have multiple processors we can break the task into threads and make them run on different processors.


Ques: 20. What is block locking system?

Ans:Analytic services (or Essbase Services) locks the block and all other blocks which contain the Children of that block while calculating this block is block locking system.