Oracle Fusion Intercompany

 Oracle Fusion Intercompany

Oracle Fusion Intercompany provides predefined reports that are used in the close process and to verify setup of the accounting configuration.

1. Intercompany Account Details Report
2. Intercompany Transaction Summary Report
3. Intercompany Transaction Summary Report
4. Intercompany Reconciliation Period Summary Report
5. Intercompany Reconciliation Summary By Source Report
6. Intercompany Reconciliation Journal Lines Report

Oracle GL Reports

 Oracle GL Reports

Oracle Transactional Business Intelligence (OTBI) reporting tool provides embedded analytics and supports online inquiry for most transactions. The selections you make are dependent on the columns that were chosen during the report definition.

GL Reports

1. Account Analysis Report
2. General Journals Report
3. Trial Balance Report

Account Analysis Reports:

1. Account Analysis
2. General Ledger Account Details Report
3. Account Analysis for Contra Account Report
4. Average Balance Audit Account Analysis Report

Journal Reports:

1. Journals Report
2. General Journals Report
3. Journals Batch Summary Report
4. Journals Details Report
5. Journals Day Book Report
6. Reconciled Transactions Report
7. Unreconciled Transactions Report

Trial Balance Reports:

1. Trial Balance Report
2. Trial Balance - Average Balances

Reconciliation Reports:

1. Cash to General Ledger Reconciliation Report
2. Payables to Ledger Reconciliation Report
3. Receivables to Ledger Reconciliation Report

Chart of Account Reports:

1. Balancing Segment Value Assignments Report
2. Chart of Accounts Mapping Rules Report

Journal Approval Reports:

1. Approval Groups Report
2. Workflow Rules Report

SmartView:

Oracle Hyperion Smart View provides common Word, PowerPoint, and Excel interfaces designed specifically for Oracle Hyperion Enterprise Performance Management, Oracle Transactional Business Intelligence, and Oracle General Ledger.

1. Ad Hoc Analysis in Smart View
2. Define a Report in Smart View with the Query Designer

Financial Reporting Web Studio:

Use Financial Reporting Web Studio to design traditional financial report formats such as balance sheets, profit and loss statements, and cash flow reports.

• View an Account Group from the Financial Reporting Center

Drill Down to Balances

Account Monitor provides efficient monitoring and tracking of key account balances in real time and is continually updated, at every level of the dimension and hierarchy. It is a powerful tool for real time, multidimensional account analysis.

Navigate to the General Accounting Dashboard page. In the Account Monitor section, select View > Account Group > Create. Other Account Group options include: Manage to create, edit, or delete account groups.

Account Monitor and Account Inspector: Financial analysts monitor and track key account balances in real time at every level of your dimensions and hierarchies.

Use the Account Inspector to expand and drill down into an account balances. The default Account Inspector view includes the member values from the default account group selected in the Account Monitor.

The Account Inspector in Oracle Fusion General Ledger is a multi-dimensional analysis tool that allows users to create ad hoc pivot analysis, drill down from accounts to transactions, and view chart-based details. It also allows users to perform ad hoc balance queries, slice and dice information, and pivot within a page. 

To use the Account Inspector in the Inquire and Analyze Balances page, users can:

1. Change the period
2. Change the segment for which to inquire balances
3. Inquire on balances for a complete code combination instead of one segment at a time

To use the Account Inspector to expand and drill down into account balances, users can:

1. Click Navigator then Financial Reporting Center
2. Select an account in the Account Monitor
3. Click Inquire and Analyze Balances
4. Select All Cost Center Values, Your account, or Company: All Company Values
5. Select an Accounting Period
6. Click Refresh
7. Click Expand on the Cost Center
8. Review the balances

YoutTube Videos:

Account Inspector:

https://www.youtube.com/watch?v=bFKQWRKX1eY

Account Monitor

https://www.youtube.com/watch?v=KmWhQEkBqfc

Websites:

https://www.trinamix.com/oracle-financials-cloud-blog-series-reporting-in-fusion-financials-cloud-part-1/

https://www.trinamix.com/oracle-financials-cloud-blog-series-reporting-in-fusion-financials-cloud-part-2/

https://apps2fusion.com/old/item-3/67-oracle-fusion/fusion-applications/fusion-financials/795-financial-reporting-studio-account-monitor-and-account-inspector

https://www.trinamix.com/oracle-fusion-report-automation-using-python/

https://www.trinamix.com/splitting-large-volume-bip-report-output-into-multiple-output-files/

Inter Company / Intra Company

 Inter Company / Intra Company

Account Inspector/Account inquiry

 Account Inspector/Account inquiry

Cross Validation Rules (CVR)

 Cross Validation Rules (CVR)

Security Rules

 Security Rules

Secondary Ledger

 Secondary Ledger

Setups:

1. Manage secondary ledger
2. Specify ledger options
3. Complete primary to secondary ledger mapping
4. Run review and Submit accounting configuration
5. Assign data access to secondary ledger
6. Open secondary ledger period
   If you want to do a few more steps or else ignore this
7. Manage ledger set
8. Assign data access
9. Enter Journal and post in primary ledger
10. Enter adjustment category journal in secondary ledger
11. Run trial balance report

Auto Post

 Auto Post

1. Manage auto post criteria sets
2. Create multiple journals for testing
3. Run auto post

Revaluation

 Revaluation

1. General Ledger
2. Fixed Assets

Steps:

1. Manage unrealized gain loss account
2. Enable foreign currency code
3. Manage exchange rate for today and month end
4. Manage revaluation template
5. Submit revaluation
6. Book FX Journal on credit

Reporting currencies/ledger

 Reporting currencies/ledger

Conversion Rules:

1. Balance
2. Journal
3. Sub ledger

Steps:

1. Manage Reporting Currencies
2. Assign Reporting Currency ledger to data access
3. Open Periods for reporting currencies ledger
4. Manage exchange rate for conversion
5. Enter and post journal in primary ledger
6. Verify results in Primary & Reporting Ledger

Journal Source

 Journal Source

1. Freeze Journals
2. Import Journal References
3. Require Journal Approval
4. Import Using Key
5. Accounting Date Rule

Mixed Currency Journals

 Mixed Currency Journals

Auto Copy Journals

 Auto Copy Journals

Foreign Currency Journals

 Foreign Currency Journals

1. Manage Exchange (Conversion) Rate Type (Optional)
   Corporate, Spot/Market, User
2. Manage Exchange (Daily) Rates
3. Enter FX Journal and Post

Reversal Journals

 Reversal Journals

Types of reversal methods

1. Switch Dr/Cr
2. Change Sign

Journals

 Journals

Methods of Journals:

1. Manual Method
   Single, Batch
2. Automatic

Multiple ways to enter journals:

1. Manual
2. FBDI: When data is more than 500 Mb
3. ADFDI:  When data is less than 500 Mb
4. Automatic Journals (Mass Allocation and Revaluation)

Implementation

 Implementation

• Understood Client business process
• Mapped the Business Processes with Oracle Fusion application standard functionality
• Conducted prototype sessions (CRP) to business to get requirement sign-off
• Handled UAT sessions and prepared OUM documents i.e. RD030, RD011, AN100, TE050, TE020, DO070 etc.
• Configured System for all financial application in the environment of Functional Setup manager(FSM)
• Defined Approval Rules through BPM
• Worked on Setting up job role, duty role and abstract roles as per business requirement
• Completed testing for all financial applications (Unit & Integrated)
• Created users by giving role provisioning in OIM (Oracle Identity Management)
• Worked on FR Studio Reporting, Smart View, Account Inspector and Account Monitor, OTBI Reporting
• Enable Business Unit Functions
• Configured Common Options for Payables and Procurement
• Loaded Master and Transactional data using Rapid Implementation and FBDI Templates
• Worked towards the proof of concept and involved in defining the organization structure
• Worked on item conversions and prepared conversion documents (CV10,CV40)
• Handled conversions stages for Inventory and Purchasing modules.
• Master Data Cleanup - Suppliers, Customers, Trading Community, Supplier Merge etc.
• Worked on various interfaces, conversions where QBE integrates its Financial data to and from various third party source
• Designed workflows as per the business need in iExpenses, iProcurement, Purchasing, Payables and General Ledger
• Prepared Functional Design Documents FDD's based on the requirements gathered

Oracle Fusion Cloud Interview Questions

 Oracle Fusion Cloud Interview Questions

https://hkrtrainings.com/oracle-fusion-financials-interview-questions

Mass Allocation

 Mass Allocation

In Oracle Cloud, mass allocation refers to the process of distributing costs or revenues across multiple entities, departments, projects, or accounts based on predefined allocation rules. This feature allows organizations to allocate shared costs or revenues accurately and efficiently, facilitating better financial reporting and analysis.

Here's a general overview of how mass allocation works in Oracle Cloud:

1. Define Allocation Rules: Users first define allocation rules that specify how costs or revenues should be distributed. These rules typically include criteria such as percentages, amounts, or formulas based on which the allocation is calculated. For example, a rule might allocate overhead costs based on headcount, square footage, or revenue.

2. Setup Allocation Journals: Once the allocation rules are defined, users can create allocation journals to apply these rules to specific transactions or financial data. These journals specify the source accounts or transactions to be allocated and the target accounts or entities to which the costs or revenues will be distributed.

3. Run Allocation Process: Users then run the allocation process, which applies the defined allocation rules to the source transactions or data and generates allocation entries in the system. The allocation process calculates the allocation amounts based on the rules and updates the appropriate accounts or entities accordingly.

4. Review and Adjust Allocations: After the allocation process is completed, users can review the allocated amounts and make any necessary adjustments or corrections. They can analyze the allocation results to ensure accuracy and make changes as needed to reflect changes in business requirements or circumstances.

5. Reporting and Analysis: Once allocations are completed, organizations can use the allocated financial data for reporting, analysis, and decision-making purposes. Allocated data provides a more accurate representation of costs and revenues across various departments, projects, or entities, enabling better insight into financial performance and resource utilization.

Overall, Oracle Cloud's mass allocation functionality helps organizations allocate costs and revenues accurately and efficiently, enabling better financial management and reporting capabilities.

Setups:

1. Enter cost pool account journal
2. Enter and post stat journal
3. Define allocation variables
4. Define allocation rules
5. Validate and deploy rules
6. Generate allocation
7. Review allocation journals

https://www.technofunc.com/index.php/functional-skills/general-ledger/item/allocations

https://www.youtube.com/watch?v=LHXK1HR4hDI

https://www.youtube.com/watch?v=Qd-RRGT7skw

https://www.youtube.com/watch?v=er9exxe4spM

https://apps2fusion.com/old/item-3/67-oracle-fusion/fusion-applications/fusion-financials/826-mass-allocation-manager-in-fusion-financials

https://www.jadeglobal.com/blog/allocations-and-eliminations-oracle-fusion-cloud

https://www.oatug.org/events/event-description?CalendarEventKey=56459e63-c4bb-40b5-bcd7-018dae48daf6&Home=%2Fattend%2Fevents

https://apps2fusion.com/old/item-3/67-oracle-fusion/fusion-applications/fusion-financials/774-mass-allocations-and-statistical-journals

https://ora-fusion-apps.custhelp.com/euf/assets/fusion/videos/replays/217644_Using_Allocations_GL/111815_217644_source/presentation_html5.html?lms=1

https://cloudshinepro.com/oracle-erp-cloud-fusion-vs-oracle-ebs-comparison-summary/

Rapid Implementation

 Rapid Implementation

Oracle Rapid Implementation refers to a streamlined approach for deploying Oracle's enterprise software solutions quickly and efficiently. It's a methodology designed to accelerate the implementation process, reduce costs, and minimize risks associated with deploying complex software systems.

Key aspects of Oracle Rapid Implementation typically include:

1. Preconfigured Solutions: Oracle offers preconfigured templates and best practices based on industry standards and years of experience. These templates are designed to fit common business processes, allowing for faster deployment.

2. Accelerators and Tools: Rapid Implementation methodologies often include specialized tools, accelerators, and utilities to automate repetitive tasks, data migration, and configuration processes. These tools help to expedite the implementation process.

3. Standardization: The approach emphasizes standardization of processes and configurations wherever possible to reduce customization efforts. This not only speeds up implementation but also simplifies ongoing maintenance and support.

4. Phased Approach: Rather than attempting a big bang implementation, Oracle Rapid Implementation typically follows a phased approach. This involves breaking down the implementation into manageable modules or phases, allowing for iterative development and quicker realization of benefits.

5. Training and Change Management: Training and change management are integral parts of Oracle Rapid Implementation. Adequate training ensures that end-users are proficient in using the new system, while change management processes help to manage resistance and ensure smooth adoption.

6. Post-Implementation Support: Rapid Implementation methodologies include provisions for post-implementation support to address any issues that may arise after the system goes live. This ensures that the system continues to operate smoothly and meets the organization's evolving needs.

An "Oracle Rapid Implementation spreadsheet" could refer to various documents or templates used during the implementation process of Oracle software solutions. Here are a few possibilities:

1. Implementation Plan Spreadsheet: This spreadsheet outlines the project plan for implementing Oracle software, including key milestones, tasks, responsible parties, and timelines. It helps project managers and stakeholders track progress and ensure that the implementation stays on schedule.

2. Configuration Spreadsheet: During the implementation, configurations are often documented in spreadsheets for easier management and reference. These spreadsheets may include details such as module configurations, customizations, data mappings, and integration points.

3. Data Migration Spreadsheet: Data migration is a crucial aspect of any software implementation. A data migration spreadsheet may contain information about the source data, mapping rules, cleansing and transformation steps, and validation checks to ensure data integrity after migration.

4. Testing Matrix Spreadsheet: Testing is essential to validate that the Oracle solution meets business requirements and functions correctly. A testing matrix spreadsheet lists test scenarios, test cases, expected results, actual results, and any defects identified during testing.

5. Training Plan Spreadsheet: Training is critical to ensure that end-users can effectively use the Oracle software. A training plan spreadsheet may outline the training curriculum, schedule, trainers, training materials, and participant attendance to track training progress.

These are just a few examples, and the specific contents of an "Oracle Rapid Implementation spreadsheet" can vary depending on the organization's needs, the scope of the implementation, and the Oracle software being deployed. The spreadsheets serve as tools to facilitate different aspects of the implementation process and help ensure its success.

Overall, Oracle Rapid Implementation aims to deliver a faster time-to-value for organizations adopting Oracle's software solutions, enabling them to achieve their business objectives more quickly and efficiently.

1. Companies (legal entities)
2. Ledgers by country
3. Business Units
4. Chart of Accounts and Segment Values
5. Segment Value Hierarchies
6. Financials sequences
7. Required sub ledger accounts

1. Chart of accounts structure and instance
2. Segment Value Hierarchies
3. Key accounts such as retained earnings
4. Required sub ledger accounts
5. Accounting Calendar
6. Primary ledger for each country represented on the legal entities sheet
7. Legal entities and their locations
   
8. Business Units
9. Document and journal sequencing
10. Set of Financial Reporting reports
11. Three account groups

YouTube Videos:

https://www.youtube.com/watch?v=jLXuZPjU4cY

https://www.youtube.com/watch?v=gy3Fci5HWGc

https://www.youtube.com/watch?v=NXl-8vqAujM

Websites:

https://www.jadeglobal.com/blog/oracle-financials-rapid-implementation

https://medium.com/@laxman.orafin/rapid-implementation-in-fusion-47659fb1d5e3

Recurring Journals

 Recurring Journals

Oracle EPM Cloud

Oracle Fusion Cloud Enterprise Performance Management

EPM Platform

Oracle Cloud Enterprise Performance Management (EPM) Platform is a framework of the technical and functional components shared among Cloud EPM processes. 

It enables you to have a more unified user experience and simplified administration across different business functions.

Planning

Profitability and Cost Management

Financial Consolidation and Close

Account Reconciliation

Tax Reporting

Narrative Reporting

Freeform

Enterprise Data Management

Oracle-epm-cloud-and-it-uses

https://conneqtiongroup.com/blog/oracle-epm-cloud-and-it-uses

Oracle EPM Customers:

1.MTN

https://www.oracle.com/middleeast/customers/mtn-group/

https://www.youtube.com/watch?v=RbORFC47RhE

Intercompany Allocations

 Intercompany Allocations

https://docs.oracle.com/en/cloud/saas/financials/24a/faiac/overview-of-intercompany-allocations.html

Oracle Cloud Security

 Cloud Security Consultant

Required skills

• 3 to 8 years of experience delivering full cycle of Oracle Cloud Security assessments, design, and

implementations as well as understanding of leading practices relates to ERP security

• Demonstrate an understanding of business processes flows, cloud security risk, Oracle application security and risk management
• Understanding of common compliance frameworks such as SOX, GDPR, HIPAA etc.
• Experience in Oracle cloud security console, like building custom roles by tailoring Oracle seeded roles as per the business requirement and User administration activities like add/modify user accounts, add/remove roles, assign data security context and assign profiles etc.
• Experience in building Data roles, creating custom security profiles, area of responsibility (AOR) assignments, performing HDL loads, restricting payroll flows and document types
• Identifying key risks and controls, knowledge of Sarbanes Oxley readiness, controls optimization, as well as configuration of controls around security, business process and within the Oracle Cloud Risk Management Cloud (RMC) modules
• Experience in implementing role-based security (ERP, EPM, OTBI), Oracle Cloud Quarterly patch analysis and regression testing, supporting Software Development Life Cycle (SDLC) including configuration in lower environments, migration, and QA, reviewing, audit end user accounts, permissions, and access rights, performing segregation of duties (SOD) and mitigating risks.
• Experience in securing Oracle Business Intelligence (BI) reports/data models/subject areas/analysis.
• Experience in coordinating with development teams, functional teams, business leads, information security & risk management teams.
• Excellent written and verbal communication skills
• Good project management and organizational skills

Preferred skills

• Experience in Oracle GRC or Oracle Risk Management Cloud (RMC) design, implementation or assessment experience including Advanced Access Controls (AAC), Advanced Financial Controls (AFC) and Financial Reporting Compliance (FRC)
• Experience in Oracle Cloud ERP/HCM modules
• Previous Consulting or Big 4 experience preferred
• Security Certifications such as: CISSP, CISM, CISA is a plus
• Automation using Python, C# or VBA
• Troubleshooting and analytical skills using PL-SQL queries

Fusion Intercompany Business Processes

 Fusion Intercompany Business Processes

• Intercompany Transaction Processing
• Intercompany Reconciliation

Youtube Videos:

https://www.youtube.com/watch?v=b5hWyrEuMAs&list=PL7CWBDRZZ_QempsDGnN2w5O3m2w9M_ifJ

https://www.youtube.com/watch?v=FnNbFyBMbmk

https://www.youtube.com/watch?v=wrX73ZCL5BM

https://www.youtube.com/watch?v=yrQsSj1vhlA

https://www.youtube.com/watch?v=tNuKKgIj6EM

https://www.youtube.com/watch?v=i6a_Mm9UjsM

https://www.youtube.com/playlist?list=PLFXZ601NyMCdMQlDPIOlSRdRUlsCB0J_V

Fusion Intercompany Setup

 Fusion Intercompany Setup

• Manage Ledger Options
• Manage Intercompany System Options
• Manage Intercompany Transaction Types
• Manage Intercompany Period Status
• Manage Intercompany Organizations
• Manage Intercompany Customer and Supplier Assignments
• Manage Intercompany Receivable Assignments
• Manage Intercompany Balancing Rules

https://aytanvahidova.medium.com/intercompany-accounting-setup-in-oracle-fusion-part-i-3ef3f9197be

https://www.youtube.com/watch?v=1JGQ17XXxEU

OBCEA-Business Processes

 OBCEA-Business Processes

• Creating Control Budgets
• Budget Data Load
• Manual AP Invoice Creation
• Manual Encumbrance Journal

https://www.youtube.com/@A_Step_by_Step2023/videos

Budgetary Controls & Encumbrance Accounting (BCEA)

 BCEA Setup

• Manage Budgetary Controls  & Encumbrance Accounting
• Manage Budget Calendar
• Encumbrance Types
• Encumbrance Carry Forward Rules

General Ledger Business Processes

 Business Processes

• Open First Period
• Creation of Manual Journal
• Importing Journals from SLA
• Creation of Journal from External System (OER)
• Creation of Journal from Spread Sheet (ADFDI)
• Creation of Recurring Journals
• Creation of Statistical Journals
• Creation of Cross Currency Journals
• Revaluation
• Translation
• Transferring Balances to Secondary Ledgers
• Allocation Defintion
• Allocation Submission
• Consolidation Balance Transfer
• Reversal of Journal
• Auto reversal of Journals
• Closing of GL Period

Common Configurations

Common Configurations

• Manage Value Sets
• Define Chart of Accounts Structures
• Define Structure Instances
• Maintain Segment Values
• Manage and Publish Account Hierarchies
• Manage Cross-Validation Rules
• Manage Chart of Accounts Mappings
• Define Calendars
• Manage Currencies
• Define Ledgers
• Assign Legal Entities
• Specify Ledger Options
• Manage Reporting Currencies
• Manage Secondary Ledgers
• Specify Ledger Options
• Complete Primary to Secondary Ledger Mapping

https://www.youtube.com/watch?v=Q8VF2BJzHZA

Oracle Business Flows

 Oracle Business Flows

Oracle Accounting Hub Cloud

 Oracle Accounting Hub Cloud

Oracle Accounting Hub Cloud is a comprehensive cloud-based solution provided by Oracle for managing accounting processes within an organization. It offers a centralized platform to streamline financial operations, ensure compliance, and provide real-time visibility into financial data.

Key features of Oracle Accounting Hub Cloud include:

1. Integration Capabilities: It integrates seamlessly with various source systems, such as ERPs (Enterprise Resource Planning), CRMs (Customer Relationship Management), and other financial applications, allowing for the consolidation of financial data from disparate sources.

2. Standardization: The platform enables standardization of accounting policies and processes across the organization, ensuring consistency and accuracy in financial reporting.

3. Automation: Automation features help in reducing manual effort and improving efficiency by automating routine accounting tasks, such as journal entries, intercompany reconciliations, and financial close processes.

4. Compliance: Oracle Accounting Hub Cloud helps organizations adhere to regulatory requirements and accounting standards by providing tools for compliance management and audit trails.

5. Real-Time Reporting: It offers real-time insights and reporting capabilities, enabling stakeholders to make informed decisions based on up-to-date financial data.

6. Scalability: The cloud-based nature of the solution ensures scalability, allowing organizations to adapt to changing business needs and handle increasing volumes of financial transactions.

Overall, Oracle Accounting Hub Cloud empowers organizations to streamline their accounting processes, enhance visibility into financial performance, and drive operational efficiency.

Websites

https://paascommunity.com/2022/06/09/automating-accounting-hub-cloud-integration-with-oracle-integration-by-kishore-katta/

https://blogs.oracle.com/integration/post/maximizing-efficiency-how-to-automate-accounting-hub-cloud-integration-with-oracle-integration