Tuesday, July 19, 2022

 Oracle Fusion is the combination of the Oracle applications developed on ERP. Fusion Middleware consists of various products like Java EE, tools, content management, and more. Fusion provides support for development and deployment for SOA applications. In combination with all the products, it is very strong in implementation. Almost every organization working with Oracle is using Oracle Fusion. One should know the concepts of Oracle technology. Please have a look at the Oracle Fusion interview questions and answers page to win your interview. Oracle Fusion Cloud Human Capital Management is a cloud-based solution that simplifies the process to manage human resources from hire to retirement. Its advanced capabilities made it a widely deployed solution. This blog covers the Oracle HCM interview questions that are suitable for freshers as well as for experienced candidates. Preparing these questions would help you with the confidence to clear your oracle cloud HCM interview with ease. All the very best!


1. What are the types of data that you can use in the Cloud Fusion Application including cloud? Which one is more critical among them?

Ans:

    With respect to the rise in cloud technology in the last few years, a significant change has been seen in the data types. Presently, three types of data are common in the Oracle Fusion Cloud and they are :

  • Structured
  • Unstructured
  • Semi-structured

  • Among all these three, unstructured data is considered critical data. This is because it is not classified in any manner and is generally a combination of different types of files, videos, images, as well as text.

2. On which servicing model Oracle Fusion cloud technology is based?

Ans:

    It is based on Saas which is also one of its biggest benefits

Oracle Fusion cloud technology
Oracle Fusion cloud technology

3. Tell me something about the Open source cloud database platform you are familiar with?

Ans:

    The fact is Open source is something that enables the users to manage the cloud exactly in the way they want. Because scalability, reliability, efficiency, as well as speed, matters a lot, a document-oriented approach is very important and offers high storage abilities. Some open-source approaches which are common are CouchDB, MongoDB as well as LucidDB.

4. How secure is data on the cloud?

Ans:

    Well, organizations need not worry about the same and this is because the cloud is a safe approach. It comes with multiple benefits and users need not worry about security. This is because users are allowed to impose various security restrictions on their data such as log in with a user name and a password, data encryption, and so on. However, there are certain factors that organizations must pay attention to before they consider any cloud service.

5. Is it possible to reconcile the data from output form to input form?

Ans:

    In Oracle Fusion Cloud, it is possible and can generally be done with the help of an approach known as Input Validation.

6. How can you say that Oracle Fusion cloud technology is beneficial for an organization?

Ans:

  • It always makes sure of security when it comes to data storage and backup
  • Oracle Fusion cloud approach is highly agnostic to OS
  • It enables users to keep up the pace simply because of its virtualization, as well as Sandboxing abilities
  • Another good thing is it is cost-effective
  • It always makes sure of better productivity
  • Oracle Fusion Cloud comes as Saas
  • Without hardware investment, users can simply take full benefit of server capabilities
  • Scaling, as well as growth, can be managed simultaneously

7. Suppose you need to transfer the maximum amount of data very quickly in or out from the cloud what would you do?

Ans:

    Using “Performance Cloud” is a good option. It is actually used by a lot of professionals for getting the outcomes that are advanced and need fast data transmission.

8. What exactly do you mean by Eucalyptus?

Ans:

    It is actually a combination of the following terms :

  • Elastic
  • Utility
  • Computing
  • Architecture
  • Linking
  • Programs
  • Usefulness
  • Systems
  • It is actually a third-party software that can be used for the implementation of the different clusters in the cloud. Basically, it can be considered to divide a cloud into a hybrid, community, private as well as public domain. The entire data center can easily be transformed into a private cloud in case the need for the same is realized.

9. What are the security measures regarding the Oracle Fusion cloud you are familiar with?

Ans:

    The fact is there are certain levels of security that organizations must pay attention to. Oracle Fusion Cloud allows identity management which is a good security measure. It makes sure that the applications, hardware, as well as services are only used by those who are authorized for the same. Another measure is access control. It makes sure that users always remain in a position to control the entire access of the cloud if they are authorized. In addition to this, authentication and authorization are the other methods that users can deploy to keep up the pace simply.

10. What is the lowest level of cloud architecture in Oracle Fusion and what does it provide?

Ans:

    The lowest level is Node Controller and it is responsible for controlling the activities of Virtual Machines. It can also be employed for termination, execution, and managing the same.

11. Which platforms will you consider when it comes to cloud computing on a large scale?

Ans:

    Apache Hadoop is widely regarded as one of the finest options. It’s because this software platform can simply distribute and store data even if the same needs to be managed on a cluster. The reliability can also be assured when it comes to building the same from the commodity hardware. Another leading reason to consider the same is it always makes sure of data integrity, security, operations, governance as well as the processing of the same.

12. Tell something about the deployment options you are familiar with which are common in cloud technology?

Ans:

    It is not always necessary that a deployment model that is good for one organization also offers the same pros for other organizations. Many internal factors related to organizations can impose a limit on them. The organizations which are large in size always prefer the private cloud while on the other hand, the public cloud is a good option for organizations with small size.

13. Why would one use the API in the Cloud?

Ans:

    Generally, writing fledged programs fully is something that wastes a lot of time. API makes sure that the need for the same gets eliminated up to a good extent. The application can be made to communicate with one another through the instructions provided by the API. Also, the cloud can easily be linked to other systems outside the link.

API in the Cloud
API in the Cloud

14. How private cloud and community cloud infrastructure are different from one another?

Ans:

    A private cloud is actually an option for single organizations that can have multiple branches and units. Organizations are free to enable third-party businesses to operate their cloud. In other words, they can outsource their cloud operations to other organizations provided all the security policies defined by them are met. The private cloud can be in a remote data center.

    On the other side, community cloud infrastructure is considered by different businesses in a shared manner. All the tasks related to managing the same are the sole responsibility of their own. The community cloud infrastructure can also be in a remote data center that can be accessed easily.

15. In the hierarchy of clouds, which layer is at the top?

Ans:

    The controller is always at the top and it manages the network, server, API, as well as storage of data.

16. What do you understand with Paas, Iaas, and Saas? How can they be put differently from one another?

Ans:

    These are actually the different service models that are supported by the Oracle Fusion Cloud.

    Paas is an approach in which the OS and hardware, both are provided by third-party organizations and are managed by Fusion. In Iaas, either hardware or the OS is provided by a third-party organization and in Saas, all the programs, as well as the applications are managed by a third party. These models make cloud computing different from different organizations. There are certain factors related to them that are also not the same and this generally includes cost, as well as data security.M

17. Which option one should choose among “Cloud infrastructure exists in the data center of the organization offering cloud service” or it exists in their own organization and why?

Ans:

    Well, it largely depends on the factors such as the budget/turnover of the organization. In addition to this, it depends on the overall quantity of data that an organization has to manage. Both have their own pros and cons.

18. According to you, what is the best available strategy that one should consider to secure data before moving it to the cloud, and why?

Ans:

    Probably the first step is to make sure that it is not possible for the others that the ones which are authorized to access data to be intercepted. Avoiding data leaks is very important. There are several options for securing keys that can be opted. Also, it is necessary to check that the data is not infected by any malware and virus.

19. Name two categories in which the data centers can be put in the Cloud environment?

Ans:

    These are Low-Density Data Centers and Containerized Data Centers.

20. Are you familiar with the applications suite of Oracle Fusion Cloud presently?

Ans:

    Oracle has highly accelerated its Cloud offering which is now operated and accessed by organizations in the sector of Customer Relationship Management, Governance, Risk Management, Hospitality, Data Analysis organizations, defense, and lots more.

applications suite of Oracle Fusion Cloud

21. Name the four phases which are involved in the Oracle Fusion Cloud?

Ans:

    These are Monitor Phase, Cleanup Phase, Launch Phase, and Shut Down Phase.

22. Name the common layers which are present in cloud architecture?

Ans:

    These are :

  • Walrus
  • Storage
  • Cloud Controller
  • Node Controller
  • Storage Controller

23. Let us say you need to migrate to the cloud environment for the first time, what would be your essential considerations?

Ans:

    The very first thing is to address the compliance issues and the probability of its loss. The other factor to pay attention to is ensuring the availability, data integrity, storage types as well as overall downtime of the cloud.

24. Name the approach that makes sure that the data is processed in a recommended manner within an application in the cloud?

Ans:

    This approach is Process Controlling

25. Tell me any two benefits of Cloud technology that you think are the best it can offer to organizations?

Ans:

    For organizations, it is possible to access the applications/software without installing them in the system. In addition to this, for large-scale applications, the cost related to support and maintenance can be eliminated up to a good extent. In addition to this, zero infrastructure investment is also possible for organizations in most cases.

26. What are the basic factors related to efficiency and scalability that matters while performing different tasks in a Cloud?

Ans:

    Speed of processor in the system, the complexity of services, Intra-cloud communication, and Cloud Ingress are the services that largely matter.

27. What do you understand from the term utility computing?

Ans:

    It is actually regarded as one of the cost-saving strategies by many businesses in need of cloud services. In Oracle Fusion, it is possible for the users to pay for the service they are taking on a per-use basis. All the organizations that consider the growth and scale model can benefit from this. The best part services, as well as the applications, can simply be implemented as per the needs.

28. What can be considered as the building block in the cloud while you are performing any basic task related to the data?

Ans:

    Technical Architecture, Reference Architecture, Deployment Architecture, as well as Performance Architecture are the basic building blocks. It is not always necessary that all the building blocks are required in all the tasks.

29. Give one reason why MapReduce can be a good option for processing mass data?

Ans:

    Users can simply keep up the pace with the commodity hardware and without actually investing the money on a large scale. In addition to this, it always makes sure of transparent scalability, as well as huge fault tolerance ability. Moreover, the wide Google support ensures users can keep up the pace all the time without facing any issues.

30. Name one optimization strategy that is useful during a data disaster approach?

Ans:

    Oracle Fusion allows the concept of using a three-data approach which makes sure of data backup. Using the same is always a good option for the organizations as this can simply enable them to keep up the pace with data all the time.

31. How to create Fusion BI-Publisher reports?

Ans:

    Oracle has already delivered a lot of BIP Reports in the Fusion Instance, However during a course of implementation it is a common requirement to develop new ones, There are few common steps involved they are :

  • Step1 : Create a SQL Query which comprises DB Tables ( that exist in Fusion Schema. .
  • Step2 : Under Published Reporting -> Data Model, Create a New Data Set (of SQL Query type.
  • Step3 : Give a Name to Data Set (for this example say PersonAssignment_ds.
  • Step4 : You would need to take special care while selecting Data Source (Logic Below. : If you are Building Finance reports use : ApplicationDB_FSCM, If you are Building HCM reports use : ApplicationDB_HCM, If you are Building CRM Reports use : ApplicationDB_CRM
  • Step5 : Depending on the number of Parameters( Bind Variables. used a Popup window will appear, Give a Name to the Parameters.
  • Step6 : At last will save the report, click on data-report and see the output.

32. How to create Oracle Fusion OTBI Reports?

Ans:

    Following are the steps to build OTBI Reports :

  • Step1–> Login To Fusion Applications with a User login
  • Step2–> Click on the Navigator icon and then select ‘Reports and Analytics under Tools option.
  • Step3–> Click on the BI catalog icon (an open book. on the top left hand side.
  • Step4–> Choose New Analysis from the drop-down list and then select an appropriate Subject Area (Workforce Management – Worker Assignment Real Time, for example. .
  • Step5–> Now we would select one folder from the left-hand side, inside the table folder will find tables’ respective columns, and drag and drop the required column to the dashboard to create the OTBI report.

33. How To Upload Customers Through a Spreadsheet in Oracle Fusion?

Ans:

    Following are the steps to upload customers data in Fusion :

  • Step1: Navigate to the Manage Customer Upload page, Navigator > Receivables > Billing
  • Step2: From Tasks List: Customer > Upload Customers from Spreadsheet
  • Step3: Manage Customer Uploads Page appears, click on ‘Download Customers Spreadsheet Template’
  • Step4: Enter the Customer Information in the Template.
  • Step5: The spreadsheet template is composed of four worksheets: Customers, Contacts, Reference Accounts and Customer Bank Accounts, where you can enter related data.
  • Step6: Generate the CSV Zip File, Once the data is maintained in the Excel Template.
  • Step7: In ‘Manage Customer Uploads’ Page, click on ‘Upload Customers From SpreadSheet’, upload the zip file.
  • Step8: Upload Customer form Spreadsheet From Spreadsheet dialog window, enter a Batch Name for identification purposes.Use the Browse button to locate your Zip file.click Submit.
  • Step9: Monitor progress of the Batch ID in the Search Results region of the page.
  • Step10: Review the Customer Records created, Navigator > Receivables > Billing From Tasks List: Customer > Manage Customers

34. How safe is Cloud data?

Ans:

    Companies don’t need to think about the same issue and that is because the cloud is a secure solution. It comes with several benefits and users do not need to worry about the protection. This is because users are able to enforce specific security constraints on their files, such as login with a user-name and password, data encryption, etc. There are nevertheless certain aspects that companies need to pay heed to before contemplating any cloud service.

35. How will one in the Cloud use the API?

Ans:

    Usually speaking, designing full fledged applications is something that wastes a lot of time. The API guarantees that the same requirement is removed to a reasonable degree. You can apply to interact with each other via the instructions given by the API. Cloud can also be conveniently attached to other devices outside of the network.

36. Name the rising strata in cloud architecture?

Ans:

    These are :

  • Walrus
  • Storage
  • Cloud Controller
  • Node Controller
  • Storage Controller

37. How distinct are private cloud and group computing infrastructure?

Ans:

    Private cloud is basically an alternative that may provide multiple divisions and units for the single organizations. Organizations are allowed to enable their cloud to work with third party businesses. In other terms, they should outsource their cloud activities to other companies if they follow any of the protection requirements that they identify. Private clouds can be housed in a distant data centre.

    On the other hand, different organizations find collective cloud technology in a cooperative way. All the duties relevant to handling the same are entirely their own liability. The group cloud network can also be housed in a conveniently available distributed data center.

38. What is an OTBI Report?

Ans:

    OTBI is the Oracle Fusion monitoring method, which is used to generate oracle cloud files. OTBI is the most user-friendly method used in oracle fusion, where we can use drag and drop options to create the files. It does not need the skills of SQL and the awareness of Fusion tables to create the report. It is a really useful method for separating the data from the framework used in Oracle Fusion.

39. What is FR Studio in Oracle Fusion?

Ans:

    Financial Reporting Studio is a customer-based financial management platform used to build Oracle Fusion’s financial reports. This is just like Oracle Applications FSG files. This FR lab is focusing on the balances in GL. It Uses drag-and-drop features to build a grid to organize the financial report rows, columns and sections. It Includes grids and other items that may be replicated through several reports. FR Studio Uses the proportions of the GL Balances Cube on any axes, columns, sections, or perspectives (POV).

40. What is a BIP Report?

Ans:

    BIP is the analysis platform for Business Intelligence Publisher and is used to produce the Oracle Cloud Complex reports. It is especially used to produce the statutory reports where we need to create the different templates. This is a technological resource that still includes the SQL experience and the cloud application’s technological awareness.

BIP Report
BIP Report

41. What is My Folder and Shared Folder in Fusion Reports?

Ans:

    The ‘My Folders‘ tab is your own. That ensures it’s exclusive to any person. Once you make a report in this tab, no one in the company should be allowed to read and view these files as they are encrypted and produced in the My tab. And this is your professional creation completely.

    Shared Folders is the Through Software Directory. This implies the framework is shared by users according to the roles. Shared directories have several Work-related and Module-related subfolders.

42. How is the Oracle Fusion Scheduling Process?

Ans:

    The Schedule Method in Oracle Fusion is similar to Concurrent Requests in Oracle r12 applications. Within Oracle Fusion we manage the ESS jobs as Schedule Processes. ESS job is the same as Concurrent Program in Oracle Apps r12. ESS job is the principle of Oracle Fusion with the aid of this, we will operate our Oracle Fusion applications Reports, Packages and Scripts. We’ll first know what the ESS job is in Oracle Fusion and then the description of the Oracle ESS job. ESS jobs in fusion applications are the same as those in Oracle apps r12 for Concurrent Program. As we use the concurrent program to operate the Oracle Applications Data, Procedures and Scripts in the same way we use ESS workers to operate BIP files, Procedures and Scripts.

    We register reports, scripts in fusion apps as ESS jobs and the user runs such ESS jobs as Oracle Fusion’s Scheduled Processes much like Concurrent Requests in Oracle R12 apps. In order to build the ESS jobs, we first need to establish the Oracle ESS job definition and then we will run the BIP reports, procedures and scripts for Fusion Schedules Processes via ESS jobs.

43. How many Types of Roles Available in Oracle Fusion?

Ans:

    Oracle has provided these four Types of roles :

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

44. What is an ESS job in Oracle Fusion?

Ans:

    The ESS job in Oracle apps is the same as the concurrent program. When we have to run the BIP reports in the Fusion Program otherwise we have to log these reports in Oracle Fusion as an ESS task. So we will operate this report as a schedule process in the Fusion as well as the parallel request in the Oracle applications.

45. What is BPM in Oracle Fusion?

Ans:

    BPM requires the management of corporate operations. BPM is a comprehensive collection of software at Oracle Fusion to develop, implement and automate business processes. Throughout BPM, we can build the approval processes. In Oracle fusion we can build the company approval processes with BPM’s Support. This is an Advanced Resource available for developing and sustaining acceptance rules as per business needs in Oracle fusion.

46. What are the Features of OTBI?

Ans:

    Oracle Fusion Transaction Business Intelligence (OTBI. is a real-time self-service monitoring solution provided to all Oracle Fusion product customers with a legitimate role in generating ad hoc insight and analysis to help them make their decisions on a daily basis, following are the main features of OTBI.

  • User Friendly
  • Speedy development of reports
  • Powerful Data Visualization
  • Minimal SQL required
  • Security configuration is fully integrated with Oracle Fusion
  • Provides real time analysis of Transactional data

47. What is Logical and Physical SQL in OTBI?

Ans:

    Logical SQL : A logical SQL is exactly similar to a physical SQL. BI Server understands logical SQL

    Physical SQL : The physical SQL is the one that is sent from BI Server to the data sources in order to retrieve data Oracle BI Server transforms the logical SQL into physical one through a process known as query processing that can be understood by source database.

48. What is UCM in Oracle Fusion?

Ans:

    UCM stands for Universal Content Management and this server is available in Oracle cloud, following are the features of cloud UCM :

  • UCM is used in Oracle Cloud SAAS Environment
  • We use UCM Cloud for Inbound and Outbound Integration
  • UCM is same like FTP server in ebs
  • UCM has different location with each have different paths
  • We are not allowed to create new location and path under UCM
  • We are bound to use existing locations under UCM

49. How to load Supplier data in Fusion?

Ans:

    Through FBDI process we can load Supplier data into Fusion following steps are involved :

    1. Download the template from the Metalink

    2. Maintain the data in csv template format

    3. Generate Zip file from template file

    4. Load the file data into Interface table

    5. Move the data into base table

50. Difference between ICS and OIC?

Ans:

    Integration Cloud Service (ICS)- Simplify how you build integration in the cloud. This product lets you connect securely to applications and services both in the cloud and on premises. The infrastructure(cloud management, patching, backup, and restore. is managed by Oracle.

    Process Cloud Service(PCS) – A process automation tool used to design, automate and manage business processes in the cloud.

    Visual Builder Cloud Service(VBCS) – Allows you to rapidly create and deploy web and mobile applications directly from the browser with minimal coding required.

51. What is Oracle Fusion HCM?

Ans:

    Oracle Fusion Cloud Human Capital Management is natively built for the cloud and offers a wide range of applications required for an organization to manage human resources. It streamlines the work process of HR leaders with unique solutions for every stage of an employee lifecycle which include attracting new talent, screening, hiring, on-boarding, managing payroll, managing time and absence, managing performance, compensation, and benefits, optimizing workflow, etc.

    Oracle Fusion HCM cloud built with an AI-first approach and allows individuals to make real-time smarter decisions. It is highly flexible and easily integrates with multiple applications like supply chain, financials, CRM etc. Oracle offers a wide range of products designed for HCM which include Global HR, Talent Management, Workforce Management, Workforce Rewards, and Work-Life Solutions.

52. What is IDG in oracle fusion HCM?

Ans:

    In Oracle Fusion HCM the term IDG is abbreviated as a Legislative Data Group (LDG. . Fusion Payroll is organized by LDG. Every LDG group is treated as legislation in which payroll is processed. Each legislative data group consists of elements like legislative code, own cost key flexfield structure, and currency.

53. How to handle exceptions in Oracle Integration Cloud?

Ans:

    Exceptions can be handled using Scope activity and Global Fault handler in Oracle Integration Cloud.

    Fault Handlers are provided at the scope level to handle errors that arise during invoke actions within those scopes.

    Global Fault Handler that is available at the overall integration flow level which acts as a super catch block.

54. What is the business identifier in Oracle Integration Cloud?

Ans:

    Business identifiers enable you to track payload fields in messages during runtime. You can specify up to three business identifiers fields for tracking during design time. One of these fields must be selected as the primary business identifier field.

55. Which expression can you use to schedule integration runs?

Ans:

    iCal expression is used to define scheduled runs into OIC.

      For Example :

      Ans:

    • FREQ=DAILY;BYHOUR=17;BYMINUTE=30,40,50;BYSECOND=0;&
    • FREQ=DAILY;BYHOUR=18;BYMINUTE=0,10,20,30,40,50;BYSECOND=0;&
    • FREQ=DAILY;BYHOUR=19;BYMINUTE=0,10,20,30;BYSECOND=0;&

56. Can we store data into OIC?

Ans:

    OIC doesn’t allow you to store data for future use. However OIC has Stage activity which can be used to store data for temporary use. The data stored into OIC is flushed automatically as soon as the instance is completed.

57. Can we install an OIC connectivity agent in High Availability(HA) mode?

Ans:

    Yes, OIC connectivity agents can be installed in HA mode. Agent HA provides an option to run multiple OIC Agents in Active-Active mode.

OIC connectivity agent in High Availability

58. What is FSM in Oracle Fusion HCM?

Ans:

    FSM is abbreviated as Functional Setup Manager (“FSM ”. and it is the essential component of Oracle Fusion applications. It allows developers/administrators to manage application operations and design objects. It streamlines the implementation process experience for all Fusion applications across HCM, ERP, CX, and SCM pillars.

    FSM allows you to :

    Ans:

    1. It lets you understand implementation needs and plan

    2. Customize applications to meet business requirements

    3. Allows you to import functional setup data between various instances.

    4. Validates configuration data by analyzing reports

59. What is Absence Management in Oracle Cloud HCM?

Ans:

    Oracle Absence Management is a core component of Oracle Cloud HCM that enables you to effectively set rules for managing employee absenteeism globally and locally. This would bring down the elements associated with absenteeism such as productivity, cost, and risk. Using Absence management organizations can build, customize, and configure simplified absence management plans.

60. What are the different Oracle HCM Modules?

Ans:

    Following are the different Oracle HCM modules available and each of them contributes their part to streamline the process to manage the human resources of an organization across the globe.

  • Core Human Resources
  • Onboarding
  • Workforce Directory
  • HR Help Desk

    Benefits :

    Ans:

  • Absence Management
  • Workforce Modeling and Predictions
  • Advanced HCM Controls
  • Work-Life Solutions

61. Name a few essential factors that should be taken into consideration to assign key responsibility areas to an employee?

Ans:

    To specify the key responsibility areas to an employee the major factors that should be taken into consideration are skill set, experience, areas of interest, education qualification, leadership qualities, efforts, etc.

62. What is reference data sharing in oracle fusion?

Ans:

    Reference data sharing in Oracle Fusion is also known as SetID. This reference data sharing functionality supports operations in multiple business units, ledgers, and warehouses. This helps in a drastic reduction in administrative efforts and time taken to implement business units.

63. What is the use of Reference data sharing in Oracle Fusion HCM?

Ans:

    The main advantage of Reference Data sharing is that it eliminates duplicate data in the common transactional data.

64. What are the major Absence Patterns?

Ans:

    Following are the predefined absence patterns:

  • Childbirth or placement
  • Illness or injury
  • Generic absence

65. What is the watchlist in Oracle Fusion?

Ans:

    Watchlist is an essential component of Oracle Fusion components that gives the users a set of shortcuts to work areas based on the user preferences. It consists of items delivered by applications and items that are created by the end-user.

66. What is Oracle Fusion Middleware?

Ans:

    Oracle Fusion Middleware is a set of standards that provides complete support for development, deployment, integration, and management. It offers a wide range of solutions through its middleware design :

    Following are the various solutions offered by Oracle Fusion Middleware :

  • Development Tools
  • Business Intelligence
  • User Interaction
  • Content Management
  • Application Server
  • SOA
  • Security and Identity Management
  • Integration and Business Process Management (BPM)
  • Enterprise Management

67. What are the set enabled objects in Oracle Fusion HCM?

Ans:

    The set-enabled business objects are :

  • Locations
  • Grades
  • Jobs
  • Departments
  • Performance templates

68. Explain plan types in Oracle Fusion HCM?

Ans:

    There are three types of plans available in Oracle Fusion HCM, they are Accrual, qualification, and No Entitlement. Let’s get a clear overview of each plan :

    Accrual Plan :This Plan defined the purpose on which the workforce is opting for leave.

    Qualification Plan :This plan states whether a candidate is eligible to take the leave and wage payment during leave.

    No Entitlement : It tracks all leaves irrespective of paid or unpaid they are.

69. What are the core pillars of Human Capital Management?

Ans:

    Following are the four major pillars of effective human capital management :

  • Acquiring
  • Managing
  • Training
  • Retaining

70. Define Inclusiveness?

Ans:

    This is a process executed by management to invite suggestions from the workforce. Employees are the ones who know ground reality well and they know the key areas of improvement. Inclusiveness helps organizations in knowing the areas of improvement and makes employees feel happy for taking their feedback into consideration.

71. Name the tool used for Data Migration?

Ans:

    Data loader is the tool used for migrating data in Oracle Fusion HCM.

tool used for Data Migration

72. What are the system user types?

Ans:

    Following are the 4 system user types :

  • Employee
  • Non-worker
  • Contingent Worker
  • Pending Worker

73. In how many ways can you generate a Person Number?

Ans:

    We can generate a Person number in 4 different ways which include Manual, Automatic, upon save and final save.

74. Name the source keys available to load data?

Ans:

    Following are the source keys available to load data :

  • Source System ID,
  • GUID
  • User Keys
  • Surrogate ID

75. Name a few core tables available in Oracle Fusion HCM?

Ans:

  • Per_all_people_f
  • Per_all_assignments_m
  • Per_person_names_f
  • per_periods_of_Service

76. Name the sections of Oracle Fusion overall performance Template?

Ans:

  • Competency section
  • Worker very last comments section
  • Goal segment
  • Supervisor very last comments segment
  • Standard evaluate phase
  • Questionnaire segment

77. What is a FlexField ? What are Descriptive and Key Flexfields ?

Ans:

    An Oracle Applications field made up of segments. Each segment has an assigned name and a set of valid values. Oracle Applications uses flexfields to capture information about your organization.

78. What are different report triggers and what is their firing sequence ?

Ans:

    There are five report trigger :

  • Before Report
  • After Report
  • Before Parameter Form
  • After Parameter Form
  • Between Pages
  • The Firing sequence for report triggers is Before Parameter Form – After Parameter Form – Before Report – Between Pages – After Report.

79. How to attach reports in Oracle Applications ?

Ans:

    The steps are as follows :

    1. Design your report in D2K

    2. Generate the executable file of the report as .rdf.

    3. Move the executable as well as source file to the appropriate product’s folder.

    4. Register the report as a concurrent executable.

    5. Define the concurrent program for the executable registered.

    6. Add the concurrent program to the request group of the responsibility.

80. What is the use of Temp tables in Interface programs ?

Ans:

    Temporary tables are used in Interface programs to hold the intermediate data. The data is loaded into temporary tables first and then, after validating through the PL/SQL programs, the data is loaded into the interface tables.

81. What are the steps to register concurrent programs in Apps ?

Ans:

    The steps to register concurrent programs in apps are as follows :

  • Register the program as a concurrent executable.
  • Define the concurrent program for the executable registered.
  • Add the concurrent program to the request group of the responsibility

82. Do you have to register feeder programs of interface to AOL ?

Ans:

    Yes ! You have to register the feeder programs as concurrent programs to Apps.

83. What is Key and Descriptive Flexfield?

Ans:

      Key Flexfield: #unique identifier, storing key information

      # Used for entering and displaying key information.

      For example Oracle General uses a key Flexfield called Accounting

      Flexfield to uniquely identify a general account.

      Descriptive Flexfield: # To Capture additional information.

      # to provide expansion space on your form

      With the help of [] .

      [] Represents descriptive Flexfield.

84. Difference between Key and Descriptive Flexfield?

Ans:

    KEY FLEXFIELD
    DESCRIPTIVE FLEXFIELD
    Unique IdentifierTo capture extra information
    Key Flexfield are stored in segmentStored in attributes
    For key flexfield there are flexfield Qualifier and segment QualifierContext-sensitive flexfield is a feature of DFF. (descriptive flexfield)

85. What’s the market share of Oracle Fusion cloud?

Ans:

    If you’re looking for Oracle Fusion Cloud Technical Interview Questions for Experienced or Freshers, you are in the right place. There are a lot of opportunities from many reputed companies in the world. According to research, Oracle Fusion Cloud Technical has a market share of about 1.6%.

86. What is Oracle Integration cloud?

Ans:

    Oracle Integration cloud is a middleware platform offered by Oracle. This enables communication between multiple applications. All type of applications like Saas, on-premise can be integrated using OIC

87. What are the Applications in OIC?

Ans:

    OIC Offer three applications :

    a. Integration cloud service(ICS)

    b. Process Cloud service (PCS)

    c. Visual Builder Cloud Service(VBCS)

88. Oracle Integration cloud comes under which category of cloud?

Ans:

    Oracle Integration cloud is a platform as a service(Paas.

89. What is Integration in Oracle Integration Cloud?

Ans:

    Integration is the main ingredient of Oracle Integration, An Integration includes trigger (source. connection and invoke (target. connection and the field mapping between those two connections.

Oracle Integration Cloud

90. What is an adapter in Oracle Integration Cloud?

Ans:

    Oracle Integration Cloud (OIC. Adaptor is an abstract way to connect to any application with the help of a box adapter. There are 50+ adapters available in OIC, below are the categories :

  • Oracle Adapter(Oracle Sales Cloud, Oracle EBS, Oracle ERP adapter etc.
  • Non Oracle Adapter(Salesforce, Ariba, Concur etc.
  • Technology Adapter(REST, SOAP, FTP etc.

91. How many design patterns are available in OIC and what are those?

Ans:

    There are total Six Patterns in Oracle Integration Cloud :

  • App Driven Orchestration
  • Scheduled Orchestration
  • File Transfer
  • Basic Routing
  • Publish To OIC
  • Subscribe To OIC

92. What is App Driven Orchestration pattern?

Ans:

    App Driven Orchestration pattern is multi step pattern, allows invoking multiple applications in single flow, doing for-each loop, if-else logic, apply complex logic etc.

93. What is a Scheduled Orchestration Pattern?

Ans:

    Scheduled Orchestration pattern allows you to develop an integration which can run on predefined frequency and can be executed on adhoc basis.

94. What is File Transfer Pattern?

Ans:

    File Transfer pattern allows to move files across the network seamlessly and securely. This is again a scheduled type of pattern.

95. What is the Basic Routing Pattern?

Ans:

    Basic Routing pattern can connect only two applications with no logic.

96. What is published to OIC and Subscribed to OIC pattern?

Ans:

    Publish to OIC pattern allows to publish messages to OIC internal messaging queues. For example an event is subscribed from Oracle Sales Cloud and Publish the same into Oracle Integration Cloud messaging queue.

    Subscribe To OIC pattern subscribe messages from Oracle Integration Cloud messaging queue and sends the same to different applications

    These queue are managed by OIC itself and you don’t have access to them.

97. What is the basic Routing Pattern?

Ans:

    Basic Routing pattern can connect only two applications with no logic.

98. What is lookup in Oracle Integration Cloud?

Ans:

    Lookups are associated values used by one application for a specific field to the values used by other applications for the same field. This provides the capability to map values across vocabularies or systems.

    For example, the source application uses country code to represent the country, however the target application uses the country name to represent the country. These mapping can be maintained using Lookup and will be referred to by Integration during runtime.

99. What is a mapper?

Ans:

    A visual mapper is provided that enables you to map fields between applications with different data structures by dragging source fields.

100. What is the package in Oracle Integration Cloud?

Ans:

    Package is used to group one or more integration into a single structure. The package can be exported from the source instance and imported into the target instance. All integrations which are part of the package will be imported automatically.

Oracle Fusion - Cost Lines and Expenditure Item link in Projects

SELECT   ccd.transaction_id,ex.expenditure_item_id,cacat.serial_number FROM fusion.CST_INV_TRANSACTIONS cit,   fusion.cst_cost_distribution_...