Reports and Analytics

GL-Reports:

Payables:

Expense Distribution Detail Report: Payables create the liability distributions when you submit Approval
for an invoice. You cannot overwrite the accounts since Payables does not display online the offsetting
account for each invoice distribution. However, you can review the liability distributions on the Expense
Distribution Detail Report.
Payables Trail Balance report
AR Reports

FA reports
CM Reports

What is AP/AR Netting?

It is the setting of AP and AR invoice with the same vendor and customer
outstanding.

What are the different statuses of an accounting period?

The different statuses are:

 Never Opened – The user cannot enter or update journals.

 Open – Allows you to enter and port journals to any period that is
open.
 Future Enterable – Allows you to enter a journal but cannot post.
 Closed – A user can’t post journals in a closed period. To post
journals, one must reopen the closed periods.
 Permanently Closed – Not possible to open permanently closed
periods.

What is Oracle Rollout project?

Roll out: this is the project where client already has implemented oracle in his
one business and if he wanted to implement same oracle in another country as
well then, that project will be called as rollout project.

Bills payable: Issued the Future Dated Payment/Post Dated Check method while creating the Invoice
with future maturity date.
Ledger set period close: To grouping the multiple ledgers in one single ledger to do transactions,
however, the Cal & COA must be equal for Ledger set Ledgers.

AP
AP Period Closing issues:
P2P

AR
GL

Revaluation: Usually this will be incurred due to foreign currency journals. This will be run at Current
Assets and Current liabilities accounts. And Revaluation journals will be created the system based on
Accounts Payables account based on Revaluation setups.

Daily rates 10/12/202170; 15/12/202175.

Create JEINR 70 and Post it

Period CloseRun Revalue balances as 15/10/2021 then system will automatically create the
Revaluation JE’s.

What is Primary Ledger Vs Secondary Ledger Vs Reporting Currency?

Primary Ledger Vs Secondary Ledger
Use secondary ledgers for supplementary purposes, such as consolidation, statutory reporting, or
adjustments for one or more legal entities within the same accounting setup.
For example, use a primary ledger for corporate accounting purposes that use the corporate chart of
accounts and subledger accounting method, and use a secondary ledger for statutory reporting
purposes that use the statutory chart of accounts and subledger accounting method.
This allows you to maintain both a corporate and statutory representation of the same legal entity’s
transactions in parallel.
Reporting Currency Vs Secondary Ledger
Reporting Currencies are not the same as secondary ledgers. Looking at the 4 C’s that define a ledger,
we have a chart of accounts, calendar, accounting method, and currency. If you only need multiple
currencies to support your reporting requirements, use reporting currencies. If you need to account for
your data using different calendars, charts of accounts, accounting methods in addition to currency, use
a secondary ledger.
What is Key flex filed how many types in GL, AP, AR, & FA?
Key Flex field: is used to capture mandatory information of the organizations
 In GL 3 types 1. Accounting flex field (mandatory) 2. Reporting attribute (optional) 3. Gl ledger

flex field (optional)

 IN AP No flex fields

 IN AR Two types 1. Sales Tax Location flex field (mandatory) 2. Territory Flex field

 In FA Three Flex field i.e., Category (mandatory), Asset key (mandatory), Locations flex field.

How many types of AP Invoices?

AP INVOICES: 11 invoices are there
1) Regular invoice - 9,
2) Special invoice - 2
1) Regular Invoice
 Standard invoice
 Credit memo
  Debit memo
 Prepaid invoice
 Expense report
 Quick invoice
 Mixed invoice
 PO default
 Withholding Tax invoice
2) Special Invoice
 Recurring invoice
 Interest invoice

19. How Many types of AR Invoices?

AR TRANSACTIONS (Invoice) - 7
 Invoice
 Credit memo
 Debit memo
 Deposit
 Guaranty
 Chargeback
 Bills Receivables

Implementation process workflow: Basically, Implementation should be done in two Environments such
as Non-Production & Production Environments.

Hypercare: This is period where the difference between the Targeted date and next targeted date which
the company operating period which will upload in their legacy systems. (After the Cutoff date of Data
Migration proposal date)

Plan Design

Configure Non-Production Environment Signoff from client

Validate

Transition

Production Environment

Realization Once Signoff client is completed then it

will be migrated to Production
Environment

Data Migration from EBS to Fusion: 4 steps approach in Data migration. Usually, it will happen in two
ways through FBDI or Automate Data migration using webservices. Ex: Journal Import, Suppliers,
Customers etc.,

Bills payable: Issued the Future Dated Payment/Post Dated Check method while creating the Invoice
with future maturity date.

Ledger set period close: To grouping the multiple ledgers in one single ledger to do transactions,
however the Cal & COA must be equal for Ledger set Ledgers.
Prepayment invoice not able to find out during the apply/unapply prepayments: Due to Unpaid of the
Prepayment invoice the concern amount was not available for the supplier, for this reason we may not
be able to see the Prepayment invoice, so always the prepayment invoice should be paid before to the
unapply/apply the prepayments.

Supplier PO P2P flow- General receipt of material-->Create Invoice-->Make the Payment-->Transfer to

GL.

What is the difference between debit memo and credit memo in Oracle AP?

Ans: Credit Memo and Debit memo are used to create a negative amount invoice. Credit Memo is a negative
amount invoice you receive from a supplier representing a credit. Debit Memo is a negative amount invoice you
send to notify a supplier of a credit you recorded for goods or services purchased.

What is the difference between debit memo and credit memo in Oracle AR?

Ans: A debit memorandum or memo is a form or document, sometimes called a debit memo invoice, that informs
a customer that the seller is debiting or increasing its amount in the Accounts receivable. A credit memo is a
commercial document issued by a supplier to the customer notifying the reduction of the amount that a customer
owes to the seller.

Multi-Period Accounting (MPA): Ex: Software licenses/Advertisement Expenses: Usually if the expenses is
incurred in current year but the entire Expenses are not accounted in current year and will be accounted equal
portions over the period which is called as Deferred Exp. This process is called to MPA in fusion, and it is given by
oracle by default based on pro-rate basis.

Multi-Period Posting enables expenses to be recognized over multiple periods when the supplier issues one
invoice. With Multi-Period Posting, users register an invoice once to automatically prorate it over the required
periods and accounting entries are generated accordingly.
Run ESS job for Create Multiperiod Accounting.
Journal Entries in MPA: (Ex:Inv amount 15,000 accounting for 12 months ie., 15,000/12=1,250this is called Item
Expense for every period.

Deferred Item Exp…Dr 15,000

To Liability Cr 15,000

After creation of multi period then

Item Expense…Dr 1,250

To Deferred Item Exp Cr 1,250

Journal Entries
Procure-to- Pay Accounting Entries:
When we receive the Goods in the staging area the accounting entry would be (GRN):
Receiving Inventory --- Dr
Ap Accrual --- Cr
When we are moving the Goods from Staging area to Sub-Inv (Recv Trans):
Material A/C --- Dr
Receiving Inv --- Cr
While Creating Invoice:
Ap Accrual --- Dr
Liability ---- Cr
While Making Payment:
Liability A/c—Dr
Cash clearing A/c---Cr
Reconciliation:
Cash Clearing a/c--- Dr
Cash a/c --- Cr
Standard Invoice:

Expenses --- Dr
Liability ---- Cr

Debit and Credit Memo Entries:

Liability --- Dr
Expenses --- Cr

Accounts Receivable (AR) entries:

Creation of Transaction

Receivables Ac---Dr
Revenues---Cr

Creation of Receipt

Confirmed Cash ---Dr

Unapplied Cash---Cr

Prepayment Entries:
While Creating Prepayment Invoice:
Prepayment --- Dr
Liability – Cr
While Making Payment to Prepayment:
Liability – Dr
Cash – Cr
While applying Prepayment on Standard Invoice:
Liability --- Dr
Prepayment –Cr

Bills Payable Entries: FUTURE DATED PAYMENT ENTRY

When Bills Issued:
Item Expense – Dr
Bills Payable --- Cr
When Maturity Date Confirmed:
Bills Payable – Dr
Liability – Cr
2-way matching accounting entries
1. Purchase order created (No financial impact of JE)
2. Invoice is received and applied
Expenses----Dr
Accounts Payable---Cr
3. Payment made:
A/c Payable—Dr
 Cash---Cr
Data migration through FBDI (File Based Data Import):

Ex: Journal Import/Supplier Import/Customer details

Manual Process Flow:

 Download the files from Oracle OER (Oracle Enterprise Repository)

 Fill the file and save it in zip file under the csv format.
 Upload file to UCM (File import and export) in Tools.
 Load data to Interface tableFix the errors if any and reprocess again to extract the correct
data
 Import data to applicable table using import job
 Data successfully transfer to Oracle fusion cloud

Data migration from EBS to Fusion: Oracle Fusion is the next generation ERP, when Oracle EBS is the
already proven ERP.
Benefits due to Migration (EBS vs Fusion):

 The workflow is better in Fusion when compared to EBS

  The security is way better in Fusion as it is a cloud-based application
 The SOD (Segregation of Duties) is available in Fusion whereas in EBS the users will have to hire
consultants to do the SOD and role creation
 When it comes to reporting, Fusion lets its user export in any format whereas in EBS, the export
functionality is limited. Therefore, reporting is an exceptional feature in Fusion
 Technology wise Fusion is far-ahead of EBS. It’s got OTBI (Oracle Transaction Business
Intelligence) and Hyperion. These technologies will be more favorable for the business users.
And if EBS users want these technologies in their application, then they will have to buy them
separately which will obviously be heavy cost to the companies.
 Technicality and complexity are less in Fusion
 The dashboard in Fusion makes things easier in Fusion, users can easily locate problems
 Business users can create Adhoc reports for real-time data in Fusion, whereas in EBS, the
business users will have to run several queries
 Fusion has a multi-currency payment

Ex: GL (EBS vs Fusion)

Here is a list of modules which could be migrated.

 Receivables (AR)
 Cash Management (CM)
 Payables (AP)
 iExpenses (Fusion Exp)
 Fixed Assets (FA)
 General Ledger (GL)
 EBTax (Fusion Tax)
  Inventory
 Receiving
 Shipping
 Projects Billing
 Projects Costing
 Projects Foundation
 Projects Management
 Purchasing
 Sourcing
 iProcurement

Below are the steps or stages usually followed for migration.

PlanningPreparation Pre-migration Downtime post-migration.

Expenses Report
Usual workflow: Usually if an Employee incurred some expenses due to Travelling and conveyance,
hospitality & food, and beverages costs etc., these will be created in Expenses report, and it will be
reimbursed from the company by the Employee based on below work flow.

Enter Expenses ReportApproval (App Hierarchy)Audit (Finance Dept Audits)Reimbursement

Key setups-Fusion Expenses:

  Configure Expenses System Options
 Create Expense Report Templates
 Create New User: ERPCLOUDMGR (supervisor)
 Create Employee/Supervisor Relationship
 Provide Default Expense Account
 Create Approval RulesApproval Group
 Assign Roles to User
 Provide Data Access to Business Unit
 Create Expense Report & Submit for Approvals
 Supervisor: Approve Expense Report
 Run " Process Expense Reimbursement" ESS job
 Find Payment Request Invoice in AP

Expenses system options:

Define Default Expenses AccountManage usersEmployeeActionsExpenses information

Define Expenses templateParking, Travel, Food, Other etc.

Approval Group: Create RuleExpenses reportApprove by supervisor

Run “Process Expense Reimbursement” job and find the Payment request invoice
in APValidatePay in fullTransfer to GL as usual.

 How will the Retained Earnings be captured in GL?  Retained Earnings account: When you
open the first period of a fiscal year, General Ledger posts the net balance of all income and
expense accounts from the prior year against your retained earnings account.

 Receipt Status in AR
 Approved
 Confirmed
 Remitted
 Cleared
 Reversed
Financial Statement Generator (FSG) is a powerful report-building tool for Oracle General
Ledger. With FSG, you can: Generate financial reports, such as income statements and
balance sheets, based upon data in your general ledger.

Interface vs Base tables: Interface tables are intermediate tables into which the data is
inserted first. Once the data gets inserted into the interface tables, the data is validated, and
then transferred to the base tables. Base tables are real application tables that reside in the
application database
Data flow:
Data InsertionInterface tablesData validatedBase TablesTransfer to application

Review & Submit Accounting Setup

Define Legal EntitiesAssign LE to Accounting setupDefine Primary LedgerDefine Secondary

LedgerDefine Accounting OptionsComplete accounting setup

Steps for Closure of books

PostReviewRevalueTranslateConsolidateRun accounting reportsClose Accounting

Period.

1. What are the Reporting tools available in the Oracle Fusion?

 BIP Reports
 OTBI reports
 Smart View Reports: Smart View is Excel Add In based Reporting Tool Suitable for
End users comfortable with Excel spreadsheets. This Provides the Multidimensional
View of data. Smart View Only provided the GL data.

 Financial Reporting Studio: 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, or Point of Views (POV).

Types of Roles

Abstract Roles: These are not specific to any application; it is used by all the application like Employee or
Contingent worker roles.
Job Roles: These are the roles that we assign to perform any application like General Accountant;
Accounting Manager roles for accessing GL; similarly Accounts Payables Manager, supervisor to access
the Payable application.

Duty Roles: These roles are part of Job Roles; means in the Accounts payables manager job roles to
create the invoice & payment creation these duty roles will be useful for the users. These can’t be
assigned directly to the users.

Data Roles: For example, a data role entitles a user to perform a job in a business unit. The data role
inherits abstract or job roles and is granted data security privileges.

What is BPM in Oracle Fusion?

BPM means Business Process Management. BPM is a complete set of tools for creating, executing, and
optimizing business processes in Oracle Fusion. We can design the approval processes in BPM. We
can design the Business approval processes in Oracle fusion with the Help of BPM. This is an Integrated
Tool available in Oracle fusion to design and maintain approval rules as per the business needs.

BPM Worklist: BPM worklist is list of BPM workflows available in Oracle fusion which we can design as
per our business Requirement 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.
Ex:

Recurring journals use for those entries which we entered or reported every month. With the Help of
Recurring Journals, we don’t need to enter these manually every month but instead off system will do this
automatically.
Three Recurring Journals
Skeleton Journal Entries: Skeleton entries affect the same accounts each period but have different
posting amounts.

Standard Recurring Journal Entries: Standard recurring journal entries use the same accounts and
amounts each period.

Recurring Journal Formula Entries: Formula entries use formulas to calculate journal amounts that vary
from period to period.

Business Units:

 One Primary Ledgeruser can create many BUwith the same COA
 Separate Primary LedgerEach BUDifferent financial period for BU

Can We close the Accounting Period for the Different Business Units under a single Ledger separately?

Answer: No, we cannot close the Accounting Period for Different Business units for the same
ledger separately. The Reason is We are sharing the Same Ledger so in the Ledger there will be only
one Calendar that is shared to both Business Units. So, it means if one Business unit will close the Accounting
Period then the period will be close to both Business unit for this Ledger.

Enterprise Structure components

Automatic Offset in Common options for payables & procurement workbench:

If you enable Automatic Offsets, Payables automatically allocates an invoice's liability amount across
multiple balancing segments according to the balancing segments on the invoice distributions. This
ensures that invoices always balance by balancing segment.
Payables create the liability distributions when you submit Approval for an invoice. You cannot
overwrite the accounts since Payables does not display online the offsetting account for each invoice
distribution. However, you can review the liability distributions on the Expense Distribution Detail
Report.
If you do not enable Automatic Offsets, Payables records the invoice liability using the liability account
on the invoice, which defaults from the supplier site. When you distribute invoice distributions across
multiple balancing segments, the invoice will not balance by balancing segment. However, General
Ledger can automatically create intercompany balancing entries when you post the invoice if you have
enabled the Balance Intercompany Journals option for your set of books.