Index
Please note that index links point to page beginnings from the print edition. Locations are approximate in e-readers, and you may need to page down one or more times after clicking a link to get to the indexed material.
A
access policies, Fusion Applications, 161
account analysis reports, period close, 300
account combination, ledger accounts, 93
account groups, Account Monitor, 316–317
Account Inspector, 306, 334–336
account rule, Chart of Accounts Mapping, 149–150
account values, Account Inspector, 336–337
accounting
Fusion Accounting Hub integration for, 24
introduction to, 18–21
ledger accounts in Oracle applications, 21–24
overview of GL, 16–18
accounting calendars. See Calendar
accounting configuration
assigning balancing segments to legal entities, 137
creating ledgers, 124
defining ledgers, 130–132, 134, 138
enable journal approval for ledger, 209
reviewing and submitting, 142–143
Accounting Dashboard
budget capture with ADFdi spreadsheet, 218
configuring revaluations, 298
general allocation journals, 286
overview of, 26
in period close, 300–301
accounting events
ledger strategy and, 11–12
overview of, 232–333
processing to create journals, 229, 232–233
securities trading use case, 89
accounting flexfields, 21–22, 106–110
Accounting Method
configuring accounting rules, 244–246
configuring Fusion Accounting Hub, 231–232
creating ledgers, 120–121, 128, 130–132
creating Secondary Ledgers, 122, 139–140
in Primary Ledger, 121
in Reporting Currency, 123
Subledger, 129
accounting period, 275
accounting rules, FAH
creating, 228
creating application, 237–238
creating event model, 238–240
creating system event and import journals, 246–248
defined, 25
accounting transformation engine, FAH, 225
Accounts Payable (AP), General Ledger, 16
Accounts Receivable (AR) transactions
basic accounting concepts, 19–21
posting into General Ledger, 16
processing invoices in, 17
accruals, in period close, 293–295
ACME Bank, examples in this book, 2
actual journals
business requirements for, 199
creating, 201–203
overview of, 218
ad hoc analysis reports, 304–305
Address Cleansing, Geographies, 86
ADF Desktop Integrator Tool (ADFdi spreadsheet), 218–219
adjustment entries
balance transfer consolidations, 260
period close, 293–295
report-only consolidations, 258
adjustment journals
adjustment entries in period close, 293–295
rectifying trial balance in period close, 291
replicated in Secondary Ledger, 122–123
agent
creating for delivering OTBI report to yourself, 322–323
selecting report delivered by, 323
Allocate Wizard, allocation rules, 282
allocation journals, 194, 273, 286
allocation rule
business requirements/account setup for, 276–278
creating, 279–285
creating cost center hierarchy for, 278
generating allocation journals, 286
allocations, GL
business motivation for, 271
creating allocation rule, 279–285
creating cost center hierarchy, 278–279
defining business requirements, 276–278
Essbase cube and process of, 272–276
generating allocation journals, 286
other Oracle products vs. Fusion Financials, 271–272
overview of, 270–271
at period close, 301
Allocations Manager, 295
Analysis Dashboards. See reporting tools, financial
Analytics Dashboard, OTBI reports, 319, 321
analytics reports
using BI Publisher, 324
using OTBI, 321–322
AP (Accounts Payable), posting into General Ledger, 16
APM. See Authorization Policy Manager (APM)
Application Implementation Consultant job role, 41
Application Implementation Manager job role, 40–41
application roles. See also duty roles
overview of, 167–168
role hierarchy, 168
application users
assigning tasks to, 47–48
creating, 340–344
in implementation project, 41–42
Approval Group rule set, 213–215
approvals. See journal approvals
AR. See Accounts Receivable (AR) transactions
Asset account
defined, 18
rules for debit and credit ledger entries, 19
use-case of securities trade transactions, 90
Assign Legal Entities, 134–136
Associated Features report, FSM, 37–38
attributes
accounting rule, 231
value set values, 111
audits
centralizing, 12
Oracle Platform Security Services and, 166
system, 177–179
authorization
Authorization Policy Manager for, 165
in Fusion Applications, 169–170
understanding, 160
Authorization Policy Manager (APM)
authorization policy, 166
data security, 8
overview of, 165–166
user interface, 170–175
automatic journals, 194–195
AutoReversal, creating reversal journals, 194
B
Balance-Transfer Consolidation
advantages and disadvantages, 262
for cross-ledgers, 266–268
other consolidation methods vs., 256
proposing, 264–265
balances
Chart of Accounts Mapping for, 147–150
as dimension in GL cube, 276
foreign currency, at period close, 295–300
in intercompany accounting. See Intercompany Accounting
multidimensional view of in GL account, 273–276
storing in Essbase, 272
transfer process for automatic journals, 195
viewing GL, with Account Inspector, 336–337
viewing GL, with Smart View in Excel, 333–336
Balances data conversion level
Reporting Currency, 123
Secondary Ledger, 122
Balancing segment, CoA, 22
balancing segment labels, CoA, 93–94
Balancing Segment Values (BSVs)
assign to Legal Entities, 125, 137
assigning to ledgers, 125, 137–138
association with other components, 127–128
intercompany accounting with. See Intercompany Accounting
overview of, 125
batches, of Financial Reporting Studio reports, 306
BI (Business Intelligence) tools, 92
BI Publisher reports
bursting report output with multiple delivery options, 326–327
data sources for, 325–326
formatting output with templates, 327
Fusion financial reporting with, 226
listing journal batches for last day, 328–331
other reporting tools vs., 306
overview of, 324–325
report output, 327
scheduling capabilities, 326
books, Financial Reporting Studio reports as, 306
BPEL (Oracle Business Process Execution Language), 206–207
BPM (Business Process Management), high-level close period in, 301–302
BPM Worklist
accessing, 209–210
creating static approval group, 212–213
disabling Supervisory Journal Approval rule set, 209–212
enabling journal approvals, 207–208
Journal Batch approval in, 216–217
browser, viewing GL balances with Account Inspector, 336–337
BSVs. See Balancing Segment Values (BSVs)
budgets
budget journals, 218
budget scenario dimension, 276
business requirements, 220
capture methods, 218–219
creating budget scenarios, 220–221
enabling data security, 221–222
entering on spreadsheet, 221
Implementation Project Manager role, 39
ledger strategy for, 12
monitoring with Account Monitor, 315–316
overview of, 218
scope of financial transformation for, 12
Business Intelligence (BI) tools
BI Publisher. See BI Publisher reports
multiple-segment CoA/dimensions in, 92
Business Objects, FSM
creating configuration package, 50–52
exporting/importing setup data, 54–55
FSM process flow, 38–39
as key concept, 35–36
in multiple offerings, 49
business objects, in system auditing, 177–179
business processes
currency-related GL, 114
motivations for using allocations, 271
business requirements
budget capture methods, 218–219
creating allocation rule, 276–278
creating budget, 220
creating journals, 199–200
Fusion Accounting Hub, 232
implementing security, 180
security architecture, 160
Business Unit Function, 146
Business Units
assigning Business Functions to, 125–126
association with other components, 127–129
creating, 144–146
creating Enterprise Structure manually, 65–66
creating within Enterprise entity, 61
defined, 120
implementation considerations, 126–127
Management Structure with, 60
overview of, 125
referencing data sets/sharing methods, 127
understanding big picture, 127–129
Business Users (Functional Users), 40, 41
Calculation Manager, EPM, 272–273, 279–285
Calendar
association with other components, 128
creating in Fusion Financials, 112–114
creating ledger, 120–121, 128, 130
implementation requirements, 112
overview of, 112
in Reporting Currency, 123
selecting start period, 114
cash position
addressing business process pain point, 7
as business process pain point, 3
Fusion Application solution for, 43
centralized audits, 12
centralized configuration, FSM, 32
Centralized Financial Systems Platform, 42
centralized payment system, 7
Chart of Accounts (CoA)
associations of, 127–128
configuring GL design, 23
consolidation, and common, 11
data inconsistency in, 8
dimensions in GL cube, 275
in E-business Suite R12 vs. Fusion Applications, 24
in ledgers, 120–121
monitoring balances with account groups, 316
multidimensional cube in, 305–306
in Primary Ledger, 121
in Secondary Ledger, 122–123
segments in, 22–23
Chart of Accounts (CoA) structures
building blocks, 93–95
concept of, 89
design considerations, 97–101
for global CoA, 98–99
for Insurance CoA, 101
for multiple segments, 89–92
for reporting, 224
vs. CoA instances, 95–96
Chart of Accounts (CoA) structures, implementing
creating value set values, 109–112
creating value sets, 102–105
defining instances, 108–109
defining structures, 105–108
overview of, 101–102
Chart of Accounts mapping
account rule, 149–150
in Balance Transfer Consolidation, 260, 267
in Hyperion Financial Management consolidation, 261
navigation for, 147–148
overlapping segment/accounting rules, 150
overview of, 147–150
from Primary Ledger to Secondary Ledger, 141–142
scenarios using, 147
segment rule for, 148–149
when to use, 123
Close Status region, period close, 301
cloud implementations
close procedures, 302
configuring journal approvals for, 206–207
implementing with OUM, 33
CoA. See Chart of Accounts (CoA)
comma-separated values (CSV) flat files, budget capture, 219
command-line script, exporting/importing setup data, 55
comparison reports, 53–54
Complete button, validating journal entries, 202
condition filter, cross-validation rule, 115–116
configurable screens, and accounting rules, 9
configuration packages
creating, 50–53
exporting all tasks within, 55
in FSM process flow, 38–39
Configure phase, FSM, 38, 42–45
confirmation message
accounting flexfield deployment, 110
assigning role to application user, 344
completing accounting configuration, 142–143
creating application user, 342
data roles for user, 184
journal approvals, 211
journal posting program, 202, 206
consolidation
automatic journals for, 195
Balance-Transfer Consolidation, 259–260, 262, 266–268
defined, 250
elimination entries in, 251–255
Hyperion Financial Management method, 260–261
of intercompany entries, 9, 12
management of, 251
overview of, 250
process of, 250–251
Report-Only Consolidation, 257–259, 261
requirements, 262–264
constant value mapping, CoA mapping, 148
Contingent Worker role, 344
copy value mapping, CoA mapping, 149
Cost Center hierarchy, 278–281
Cost Centre segment, CoA, 22, 94, 99
cost management
address with centralized system, 7
allocation of cost, 270–271
as business process pain point, 3
Cr (Credit)
basic accounting concepts, 19–21
configuring revaluations, 297
in double-entry accounting systems, 89
rectifying trial balance in period close, 291–292
statistical journal entries as, 218
Create Account Rule screen, 242
Create Accounting Calendar screen, 112–113
Create Accounting job, 247–248
Create Balances Cubes process, 142–144
Create Configuration package, 51–53
Create Implementation Users task, 340
Create Journal, 193–194, 198, 201–204
Create Process Category button, 238
Create User link page, OIM, 341–342
cross-ledger balance transfers, 259–260, 266–268
cross-validation rules, journals, 115–117, 198
CSV (comma-separated values) flat files, budget capture, 219
Currency
association with other components, 128
in Balance Transfer Consolidations, 260
exchange rate, 115
journal entries with foreign, 201
in ledgers, 120–121
list of dimensions in GL cube, 276
in Report-Only Consolidations, 257–258
Reporting Currency feature, 123–124
role in business processes, 112
custom reports, OTBI, 317–318, 320
D
dashboards
Accounting Dashboard. See Accounting Dashboard
Analysis Dashboards. See reporting tools, financial
Fusion Accounting Hub features, 26
scope of financial transformation, 13
data
access sets, 181–188
addressing inconsistency of, 4, 8
auditing changes in, 180
conversion, in Secondary Ledger, 122–123
FAH minimal requirements for, 227–228
technical pain points for, 4–5, 8
data model builder, BI Publisher, 328–329, 342–345
data roles
creating, 186–188
data security with, 172–174
generated by role templates, 174–175
ledgers, 143–144
lines of business, 188–190
overview of, 167
data security
budget data access, 221–222
for database resources, 171–174
in Fusion Applications, 170–171
with Oracle APM, 8
as technical pain point, 4
data sets, journal batch listing, 328–329, 331
data sources
building BI Publisher reports, 325–326
in Fusion Financials, 305–306
data tables, BI Publisher report, 330–331
database administrators (DBAs), 233–234
database objects, accounting events, 233–234
databases, securing resources, 171–174
DBAs (database administrators), 233–234
deferrals, in period close, 293–295
Delegated Administration, OIM, 341–344
delimiter symbols, account combination, 93
delivery
bursting BI Publisher report, 326–327
OTBI report, 321–324
Departments, Enterprise Structure, 60, 61
dimensions
creating allocation rules, 279–282
creating reports in Smart View, 334–335
creating role templates, 187
data granularity via, 174
list of in GL cube, 275–276
in multidimensional databases, 274
in multiple segment CoAs, 92
for OTBI reports, 318
of reports in Financial Reporting Studio, 306, 312–313
Divisions, Management Structure, 60
documentation
addressing, 9
journal approvals, 207–208
as technical pain point, 5
double-entry accounting systems
basic concepts of, 19–21
CoA/multiple segment CoA structure, 89
journal entries recorded in, 192
trial balance in, 290
Dr (Debit)
basic accounting concepts, 19–21
configuring revaluations, 297
in double-entry accounting systems, 89
rectifying trial balance in period close, 291–292
statistical journal entries as, 218
drag and drop, Financial Reporting Studio reports as, 310–311
drill-down functionality
Account Monitor, 316
Financial Reporting Studio report, 312
Fusion Accounting Hub, 25
in multidimensional data model, 275
duty roles
Authorization policy via, 166
creating in APM, 166
Fusion Applications security, 162
OTBI, 318–319
overview of, 167
E
E-Business Suite (EBS), Oracle
generating allocation journals in, 273
Mass Allocations in, 272
security layers of Fusion applications vs., 162
ECS (Enterprise Structure Configurator), 63–64
EIN (Employer Identification Number), 76, 80
elements, Chart of Accounts, 11
Elimination Company codes, 253, 254
elimination entries, consolidations, 251–255, 258, 260
Elimination Ledger. consolidations, 255
email, 321
Employee Worker role, 344
Employer Identification Number (EIN), 76, 80
entered (or transaction) currency, 114
Enterprise Performance Management (EPM), 272
enterprise resource planning (ERP), 161–163
enterprise roles, 167
Enterprise Scheduler Service (ESS), 273
Enterprise Structure Configurator (ECS), 63–64
Enterprise Structure for Financials
creating manually, 64–66
creating with ECS, 63–64
defined, 60
Geographies, 83–86
high-level components of, 61–63
overview of, 60
Enterprise Structure for Financials, implementing
association with other components, 127–129
creating Legal Authorities, 76–77
creating Legal Entities, 79–81
creating Legal Entity Registrations, 81
creating Legal Jurisdictions, 74–76
creating Legal Reporting Unit, 81–83
defining Legal Address, 78–79
Global Enterprise Structure Model, 70–73
requirements, 66–70
updating Setup Enterprise, 73–74
entitlements, in APM, 165, 169–170
EPM (Enterprise Performance Management), 272
EPM System Workspace, allocation rules, 279
ERP (enterprise resource planning), 161–163
ESS (Enterprise Scheduler Service), 273
Essbase cube
allocations process and, 272
association with other components, 128–129
creating Financial Reporting Studio report, 310
generating allocation journals in, 273
multidimensional reporting via, 305
multidimensional view of GL balances, 273–276
Essbase tab in Excel, Smart View report, 333–335
event model, configuring FAH, 238–240
events
audits of, 180
BI Publisher scheduling and, 326
configuring accounting rules, 230
creating system, 246–248
in FAH implementation, 226
Excel
creating budget data with spreadsheets, 221
Financial Reporting Studio reports in, 306
manual journal entry via spreadsheet upload, 194
spreadsheet template, 57
viewing GL balances with Smart View in, 333–336
exchange rate, journal entries with foreign currency, 201
expense management
address with centralized system, 7
allocation as process of spreading, 270–271
as business process pain point, 3
Export and Import Setup data
advantages of FSM, 32
comparing/importing configuration package, 53–54
create configuration package, 50–53
in FSM process flow, 38–39
high-level processes of, 50
overview of, 49
points to consider, 56–57
Extended Chart of Accounts, 7, 8
F
FBI_TRANSACTIONAL_BUSINESS_INTELLIGENCE_WORKER role, OTBI, 318
Feature Choice, 43–44
features and functionality
addressing with best-of-breed products, 7
as business process pain point, 3
Features, FSM key concept, 35–36
FFAH (Fusion Financial Account Hub), 11
fields, Journal Entry structure, 195–197
filters
cross-validation rules, 115
specifying when configuring revaluations, 297–298
Financial Accounting Hub (FAH)
in implementation project phase, 42, 44
importing journals with, 195
now called Fusion Accounting Hub. See Fusion Accounting Hub (FAH)
Financial Reporting Center, 306–307
Financial Reporting Studio
building GL report, 309–315
Financial Accounting Hub leveraging, 226
installing, 308–309
other reporting tools vs., 306
overview of, 306–308
financial transformation
addressing business process pain points, 6–7
addressing technical pain points, 8–9
implementing architecture for, 6
scope of, 9–13
selecting financial system to address, 6
Financials Domain, 27
Financials Reporting Structures
Calendars. See Calendar
Chart of Accounts structures. See Chart of Accounts (CoA) structures
Currency. See Currency
overview of, 88
FinGlJrnlEntriesApprovalComposite, journal approvals, 206–207
Firefox Browser, Financial Reporting Studio compatibility, 309
first period, in newly created ledgers, 144
Fixed Assets transactions, posting in GL, 16
flexfields, accounting, 21–22, 106–110
folders, saving reports in, 313
foreign currency
convert to ledger functional currency, 115
revaluating balances at period close, 295–300, 301
formats, BI Publisher report, 327, 331
Functional Setup Manager (FSM)
accessing BPM Worklist, 210
Configure stage, 42–45
create Application Users, 41–42
creating ACME value sets, 102–104
creating implementation projects, 32–33
defining ACME CoA structures, 105–108
Financials Rapid Implementation Task list, 55–57
Implement stage, 45–49
import and export setup data, 49–55
key concepts and terminology, 34–36
Plan stage, 42
process flow, 36–39
Setup and Maintenance Work Area, 33–34
users of, 39–41
functional structure, implementing, 60
Fusion Accounting Hub (FAH)
Accounting Flexfield, 22
addressing business pain points, 7
benefits of, 25–26
components of, 224–226
creating database objects, 233–235
Implementation phase of implementation project, 42
implementing, 226–232
implementing business requirements, 232–233
technology enabling, 26–28
Fusion Accounting Hub (FAH), configuring
accounting rules, 241–246
creating application, 236–237
creating configuration implementation project, 236
creating event model, 238–240
creating GL Journal Source, 236
creating system event and import journals, 246–248
overview of, 235–236
Fusion Financial Account Hub (FFAH), 11
Fusion Payrolls, 63
Fusion Tax, 63
G
General Accounting Dashboard. See Accounting Dashboard
General Ledger (GL)
Account Monitor in, 316
Accounting Flexfield in, 22
accounts in Oracle applications, 21–24
allocations. See allocations, GL
basic accounting, 19–21
chart of accounts. See Chart of Accounts (CoA)
Chart of Accounts design in, 23, 97
creating Financial Reporting Studio report, 309–315
creating users/related roles, 181–188
currency-related business processes and, 114
Essbase cube created when configuring, 273
Fusion Accounting Hub features in, 25–26
generating allocation journals in, 273
in HFM consolidations, 261
implementing in Plan phase, 42
implementing with FAH. See Fusion Accounting Hub (FAH)
intercompany accounting in. See Intercompany Accounting
list of dimensions in GL cube, 275
multidimensional cube automatically set up in, 305–306
multidimensional view of balances in, 273–276
overview of, 16–18
replicated in Secondary Ledger, 122
reporting Chart of Accounts with FAH, 224
subledgers vs., 17
technology enable, 26–28
viewing balances with Account Inspector, 336–337
viewing balances with Smart View in Excel, 333–336
working with journals. See journals
Geographies, Enterprise Structure, 84–86
Getting Started link, Plan stage in FSM process flow, 37
GL. See General Ledger (GL)
GL_BALANCES table, 27
Global Chart of Accounts (CoA)
defining instances, 108–109
defining structures, 105–108
goals of financial transformation and, 11
segments assigned, 107–108
structure of, 98–99
Global Enterprise Structure Model, 70–73
goals, of financial transformation, 11–13
governance, of financial transformation, 12
granularity, FAH, 228
group(s)
creating user, 168
Financial Reporting Studio reports in, 306
Journal Batch, 195–196
static approval, 212–213
H
HCM (Human Capital Management) systems, 169, 208
HFM (Hyperion Financial Management), 256, 264–265
hierarchies
allocation across organizational, 270–271
Cost Center, 278–281
creating account, 94–95, 99–100
Fusion Applications role, 162
Geography, 84
role, 168
high-resolution reports. See BI Publisher reports
HR Work structure, Enterprise Configurator, 63–65
HTML, Financial Studio reports in, 306–307
Hyperion
Enterprise Performance Management, 272
Essbase. See Essbase cube
Financial Reporting Studio, 226
reporting products, 27
Hyperion Financial Management (HFM), 256, 264–265
I
identifying jurisdictions, 62
Identity & Access Management, fraud risk, 7
Identity Management Suite, application security, 164
IE (Internet Explorer), 279, 309
Implement phase, FSM, 38, 45–49
Implementation Consultants, 40
Implementation Project Manager, FSM, 39, 45–49
implementation project plan. See Functional Setup Manager (FSM)
Implementation Task List, 47
implementation users, creating, 340–344
importing
configuration packages, 54
creating configuration package, 52
setting up. See Export and Import Setup data
income tax jurisdiction, 62
instance sets, database security, 173
instances, CoA, 95–96, 108–109
Insurance CoA structure, 101, 105–108
integration
addressing technical pain points of, 8
in Fusion Accounting Hub, 24
as technical pain point, 5
interactive reports, 304–305
intercompany accounting
balancing, 152–157
Legal Entity Balancing Rule, 155–157
overview of, 150–152
processing options, 152–155
rules, 151
Intercompany segment, CoA, 22, 99, 152
Intercompany segment label, CoA, 94, 150
intercompany transactions
creating elimination entries, 251–255
scope of financial transformation for, 12
as technical pain point, 5
intercorporate transfers, eliminating entries for consolidated statements, 251–255
interfaces
APM user, 170–175
GL Journal Interface table, 195
internal auditors, 179–180
Internal Revenue Service, 76
Internet Explorer (IE), 279, 309
intracompany transactions, 251
invalid setup data, exporting/importing, 55
inventory, intercompany transactions, 253–254
IT support expenses
address by transitioning legacy systems, 7
as business process pain point, 3
J
JDeveloper, 9
job roles
duty roles mapped to, 162
within Fusion applications, 40–41
Fusion Applications security, 161–162
Internal auditor, 179–180
OTBI, 318–319
overview of, 167–168
role templates generating, 174–175
Job structure, Enterprise Configurator, 63–65
joiners, provisioning roles for, 175–177
journal approvals
assigning static approval group to Approval Group, 213–215
creating static approval group, 212–213
disabling default supervisor rule set for, 209–212
enabling for journal source, 209
enabling for ledger, 209
in journal processing cycle, 198
overview of, 206
requirements, 208
submitting Journal Batch for, 215–217
technical enablers for, 206–208
Journal Batch
creating BI Publisher report, 328–331
creating simple OTBI report, 321–324
journal processing cycle and, 198
overview of, 195–196
submitting for/verifying approval, 215–217
Journal data conversion level
Reporting Currency, 124
Secondary Ledger, 122–123
creating actual journal, 201–203
in General Ledger, 218
manually through Journal Entry Screen, 193–194
processing cycle, 198
structure of, 195–197
Journal Entry Rule Set, 25, 230–231, 244
Journal Interface table, 195
Journal Line Rule, 231–232, 244–245
journal source, configuring FAH, 236
journals
for budgets, 218
business requirements, 199–200
capture methods, 192–194
configuring accounting rules, 231
impact on ledger balances, 127–129
journal entry form, 201–203
journal entry structure, 195–198
overview of, 192
processing accounting events, 232
processing cycle, 198
statistical journals, 203–206
types of, 192
K
Key Performance Indicators (KPIs), 251
Key Success Indicators (KSI), 251
L
Label, Chart of Accounts Setup, 60
labels, CoA segment, 93–94
layout, Journal Batch listing, 328–329
LDGs (Legislative Data Groups), Enterprise Configurator, 64–65
leavers, provisioning roles for, 175–177
Ledger
accounting configuration, 142–144
assigning Balancing Segment Values to, 137–138
assigning Legal Entities to, 134–136
association with other components, 127–129
consolidation elimination entries for multiple, 255
consolidation elimination entries for single, 254
creating Enterprise Structure manually, 65–66
defined, 120
defining/assigning currencies to, 114
financial transformation goals for, 11–12
implementing Global Enterprise Structure Model, 71–73
journal approval for, 209
specifying Options, 132–134, 140
using Balance Transfer Consolidations, 259–260
using Report-Only Consolidation, 257–259
Ledger Balancing Option, intercompany accounting, 157
Ledger, example
add balancing segments to ledgers, 137–138
add balancing segments to Legal Entities, 137
assign Legal Entities, 134–136
complete Primary to Secondary Ledger mapping, 141–142
create Primary Ledgers, 131–132
create Secondary Ledger, 138–140
define Ledger options for Primary Ledger, 132–134
define Ledger options for Secondary Ledger, 140
high level steps to create, 129–130
opening first period, 144
review/submit accounting configuration, 142–144
ledger functional currency, 114, 115
Ledger, implementing
accounting configuration, 124
assigning legal entities/balancing segments, 125
concept of, 121–122
Primary Ledger, 121
Reporting Currency feature, 123–124
Secondary Ledger, 122
understanding big picture, 127–129
legacy systems, expensive IT support of, 7
Legal Address, Enterprise Structure, 61, 78–79
Legal Authorities, Enterprise Structure, 62, 76–77
Legal Entities
accounting configuration, 142–144
assigning Balancing Segment Values to, 125, 137
assigning to Ledger, 134–136
association with other components, 127–129
Business Units associated with, 125
configuration elements of, 61–62
created within Enterprise entity, 61
creating Enterprise Structure manually, 65–66
creating for Enterprise Structure, 79–81
implementing Enterprise Structure, 66–70
implementing Global Enterprise Structure Model, 71–73
implementing legal structure, 60
Legal Authority/Legal Jurisdictions and, 62
legal entity-level reports, 97
Legal Entity Registrations, Enterprise Structure, 81
Legal Jurisdictions, Enterprise Structure, 62, 74–76
Legal Payroll Units, Enterprise Structure, 62
Legal Registration, Enterprise Structure, 61
Legal Reporting Units, Enterprise Structure, 61, 81–83
legal structure, implementing, 60
Legislative Data Groups (LDGs), Enterprise Configurator, 64–65
license costs, journals, 199–206
line description, journals, 230–232
Line of Business (LOB)
accounting rules, 241–242
business requirements for users, 180
Enterprise Structure, 66–70
secure value set for, 188–190
tracking profitability, 7
lines, journal
configuring accounting rules, 231
for journal entries via Journal Entry form, 201–202
in journal processing cycle a, 198
overview of, 197
Load Configuration, Enterprise Configurator, 64–65
log in
creating application user, 340–342
creating Financial Studio report, 309
creating simple OTBI report, 321
FSM Setup and Maintenance work area, 34
Smart View, 333
M
Maintain stage, FSM process flow, 39
Manage Accounting Calendars task, 112–114
Manage Configuration Packages page, 49
Manage Cross-Validation Rules task, 115–116
Manage Currency Rates, 297
Manage Export And Import Processes page, FSM, 49, 53–54
Manage Journal Line Rules, 244
Manage Policies, 178–179
Manage Standard Accruals, 244–245
management consolidation, 251
Management segment, CoA, 22, 94
Management Structure, implementing, 60
Manual Intercompany Transaction Processing, 154–155
manual journals
business requirements for, 199–200
creating actual journals, 201–203
enabling journal approval, 209
manual processes
adjustment entries, 295
as business process pain point, 3
creating Enterprise Structure via, 64–66
Financial Accounting Hub, 7
mapping. See Chart of Accounts mapping
mapping set, accounting rules, 241–243
Mass Allocations, EBS, 272
members, multidimensional database, 274
Middleware components, enabling FAH and GL, 27–28
monitoring, with Account Monitor, 315–316
movers, provisioning roles for, 175–177
multidimensional cubes, as data sources in Fusion Financials, 305
multidimensional database (MDB), 272, 274–276
multidimensional OLAP, 27
multidimensional view of GL balances, 273–276
multiple jurisdictions, Enterprise Structure, 62
multiple ledgers, consolidation elimination entries for, 254
multiple segment CoA, structure of, 91–92
N
naming conventions, role templates, 187
natural account, CoA
associating numbers with, 89–91
defined, 22
Global CoA structure, 99
segment label, 94
navigation, Chart of Accounts mapping, 147–148
New Grid, Financial Reporting Studio, 310
New Report, Financial Reporting Studio, 310
OBIEE. See Oracle Business Intelligence Enterprise Edition (OBIEE)
objects, Fusion Applications security, 163
ODSM (Oracle Directory Services Manager), 164
OES (Oracle Entitlement Server), 165, 169–170
Offering, FSM
configuring implementation project, 42–45
Content Guide report, 37
creating implementation project, 49
as key concept, 34–36
OID (Oracle Internet Directory), Fusion Applications security, 164
OIM. See Oracle Identity Manager (OIM)
operational reports, 324
OPSS (Oracle Platform Security Services), Fusion Applications security, 166
Options, as FSM key concept, 35
Oracle
BIP. See BI Publisher reports
Essbase cube. See Essbase cube
Oracle BPM (Oracle Business Process Management), 207–208
Oracle Business Intelligence Enterprise Edition (OBIEE)
addressing lack of centralized reporting, 8
BI Publisher reports vs., 325
embedded in Fusion Applications as OBTI, 317–321
enabling reporting, 27
financial reporting with, 226
Oracle Business Process Execution Language (BPEL), 206–207
Oracle Business Process Management (Oracle BPM), 207–208
Oracle Directory Services Manager (ODSM), 164
Oracle Entitlement Server (OES), 165, 169–170
Oracle Fusion Applications Development and Extensibility Handbook (Oracle Press, 2014), 206–207
Oracle Fusion Applications Financials Implementation Guide, 275
Oracle Fusion Financials Cloud, 207, 302
Oracle Hyperion Planning Suite (Fusion Edition), 219
Oracle Identity Manager (OIM)
constructing user names, 169
creating application user, 340–344
creating users and related roles, 182, 184
Fusion Applications security, 164–165
Oracle Internet Directory (OID), Fusion Applications security, 164
Oracle Platform Security Services (OPSS), Fusion Applications security, 166
Oracle SOA Suite, journal approvals, 206–208
Oracle Transactional Business Intelligence (OTBI)
creating simple report, 321–324
enabling reporting, 27
Fusion financial reporting with, 226
other reporting tools vs., 306
overview of, 317–321
Organization Hierarchy, Enterprise Configurator, 64–65
organizational hierarchy, allocation across, 270–271
OTBI (Oracle Transactional Business Intelligence), 317–321
OUM (Oracle Unified Method) Cloud Application Services Implementation Approach, 33
ownership, in consolidation process, 250
P
pain points
defining goals, 9–10
financial transformation and, 9–10
listing business, 2–3
listing technical, 4–5
post-analysis decisions, 6
selecting financial system to address, 6–9
parameters, revaluation program, 298–299
parent company. See purchasing (or parent) company
partition transactions, Business Units in, 126
pass-through accounting, 227
passwords
accessing FSM Setup and Maintenance area, 34
creating application user, 342
creating users and related roles, 182, 185
PDFs, Financial Studio reports as, 306–307
period close
accounting cycle overview, 290–291
adjustment entries, 293–295
end of month validation checks, 8
foreign currency balances, 295–300
overview of, 290
putting it all together, 300–302
scope of financial transformation for, 12
as technical pain point, 5
trial balance and, 290–293
Period To Date Balances (PTD), intercompany transactions, 254
permissions, and security, 161, 162
Plan phase
FSM process flow, 36–38
implementation project, 42
Point of View (POV) values, 280–282, 334–335
policies
data security, 172–174
reporting on system audit, 179–180
secure value set for line of business, 189–190
system audit, 178–179
Position structure, Enterprise Configurator, 63–65
Post-Production Support, FSM process flow, 39
posting
actual journals, 202–203
Chart of Accounts mapping for, 147–150
implementing FAH, 228
journals, 198
statistical journals, 205–206
preview mode, Financial Studio report in, 313–314
Primary Balancing segment, CoA
business requirements for users, 180
CoA design decisions, 98
data access set created for, 183–185
defined, 22
label, 94
Primary Ledger
assigning Legal Entities to, 134–136
creating, 131–132
in intercompany accounting. See intercompany accounting
mapping to Secondary Ledger from, 141–142
overview of, 121
Reporting Currency Feature and, 123–124
Secondary Ledger always linked to, 122
specifying Ledger Options, 132–134
using Balance Transfer Consolidations, 259–260
using CoA mapping, 123
privileges
in APM, 165
authorization ensuring access through, 169–170
Fusion Applications security, 162
OTBI, 318–319
process categories
accounting rules, 230
FAH event model, 238–240
process flow
Functional Setup Manager, 36–39
journals, 198
production/Go Live phase, FSM process flow, 39
profitability, addressing, 3, 7
project initiation and scope
addressing business process pain points, 6–7
addressing technical pain points, 8–9
business process pain points, 2–3
goals, 11–13
overview of, 2
post-analysis decisions, 6
scope of financial transformation, 9–13
technical pain points, 4–5
project managers
creating application user, 340–344
Implementation Project Manager in FSM, 39, 41–42, 45–49
Provisioned column, configuring Offering, 44–45
provisioning, automatic role, 175–177
PTD (Period To Date Balances), intercompany transactions, 254
publishing Cost Center hierarchy, 281
purchasing (or parent) company
in consolidation process, 250
elimination entries, 251–255
using Balance Transfer Consolidation, 259–260
using Report-Only Consolidation, 257–259
R
Rapid Implementation project, 55–57
RBAC (Role Based Access Control), 161, 166–168
real-time integration capability, 4, 8
realized income (or losses), revaluations, 297
reconciliation
addressing, 8
period close tasks, 300
as technical pain point, 4
reference data sets, sharing across Business Units, 127
reference implementation, security, 170–171
Reference Objects, reference data sets as, 127
regions, Financial Studio report, 310
Related Business Objects report, FSM, 38
Related Enterprise Applications report, FSM, 38
relational database tables, as data sources in Financials, 305
relational OLTP, enabling General Ledger, 27
release level, exporting/importing set up data, 55
report documents, 304–305
Report-Only Consolidation
advantages and disadvantages, 261
applicable scenarios for, 257–258
defined, 255
implementation steps, 258–259
other consolidation methods vs., 256
overview of, 257
proposing as consolidation method, 264–265
report structure
calendars, 112–114
chart of accounts. See Chart of Accounts (CoA) structures, implementing
cross-validation rules, 115–117
currencies, 114–115
structure, 87
Reporting Currency Feature, 123–124
reporting tools, financial
Account Monitor, 315–317
BI Publisher. See BI Publisher reports
data sources in Fusion Financials, 305–306
Financial Reporting Studio. See Financial Reporting Studio
Oracle Transaction Business Intelligence, 317–324
Smart View, 332–336
types of, 304–305
reports
advantages of FSM, 32
Balance Transfer Consolidation, 260
creating Legal Reporting Unit for legal entities, 61
design considerations, 97
FAH implementation, 228
FFAH vs. Chart of Accounts and, 11
Financial Reporting Center, 306–307
Financial Reporting Studio. See Financial Reporting Studio
FSM process, Plan stage, 37–38
Oracle Fusion financial, 226
performing against GL Essbase cubes, 272–276
Report-Only Consolidation. See Report-Only Consolidation
scope of financial transformation for, 13
system audit policy, 179
technology enabling, 27
trial balance in period close, 292–294
types in Fusion Financials, 304–306
Reports and Analytics pane, 324
requirements
configuring journal approval, 208–209
FAH minimal data, 227–228
implementing consolidation, 262–264
implementing Enterprise Structure, 66–70
implementing Global Enterprise Structure Model, 70–73
resources, in APM, 165–166
revaluation journals, 194, 296–300
revaluations, foreign currency, 295–300
Revalue Balances job, 298–299
revenue account
debit and credit ledger entry rules, 19–21
defined, 18
use-case, 90
reversal journals, 194
Review Configuration, Enterprise Configurator, 64–65
Revisit Offerings Page, configuring Offerings, 45
Role Based Access Control (RBAC), 161, 166–168
roles
assigning application user, 343–344
automatic provisioning of, 175–177
creating application user, 340–344
creating users and related, 181–188
data. See data roles
hierarchies, 168
job. See job roles
registered in Oracle Internet Directory, 164
Role Based Access Control predefined, 161
roll-ups
design considerations, 99
in multidimensional data model, 275
rollup rule, CoA Mapping, 149
Rounding Account attribute field, ledger imbalances, 115
rule sets
assigning static approval group to Approval Group, 213–215
creating accounting method for, 244–246
creating static approval group, 212–213
disabling Supervisory Journal Approval, 209–212
submitting Journal Batch for approval, 215–217
rules
allocation, 279–285
intercompany balancing, 152–157
SaaS (software-as-a-service), FAH, 24
saving
BI Publisher report into custom folder, 330
Financial Reporting Studio report, 313–314
OTBI reports, 318
scenarios, defining budget, 220–221
Scheduled Processes menu, application user access to, 344
scheduling capabilities
BI Publisher, 326
OTBI, 322–323
scope. See project initiation and scope
scope of financial transformation
budgets, intercompany, and consolidation, 12
centralized audits, governance and security, 12
fast close of GL periods, 12
financial reporting and dashboards, 13
global Chart of Accounts, 11
ledger strategy, 11–12
overview of, 9–11
Secondary Balancing segment, CoA, 94, 98
Secondary Ledger
creating, 138–140
in intercompany accounting. See intercompany accounting
mapping from Primary Ledger to, 141–142
overview of, 122–123
Reporting Currency Feature for, 123–124
specifying Options, 140
using Balance Transfer Consolidations, 259–260
using CoA mapping, 123
securities, definition of, 91
security
BI Publisher report, 324
budget data, 221–222
OTBI, 317–319
transaction, using Business Units, 126
security, Fusion applications
APM user interface, 170–175
architecture components, 163–166
authentication, 169
authorization, 169–170
business requirements, 160
data security, 170
goal of centralizing, 12
implement business requirements, 180–190
joiners, movers, and leavers, 175–177
other ERP products vs., 161–163
overview of, 160
Role Based Access Control, 166–168
role hierarchy, 168
system auditing, 177–180
understanding, 161
Seeded Business Objects, FSM and importing/exporting, 55
Seeded Enterprise, creating Enterprise Structure manually, 65–66
seeded job roles, Fusion applications, 40–41
seeded subledger applications, importing journals, 195
segment rule, Chart of Accounts mapping, 148–149, 150
Segment Rules mapping, Balance Transfer Consolidation, 267
segments, CoA
assigning, 107–108
as building blocks, 93–95
CoA instances vs., 95–96
configuring accounting rules, 241–243
global CoA structure, 98–99
implement, 22–23
labels, 93–94
list of dimensions in GL cube, 275–276
multiple, 91–92
reporting hierarchies and roll-ups, 99–100
single-segment, 91
Select Objects for Export page, Create Configuration package, 52–53
Self Service page, OIM, 340–341
Self-Service Portal, FSM, 32
self-service provisioning, security, 161
Service Oriented Architecture (SOA), OIM integration with, 165
Setup and Maintenance link, creating application user, 340
Setup and Maintenance Work Area, FSM, 46, 53–54
Setup and Maintenance work area, FSM, 33–34, 39–41
setup data. See Export and Import Setup data
Setup Enterprise, 73–74
SFAS (Statement of Financial Accounting Standards) 52, foreign currency, 295
Shared Connections, Smart View reports, 333
short credits/debits, period close, 292
short selling, 91
single-segment CoA, 91
SLA (Subledger Accounting) application, 26, 129
slice and dice, multidimensional data model, 275
Smart View
as budget capture method, 219
building simple report, 333–336
other reporting tools vs., 306
overview of, 332
SOA (Service Oriented Architecture), OIM integration with, 165
software-as-a-service (SaaS), FAH, 24
Source Account filters, CoA mapping, 149–50
spreadsheet template, Rapid Implementation Configuration, 57
spreadsheets
creating budget data, 221
in manual journal entry, 194
SQL queries, BI Publisher scheduling, 326
SSC (Shared Service Center model), 129
stage data for accounting, FAH implementation, 228–229
Statement of Financial Accounting Standards (SFAS) 52, foreign currency, 295
static approval group, journal approvals, 212–213
statistical journals
business requirements, 200
creating, 203–206
overview of, 218
Status of Task, new implementation project, 48–49
Subledger Accounting (SLA) application, 26, 129
Subledger Applications, seeded, 195
Subledger data conversion level
Reporting Currency, 124
Secondary Ledger, 122
Subledger Journals, 129
subledgers
configuring accounting rules, 230
creating application for accounting rules, 237–238
creating FAH event model, 239–240
defining supporting references in FAH, 224
period close tasks, 300
using General Ledger vs., 17
subsidiaries
in consolidation process, 250
elimination entries, 251–255
using Balance Transfer Consolidation, 259–260
using Report-Only Consolidation, 257–259
Supervisory Journal Approval rule set, disabling, 209–212
supporting references
configuring accounting rules, 231
defining at subledger level with FAH, 224
as FAH feature, 25–26
surplus credits/debits, rectifying trial balance, 292
system administrator
creating user, 180
use of Setup and Maintenance area of FSM, 40
system auditing
configuring policies, 178–179
overview of, 177–178
reporting on system audit policies, 179–180
T
tasks
creating new implementation project, 47–48
exporting configuration package, 55
setting up intercompany accounting, 152
Task list, FSM
advantages of, 32
as key concept, 36
in Rapid Implementation project, 57
taxes, 74–77
Taxpayer Identification Number (TIN), 76, 80
technical events, FAH implementation, 228, 229, 232
technical pain points
address, 8–9
listing, 4–5
technology
enabling journal approvals, 206–208
FAH and GL, 26–28
templates, BI Publisher report, 327, 330
templates, role
creating, 186–187
creating users and related roles, 181–188
implementing database security, 172–174
overview of, 174–175
Third Balancing segment label, CoA, 94
TIN (Taxpayer Identification Number), 76, 80
toolsets, overlapping
addressing with JDeveloper, 9
as technical pain point, 5
Transact stage, FSM process flow, 39
transaction objects, 238–240
transaction tax jurisdiction, 62
transactional reporting
with BI Publisher. See BI Publisher reports
with OTBI, 317–321
transfer, FAH implementation, 228
transfer of services, elimination entries for intercompany accounting, 252
translations, foreign currency, 295
transparency, Fusion Applications security, 161
trial balance, 290–293
U
unit of measure (UOM), creating statistical, 203–206
Universal Resource Locator (URL), FSM Setup and Maintenance, 33
unrealized income (or losses), revaluations, 297
user interface, APM, 170–175
users
accessing FSM Setup and Maintenance, 34
creating implementation, 340–344
OTBI, 318–319
V
validation checks
cross-validation rules, 115–117
fast close of GL periods with, 8
Geography in Enterprise Structure, 85
posting actual journals, 202–203
posting statistical journals, 205
value sets
associating with CoA segments, 93–95
changing audit values, 179
creating, 102–105
creating security, 185–188
creating values for, 109–112
data inconsistency and, 8
defining budget scenarios, 220–221
implementing Chart of Accounts, 22–23
securing line of business, 188–190
vendor management system, 7
W
WebLogic Server, 27
Workspace, 308–309
X
XXFA_FAH_IMPLEMENTATION_ CONSULTANT, 340–344
XXFA_FIN_GL_IMPLEMENTATION_ CONSULTANT, 340–344
XXFA_IMPLEMENTATION_ MANAGER, 340–344
Y
Year To Date Balances (YTD), intercompany transactions, 254