Display QR Code in Cloud ERP BI Publisher Report

It is very easy to display QR code in a Fusion BI Publisher report. To achieve that you need to add the below tag in the RTF template of your BIP report

<?qrcode: <DATA>; <SIZE>[; <CHARSET>]?>

for example: <?qrcode: ITEM_NUMBER; 100?>

adding qrcode tag in the RTF template

Sample Query: select item_number,description from egp_system_items_vl

BIP Data model
Report output with QR Code

For more information please refer
https://docs.oracle.com/en/cloud/paas/analytics-cloud/acpmr/2d-barcode-functions.html#GUID-E0D697B1-0B13-46A3-8578-1FE933F1A86D
and
Fusion Application – BI Publisher – How to implement QR Code (Doc ID 2382839.1)

Oracle Fusion Financials/Cloud ERP Financials Interview Questions

I believe browsing through common Interview questions will help learn more about Fusion Apps. Listed below are couple of questions.

Generic Questions:

  • Have you worked on any Cloud implementation/Support project?
    if yes please explain about the project
  • How many modules were implemented?
  • Which version?
  • Explain your role
  • Elaborate on Phases and Duration of the project
  • Elaborate on the documentation
  • How big was the team and what was the team composition
  • Were you involved in data migration, reporting, configuration, testing, integration, management, security, requirements gathering, design, documentation, user training, post go live support, upgrades, interacting with Oracle support etc.

Architecture related:

  • Explain architecture of Cloud ERP
  • Elaborate on Product Family, Offerings, Features, Options
  • Explain FSM, Implementation Project, Task List, Tasks
  • Explain Rapid Implementation
  • Explain configuration migration from one instance to another

Security related:

  • Explain the security model in Oracle Fusion Apps/Cloud ERP
  • How many types of Roles have you worked on?
  • Explain Function security and Data Security
  • Why do we need Custom Roles?
  • Have you created any? and Explain the Custom Role creation process
  • How do you create users?
  • How do you assign roles to Users?
  • How do give access to Data in GL/AP/HCM?
  • Have you used Data Roles?
  • What are Privileges?
  • What is Auto Provisioning?
  • Explain how do you achieve giving access to invoice creation but
  • restrict invoice payment access
  • Explain BIP related security/roles
  • How different it is from R12/11i
  • What are the default users created by Oracle?
  • is SYSADMIN user available in Fusion?

General Ledger module related:

  • Have you configured GL module?
  • Explain GL module configuration
  • How different it is from R12/11i
  • Is there Business Group setup in Fusion?
  • Elaborate Enterprise Structure in Fusion
  • Explain Accounting structure instance
  • Explain segment labels, segment attributes (third party control account)
  • How many balancing segments can you define in Fusion
  • Explain BSV
  • Explain ledgers and creation process
  • What are Essbase cubes?
  • Name the seeded GL Job Roles
  • How do you grant access to a ledger to a user?
  • Explain segment level security rules
  • Explain Cross Validation Rules (filter, condition)
  • Explain Hierarchies (audit, row flattening)
  • What is use of maintaining versions of hierarchies?
  • Explain the need for having multiple hierarchies
  • Explain hierarchy publishing (when we should not publish? multiple child assignments)
  • Elaborate Accounting calendar. explain start date and translation process relation
  • Explain period frequency, adjusting period concept
  • Explain calendar period and fiscal period
  • Explain Currency related processes (conversion, revalvation, translation)
  • Explain STAT
  • Explain rate type (spot, corporate, user)
  • Explain Cross country rate rules
  • Explain Secondary ledgers, Reporting currency ledger, conversion levels
  • Explain ledger set
  • Balance cube dimensions (period, ledger, COA segments, scenario, balance amt, amt type, currency, currency type)
  • Close status monitor
  • Allocations – calculation manager
  • Consolidation methods – Reporting, balance transfer, financial management con – hyp, eliminations
  • Budgeting
  • Data migration
  • Journal entry (entry page, spreadsheet, fbdi, webservice)
  • Financial Reporting Center
  • Account Monitor, inspector
  • Smart view
  • OTBI
  • BIP

Hope it helps! Please don’t forget to leave your comments. Thanks

Learning Path

The learning path differs based on interest, past experience and education.

We recommend the below learning path irrespective of the category.

  • Start using the product, understand the Navigation, Enter some transactions, Run a Report
  • Understand Security, learn about Roles, Create User, Security Console etc
  • Learn about the Architecture of Cloud ERP, various product families, offerings etc
  • Understand Configurations, Learn how to configure an offering like Financials. Learn to use FSM – Functional Setup Manager
  • Test the configuration
  • Learn about configuration migration etc

Apart from the above two main areas which we recommend everyone are:

  • Acquire DOMAIN knowledge
    • Example, Accounting, Financials Business Processes etc
  • Learn about Implementation Aspects
    • Project Management
    • Phases
    • Documentation
    • Testing – unit testing, SIT, UAT etc
    • Cutover etc

Start Learning Today!

The below recording helps you to understand the basic navigation in Oracle Fusion Applications.

Did you like the recording? Please leave a comment by clicking on leave a comment link on the top of this post.

More to come!

Keep hooked..

Now let us understand the various categories of people wanting to learn Cloud ERP

Broad classification based on Experience:

  • Oracle EBS Functional Consultants
  • Oracle EBS Technical Consultants
  • Oracle EBS Techno-Functional Consultants
  • Other ERP experience (Peoplesoft, JDE, SAP, Tally, Maximo etc)
  • No experience on any ERP

Broad classification based on Education:

  • Commerce graduates
  • Engineering graduates
  • MBA

Broad classification based on Interests:

  • Those looking for a new Job
  • Job Change
  • Project Change
  • Upgrade

Welcome to the Oracle Cloud ERP World !

Oracle Cloud ERP has become very popular. As a result, many companies are moving to Cloud ERP. So creating many job openings. But, right resources are not available in the market.

So to address the shortage of Cloud ERP resources, this website has been created.

Move2Fusion is a collaborative platform and is an honest attempt to address and close this gap.

Oracle Cloud ERP SMEs have started this Move2Fusion collaborative platform. That is to say, they like to spread the knowledge through sharing their experience