Oracle fusion Financial interview questions

1-      What is Oracle fusion BPM (Business process Model)?

https://orasolonlinetraining.blogspot.com/2020/04/oracle-fusion-cloud-business-process.html

2-      Explain life cycle phases of P2P in fusion?

Intransit Shipment

Receipt

Invoice

3-      What are the key roles that needs for implementations?

Application implementation consultant

IT Security Manager

Employee

4-      What is the task name where we maintain the “retain earning account”?

Project> Specify ledger options

5-      For supplier configuration and definition which roles are mandatory

Supplier Management

Supplier Administrator

Procurement Manager

Procurement requestor

6-      How to define Exchange rate in fusion

In fusion, we can not define exchange rate manually but we can upload exchange rate through ADFDI.

7-      How to view Exchange rate and Exchange rate type in fusion

Go to task “Manage Daily Rates” > daily Rate

8-      What is ADFDI

ADFDI is an excel based tool which is used to manage a large volume of data from cloud applications by using an Excel Spreadsheet.

9-      What is difference between ADFDI & FBDI

In Oracle Cloud generally, data is uploaded through two excel tools i.e. FBDI and ADFDI. FBDI is more useful when the volume of data is very large but when the volume of data is not very large then ADFDI will be the best option as it is directly connected to the application.

10-   What are the major difference between Oracle EBS & Oracle Fusion Cloud

https://orasolonlinetraining.blogspot.com/2020/01/difference-of-ebs-r12-fusion-cloud.html

11-   What is Reference Data Sets in Oracle Fusion?

In Oracle Fusion Applications reference data sharing feature is also known as SetID. The reference data sharing functionality supports operations in multiple Business ledgers, business units, and warehouses to set the security control over data.

12-   What is Facilities

Define your manufacturing and storage facilities as Inventory Organizations if Oracle Fusion tracks inventory balances there and Item Organizations if Oracle Fusion only tracks the items used in the facility but not the balances.

13-   What is difference between chart of account structure and chart of account structure instance?

Chart of Accounts Structure

When creating the segments for the chart of accounts structure, you must enter segment sequence numbers that are consecutive and begin with the number one.

Chart of Accounts Structure Instance

For segments in your chart of account structure instance that you expect to contain a large number of distinct values, you must perform the following steps:

In the chart of accounts definition, mark the segment query required option as selectively required. To perform searches in the transactional user interface, you have to specify the following segment as a mandatory search criteria.

Create required indexes in the GL_CODE_COMBINATIONS table for segments that are selectively required.

14-   As implementation consultant you have assigned role to your user for Journal Creation but user is unable to create Journal and not even seen the ledger in his profile. What configuration you missed?

Data Access not assign to user

15-    Which task help to assign access to the user?

Manage Data Access set to User

What is OTBI and What are its core features?

It is a real-time online reporting tool querying directly from Fusion Application data.

This is an ad hoc analysis tool based on transactional data focused on operational and transactional reporting.

This tool requires no separate data warehouse as it uses Fusions database, which explains no ETL process needs to be run to populate any data warehouse.

Business users can easily create reports and dashboards through personalization.

It focuses on transactional and operational data such as invoices, payments and assets.

In OTBI, instead of constructing a SQL query, you can simply drag and drop selected data from subject areas and use different graphical views.

Users can create out of the box reports (e.g reconciliation reports).

The more commonly used reconciliation reports are receivables to GL recon report and payables to GL recon report.

In OTBI, instead of constructing a query, you can simply drag and drop selected data from subject areas using different graphical views.