🔹 Join the OracleApps88 Telegram Group - Stay up to date with the latest on Oracle EBS R12 and Oracle Cloud/Fusion Applications. 📌 Telegram Group : https://t.me/OracleApps88

💡 Facing issues copying code/scripts or viewing posts? We're here to help!
📬 Contact on Telegram : https://t.me/apps88
📱 Telegram/WhatsApp: +91 905 957 4321
📧 Email Support: OracleApp88@Yahoo.com

Thursday, August 29, 2019

Fusion Security - Creating an Employee/User with Manual, HDL and Security Configuration Process

Security Configuration Overview
Data security makes data available to users by the following means.
Policies that define grants available through provisioned roles
Policies defined in application code

You secure data by provisioning roles that provide the necessary access.
Data roles also can be generated based on HCM security profiles. Data roles and HCM security profiles enable defining the instance sets specified in data security policies.

When you provision a job role to a user, the job role limits data access based on the data security policies of the inherited duty roles. When you provision a data role to a user, the data role limits the data access of the inherited job role to a dimension of data.

Data security consists of privileges conditionally granted to a role and used to control access to the data. A privilege is a single, real world action on a single business object. A data security policy is a grant of a set of privileges to a principal on an object or attribute group for a given condition. A grant authorizes a role, the grantee, to actions on a set of database resources. A database resource is an object, object instance, or object instance set. An entitlement is one or more allowable actions applied to a set of database resources.


Security Configuration Tasks
  01: Creating an Employee/User
  02: Adding Roles to User and Resetting the Password
  03: Create the Employee/User with HDL template
  04: Adding the Roles to User with HDL template
  05: Create Custom Role with View Privileges and add the role to User
  06: Verify the User in Manager Users
  07: Add Business Unit Data Access to User
  08: Setup Vacation Rule for a User
  09: Setup Printer in Cloud Application
  10: Run User and Roles Synchronization Process.         
  11: Setup the Manage Procurement Agent
  12: Creating a Descriptive Flexfields and testing


1: Creating an Employee/User
Creating an employee from HCM’s Hire an Employee page.

1. Navigate to My Workforce/My Client Groups àNew Person.
















Please click on the below link for more details:

Fusion Security - Creating an Employee/User with Manual, HDL and Security Configuration Process

Please Like and Share our FaceBook page to get more details on Oracle Applications

Tuesday, August 27, 2019

Oracle Fusion/Cloud Applications Free Online Demo Instance

Below are the Oracle Fusion/Cloud demo application credentials, valid for a limited period.

Note: Please do not change the password


Oracle Fusion/Cloud Applications Online DEMO instance
URL: https://eqjz.ds-fa.oraclepdemos.com/
Username: OracleApps88
Password : OracleApps88


Oracle EBS R12 Applications Online DEMO instance
Username: ORACLEAPPS88
Password : oracleapps88

Join the WhatsApp group: https://chat.whatsapp.com/J4BrTyWyP6XBps1uLVLurV to get the Oracle EBS R12/Cloud/OIC DEMO Applications details

































 ðŸ”¹ Join the OracleApps88 Telegram Group - Stay up to date with the latest on Oracle EBS R12 and Oracle Fusion Applications. 📌 Telegram Group: https://t.me/OracleApps88

💡 Facing issues copying code/scripts or viewing posts? We're here to help!
📬 Contact on Telegram: https://t.me/Apps88
📱 Telegram/WhatsApp: +91 905 957 4321
📧 Email Support: OracleApp88@Yahoo.com



Monday, August 26, 2019

Fusion OTBI - Oracle Fusion Transactional Business Intelligence Reports Training Manual


With Oracle Fusion Transactional Business Intelligence embedded analytics, role-based dashboards, and on-the- fly ad hoc reporting capabilities make data access and interpretation easier than ever before. Users are able to see updates in real-time, and their impact, through embedded analytics. For example, during the compensation budgeting process, a manager is able to see a running tally for reference right on the page. This eliminates the guesswork with dashboards that deliver in-line information while you do your work. Pre-delivered operational reports are enriched with robust and flexible ad hoc query capabilities that access real-time transactional data – no need to push data to a separate warehouse or engage the IT department for a custom report: it is easy, and right at your fingertips

Business Intelligence Composer
The Business Intelligence Composer is a simple-to-use wizard that allows organizations to quickly and easily create, edit, or view data without requiring an engineering background. With this capability Human Resource organizations can build and deliver reports that the business needs whenever they need it, without waiting for IT support. It is built for the business user.

Real Time Ad Hoc Query
Traditional ad-hoc reporting solutions require a person to have deep domain in their subject area and an understanding of data objects in the relevant tables they needed to report from.
OTBI hides that complexity and transforms the 9000+ reportable data objects into everyday business terminology. Which means if you are looking to see a worker’s average performance rating you will find the reporting object named as “Worker’s Average Performance Rating”.
This is all done by using the standard Oracle query and reporting tool (OBIEE). OBIEE has end user tools (Answers, Dashboards) to provide an easy-to-use interface for business users to perform current state analysis of their business applications. Constructed queries and reports are executed real time against the transactional schema supported by a layer of view objects.

In OTBI, business users can also easily drill on predefined hierarchies, enable action links, compose a dashboard, schedule a report or dashboard for delivery and export data or reports to a variety of file formats. Fusion users can also easily embed an OTBI report or dashboard in a Fusion page through Personalization

Integrated with Fusion Applications
OTBI is fully integrated with Fusion applications (roles, flex fields, lookups, trees). There is no need for additional implementation steps to map security or provide configuration inputs. OTBI needs minimum setup and is ready for use once Fusion Applications are configured and installed.


We are going to develop the Below OTBI reports
1. Navigating to and Viewing a Standard Report
2. Creating Custom Report with Wizard Template
3. Creating Custom Report with Custom Template
4. Creating Analysis Reports for Suppliers
5. Creating Ad Hoc Reports for Expenses


1. Navigating to and Viewing a Standard Report
Select Reports and Analytics under Tools in the Navigator.






































Please click on the below link for more details:

Fusion OTBI - Oracle Fusion Transactional Business Intelligence Reports Training Manual


Please Like and Share our FaceBook page to get more details on Oracle Applications

Saturday, August 24, 2019

Fusion Expenses – Oracle Fusion Expenses Training Manual

Oracle Fusion Expenses is a complete, end-to-end solution for digital expense management giving employees easy data entry options, and financial managers detailed spend information and policy-driven control.
Online and mobile, along with spreadsheet entry options, automate travel entry and approvals, reducing administrative headaches while capturing essential data for effective cost management.

STREAMLINE EXPENSE PROCESSING AND REDUCE COSTS
Oracle Expenses Cloud provides your organization with the tools to effectively manage the travel and expense process. With flexible payment options, versatile data entry methods, and personalizable user preferences, Oracle Expenses Cloud lets you enter, submit, approve, audit, and pay expense reports quickly while enforcing transparent, tight controls throughout your expense management process.

The Travel and Expenses work area provides a clear overview of the status of your expense items, reports, cash advances, trips, and items that require action. This information is summarized into infotiles that deliver clear, accurate and actionable information when you need it. Items requiring your action are highlighted in red, guiding you to take immediate action and make effective decisions.

SIMPLIFY EXPENSE REPORTING AND INCREASE COMPLIANCE
Oracle Expenses Cloud offers extensive functionality to increase workforce productivity and satisfaction. For example, employees can quickly and easily enter and submit expense reports for corporate card transactions along with cash expenses. Pre-populating reports with card transactions makes expense entry faster, increases data accuracy and reduces opportunities for fraud.

Users expect their corporate systems to reflect the prevalence of digital technology in their personal lives. To accommodate the increasing use of mobile devices, Oracle offers expense capture, submission and approval on the go. Fusion Mobile Expenses is a comprehensive solution supporting mobile entry for both iPhone and Android devices, leveraging common smartphone features such as photo capture for automated expense entry of receipts, voice capture to record expenses, GPS route tracking to calculate mileage, and multi-currency and location-based support using GPS location. Other innovative features use your contacts and calendar to select attendees for meals or other expenses.

STREAMLINED TRAVEL INTEGRATION
Integration between the travel partner, GetThere, and Oracle Expenses Cloud improves the employee booking experience and provides visibility to travel costs and travel policy violations. The travel booking site is accessible directly from the employees’ Travel and Expenses work area and when a trip is booked, the trip data is automatically downloaded to the Expenses Cloud application, making it quicker and easier to create expense reports based on the trip details.

Managers, other approvers, and auditors can view the difference in the booked versus actual expense, as well as any booking policy violations with justifications. This helps approvers and auditors monitor travel costs and ensure that employees are in compliance with corporate travel policies.

Key Features
• Mobile entry for expenses
• Seamless integration with Get There and corporate credit cards
• Support for global Per Diem requirements
• Automated support for accounting and project allocations
• Embedded transactional intelligence that guides approvers’ decisions
• Out-of-the box imaging integration
• Unique approval routing for project and cost center expenses

• Integration with established payment processes and applications

Below are the setups and Process flow

Configuring Security
            01: Creating an Employee
            02: Adding Expense Roles to Your User

Configuring Oracle Expenses with Rapid Implementation          
            01: Reviewing Expenses System Options
            02: Creating an Expense Report Template
            03: Reviewing Approval Rules (Demonstration)
            04: Setting Warning and Error Limits on a Conversion Rate (Demonstration)
            05: Viewing a Conversion Rate Policy Warning and Error

Entering Expense Items and Expense Reports       
            01: Touring the Simplified Work Area
            02: Creating an Expense Report
            03: Marking an Expense Item as a Recurring Expense
            04: Adding a New Primary Bank Account
            05: Adding a Delegate to the Delegate and Permissions Page

Defining Expense Policies and Rules         
            01: Setting Up a Car Rental Expense Policy
            02: Setting Up an Accommodations Expense Policy
            03: Setting Up a Meals Expense Policy
            04: Setting Up a Miscellaneous Expense Policy
            05: Setting Up an Airfare Expense Policy
            06: Setting Up a Mileage Expense Policy

Configuring Credit Card Data        
            01: Creating a Corporate Card Program
            02: Setting Up a Corporate Card Usage Policy Warning (Demonstration)

Setting Up Receipt Management    
            01: Creating Receipt and Notification Rules

Auditing Expenses   
            01: Creating an Audit List Rule
            02: Adding an Employee to the Audit List
            03: Selecting Audit Selection Rules (Demonstration)
            04: Rejecting an Expense Report on Audit (Demonstration)

Configuring and Requesting a Cash Advance       
            01: Configuring Cash Advances (Demonstration)
            02: Requesting a Cash Advance

Processing Expense Reimbursement and Capturing Tax  

Managing Contingent Workers       
            Data Demonstration
            Creating and Submitting an Expense Report (Demonstration)

Processing Third-Party Expense Reimbursements

Setting Up Travel     
            01: Setting Up Travel Integration (Demonstration)
            02: Creating and Importing a Trip Itinerary

Mobile Devices        
            01: Setup Steps
            02: Entering Expenses Using Quick Entry
            03: Entering Expenses Using Voice Recognition
            04: Using the Camera to Create an Expense Line
            05: Submitting an Expense Report

Analyzing and Reporting on Expenses       
            1: Creating Ad Hoc Reports for Expenses



Please click on the below link for more details:

Fusion Expenses – Oracle Fusion Expenses Training Manual


Please Like and Share our FaceBook page to get more details on Oracle Applications



Sunday, August 11, 2019

Fusion GL – Oracle Fusion General Ledger Training Manual

01: Oracle Financials Cloud

02: Navigating in General Ledger and Functional Setup Manager
                02 A: Getting Started in Oracle Cloud Applications
                02 B: Exploring the Functional Setup Manager

03: Reviewing Enterprise Structures
                03 A: Reviewing Shared Components
                03 B: Searching for a Legal Entity
                03 C: Entering Values
                03 D: Defining Cross-Validation Rules
                03 E: Creating an Account Combination
                03 F: Creating an Account Shorthand Alias

04: Exploring Calendars and Ledgers
                04 A: Creating a Calendar
                04 B: Creating a Primary Ledger
                04 C: Specifying Ledger Options
                04 D: Defining Reporting Currencies
                04 E: Completing the Ledger Configuration
                04 F: Creating a Ledger Set
                04 G: Reviewing Data Access Set Security
                04 H: Opening the First Accounting Period

05: Creating Journal Entries
                05 A: Creating a Journal Source and Category
                05 B: Entering and Posting a Manual Journal
                05 C: Reverse a Journal Manually
                05 D: Entering and Posting a Journal in a Spreadsheet
                05 E: Using the Account Monitor

06: Using Foreign Currencies
                06 A: Creating a Currency
                06 B: Creating Conversion Rate Types
                06 C: Entering Daily Rates
                06 D: Entering and Reviewing a Foreign Currency Journal

07: Managing Inter-company Transactions
                07 A: Creating Inter-company Transactions with Invoice Generation
                07 B: Running the Reconciliation Report
                07 C: Creating Inter-company Transactions Using a Spreadsheet

08: Performing Period Close
                08 A: Creating and Generating an Allocation Rule
                08 B: Defining and Running a Revaluation
                08 C: Creating a Translation

09: Maintaining General Ledger Options
                09 A: Creating a Suspense Account
                09 B: Creating a Statistical Unit of Measure
                09 C: Creating a Processing Schedule

10: Performing Consolidations
                10 A: Creating a Chart of Accounts Mapping
                10 B: Submitting the Transfer Ledger Balances Process

11: Uploading a Budget Using a Spreadsheet




01: Oracle Financials Cloud
General Ledger Functions and Features
• Information Access: Information is stored in the General Ledger and accessed through online inquiries or reporting and analysis tools such as Smart View, General Accounting infolets, and the Account Monitor. Oracle Fusion General Ledger is the repository of your organization's financial information.
• Financial Controls: Use security features to control access to specific areas and functions of General Ledger.
• Data Collection: Collect data from Oracle Fusion subledgers and non-Oracle feeder systems using journal import, ADF Desktop Integrator, and file-based import.
• Financial Reporting and Analysis: Select from a variety of reporting and analytical tools including the Financial Reporting Center and the BI (Business Intelligence) Catalog.

The General Ledger accounting cycle uses the following steps:
• Open an accounting period.
• Create manual journals, import subledger journals and reverse accrual journals.
• Post your journal batches manually or automatically. The Posting process populates the multidimensional GL balances cube and the relational GL balances table.
• Review the balances created by the posted journals and reconcile the balances to your source subledgers.
• If multicurrency journals exist run the period-end revaluation process. And if subsidiary ledgers in different currencies exist run the translation process.
• If subsidiary ledgers exist, perform consolidation to the parent or corporate ledger.
• Produce financial reports and perform online inquiries to review current account balances.
• Close the current accounting period.
• Open the next accounting period.





Please click on the below link for more details:

Fusion GL – Oracle Fusion General Ledger Training Manual


Please Like and Share our FaceBook page to get more details on Oracle Applications

Tuesday, August 6, 2019

Fusion Inventory - Oracle Fusion Inventory Management Training Manual


Below are the Tasks
Creating New Item
Creating new Inventory Organization
Creating a SubInventory
Creating Inter Org Transfer
Perform Account Miscellaneous Issue/Receipt Transactions
Perform Sub-Inventory Transfer
Create and Transact Move Order
Create Reservations and Picks
Print Pick Slip Report
Create Lot Item
On Hand Inquiry
Review Completed Transactions
Setup Physical Inventories
Generate Physical Inventory Tags
Record Physical Inventory Tags
Approve Physical Inventory Adjustments

Post Physical Inventory Adjustments

Nav : Product Management àProduct Information Management


Tasks àItme Management àCreate Item



































Select the Organization, Class and Item Template and click on Ok button
































Enter the Item details and click on Save and Close button





























Please click on the below link for more details:

Fusion Inventory - Oracle Fusion Inventory Management Training Manual



If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.
Best Blogger TipsGet Flower Effect