Posts

Posts

  • Yasmin
    Legal Entity Setup and Intercompany accountingAnswered45.0
    Topic posted August 24, 2017 by YasminSilver Trophy: 7,500+ Points, tagged Accounting Hub Cloud Service, Allocations, Budgetary control, Collections, Configuration, Expenses, Financials, General Ledger, Intercompany, Period Close / Reconciliation, Reports, Security, Setup / Administration, Subledger Accounting in Core Financials > General Ledger & Intercompany public
    Title:
    Legal Entity Setup and Intercompany accounting
    Summary:
    Legal Entity Setup and Intercompany/Intracompany accounting
    Content:

    If we had a transaction from company 10010 to company 10001 as well as 10003 (10001 and 10003 are both in the same LE) Oracle will do an intercompany for the full amount between 10010 and 10001, and then will do an intracompany between 10001  and 10003.  So we never see the intercompany accounting directly between 10010 and 10003.  This is a problem for reconciliation and will make the Allocation and intercompany accounting process very complicated.

     

    Any options/advices/thoughts?

     

  • Victoria Marinucci
    Allocations creating out of balance journalsAnswered1
    Topic posted August 2, 2017 by Victoria MarinucciGreen Ribbon: 100+ Points, tagged Allocations, Financials, General Ledger, Reports in Core Financials > General Ledger & Intercompany public
    Title:
    Allocations creating out of balance journals
    Summary:
    Long existing bug creating out of balance journals - have you experienced this issue and how?
    Content:

    We have a formula allocation creating out of balance journals. Entered DR and Entered CR are balancing. Accounted DR and Accounted CR are out of balance.

    There is a related ER (it's a bug honestly) that has been around since '14, yet has many updates that other users have experienced the issue:

    Bug 20269125 - FORMULA-COMPONENT ALLOCATIONS PRODUCE IMBALANCED JOURNALS 

    Has anyone here experienced this and what's been its impact? It seems like a cruddy issue, but it's been around for so long. 

  • Victoria Marinucci
    Allocation creating negative debits/creditsAnswered1
    Topic posted August 2, 2017 by Victoria MarinucciGreen Ribbon: 100+ Points, tagged Allocations, Financials, General Ledger in Core Financials > General Ledger & Intercompany public
    Title:
    Allocation creating negative debits/credits
    Summary:
    Oracle Issue where Allocation creating negative debits/credits, which impacts automation - anyone else experiencing this?
    Content:

    Anyone else experience this issue? If so, how is it impacting you?


    My Team is using allocation rules and the journals that are being created are entering negative debit and/or credit values such that all entries to the target are all debits (all credits) and the allocation offset string is a credit (debit). 

    I expect the rule to enter negative debits as credits. 

    Specifically, the reason we find this issue inconvenient is  we are unable to combine elimination allocation rules into a ruleset with a clearing allocation rules, because manual intervention is required in between those two steps. Diminishes  automation. 

    This is currently reported as an ER (though it feels like a bug) here w/ no ETA: 
    Bug 24578828 : ALLOCATION PUTS TARGET ON DEBIT AND OFFSET CREDIT EVEN IF AMOUNT IS NEGATIVE 

  • Richard Lang
    Allocations - Step downAnswered4
    Topic posted June 22, 2017 by Richard LangBronze Medal: 1,250+ Points, tagged Allocations in Core Financials > General Ledger & Intercompany public
    Title:
    Allocations - Step down
    Summary:
    How do you create step down allocations whre the 1st step is a formula followed by allocation?
    Content:

    I have an example of an Allocation that we are trying to do.

     

    We have the following scenario:

     

    There is a cost Centre 1500 which is a Support Function within business.

    All Direct Cost from the income statement assigned to this cost centre for the month needs to be allocated against 3 different Business Units and then the cost split between their cost centre’s.

     

    Please view attachment for more information

    Document:
  • Ryan Tilles
    Allocation ExclusionsAnswered4
    Topic posted June 14, 2017 by Ryan TillesGreen Ribbon: 100+ Points, tagged Allocations in Core Financials > General Ledger & Intercompany public
    Title:
    Allocation Exclusions
    Summary:
    Are Exclusions considered in the Basis?
    Content:

    We have a parent department 1500, which has 20 children. We only want to allocate to 15 of them.

    So, in the Allocation Range, we use parent 1500.

    In the Exclude step, we enter the 5 that we don't want.

    In the Basis, we cannot pick the department segment, since it defaults in from the Allocation Range.

    However, it appears that the Basis is using the parent department 1500 and is NOT considering the 5 exclusions.

    Is this a bug or intended functionality? In other words, does the Allocation engine only consider Exclusions against the Allocation Range and not while analyzing the basis?

     

  • Don Bean
    February 2017 PCMCS New Features Overview4.0
    Topic posted May 2, 2017 by Don BeanBlue Ribbon: 750+ Points, tagged Activity Based Costing, Allocations, Calculation, IT Costing, PCM, Profitability Analysis in Enterprise Performance Mgmt > Profitability and Cost Management public
    Title:
    February 2017 PCMCS New Features Overview
    Summary:
    This presentation deck provides an overview of the new features available in the February 2017 update for PCM Cloud.
    Document:
  • G.Brett Beaubouef, PMP, CISA, ERP Author
    Cloud ERP Guided Path and Configuration Best Practices54.8
    Topic posted January 27, 2017 by G.Brett Beaubouef, PMP, CISA, ERP AuthorRed Ribbon: 250+ Points, tagged Allocations, Assets, Cash Management, Financials, General Ledger, Payables, Receivables, Setup / Administration, Subledger Accounting in Core Financials > Financials – General public
    Title:
    Cloud ERP Guided Path and Configuration Best Practices
    Summary:
    Provides a guided path of Oracle ERP Cloud resources (documentation) and best configuration practices
    Content:

    Guided Path: Highlight key Oracle resources/best practices in the context of the Oracle Cloud Services Lifecycle.  Majority of resources will require access to My Oracle Support (MOS).  Guided Path can be used as a checklist to ensure that the project team is leveraging available resources effectively.   There are several resources specifically defined for troubleshooting and configuration validation.

    Best Configuration Practices:  Practices are by Module, Component (Setup, Feature), and Type (Configuration, Caution, Validation, Performance, Data Conversion, etc). The Best Configuration Practices can be a handy reference during configuration design sessions.    A best practice includes reviewing the best configuration practices against agreed upon configuration decisions.

  • Kevin Johnson
    AllocationsAnswered6
    Topic posted January 11, 2017 by Kevin JohnsonBronze Medal: 1,250+ Points, tagged Allocations, Financials in Core Financials > General Ledger & Intercompany public
    Title:
    Allocations
    Summary:
    Allocating a Parent to The same Parent
    Content:

    We are implementing Oracle Fusion right now. We are currently working in the Calculation Manager creating allocations. One thing we noticed is that we can have an Source account be a parent in a hierarchy but we can not have a parent be the Offset. Our question is, does any one know how to bring in a range of accounts for the Offset? For Example If accounts 1 and 2 roll Up to Parent *** and we specify the *** parent as our source account, we would like to specify *** as our account Offset also. This would basically "clear out" Accounts 1 and 2. We don't need to do it as a parent level if a range is possible in the Source Account also. Does any one have any ideas of how to do this with out creating an allocation for each account?

  • Anna Marie Arnett
    Oracle Support changes navigation for submitting Cloud...1
    Topic posted February 19, 2016 by Anna Marie ArnettRed Ribbon: 250+ Points, tagged Accounting Hub Cloud Service, Allocations, Assets, Budgetary control, Cash Management, Collections, Expenses, Financials, General Ledger, Intercompany, Invoice Imaging, Payables, Period Close / Reconciliation, Receivables, Reports, Revenue Management in Core Financials > Financials – General public
    Title:
    Oracle Support changes navigation for submitting Cloud service requests (SR) in My Oracle Support (MOS).
    Content:

    To better guide customers when submitting service requests (SR) for Cloud-related services, Oracle Support has changed the navigation in My Oracle Support (MOS). Effective immediately, you can find all Cloud SR templates under a single menu option, “Hosting Services.” The new approach replaces multi-level menus with guided resolution navigation intended to simplify identification of exactly what service you need to request.  

    What You Need to Know

    1. When submitting an SR, a single new menu item, “Hosting Services,” replaces the three menu items used previously:  1) Hosting Services – Application, 2) Hosting Services – Maintenance, and 3) Hosting Services – Server. 
    1. The SR Filing Guidelines section of Oracle Applications Cloud service entitlement definition documents posted to MOS Doc ID 1534683.1 and Doc ID 2004494.1 do not yet reflect these navigation changes, so refer instead to the revised instructions below.
    1. Effective immediately, follow these instructions to submit SRs for Cloud-related services:
      1. Log on to My Oracle Support (MOS).
      2. Select Create SR from the Services Request section or tab.
      3. Under the “What is the Problem” section, enter Problem Summary (e.g., Enable Single Sign On).
      4. Under the “Where is the Problem” section, select the Cloud tab and enter the following: 
        • Service Type:  Oracle Fusion Global Human Resources Cloud Service, or other Cloud Service.
        • Environment:  Select the environment for which you need the service applied.
        • Problem TypeHosting Services
        • Support Identifier: Defaults to your CSI number.
      5. Click Next and provide information requested.

    The system will prompt you to answer a series of questions:

    1. For Question 1, select the option that most closely reflects the issue you need addressed. Each option may be followed by a question mark (?) so you can review help text and related service entitlements.
    2. For Question 2, select the specific service request (SR) that you need fulfilled (e.g., Environment Refresh; Federated Single Sign-on; Language Packs). 
    3. Answer all subsequent questions to provide details needed to fulfill your request. 
    4. Click Next to provide your contact details.
    5. Click Submit to complete your request.

    Please direct questions about this announcement to your Cloud service contacts provided below.

    Oracle ERP Cloud: erp_cloud_operations_ww_grp@oracle.com
    Oracle HCM Cloud: fusion_hcm_cloud_lcm_ww_grp@oracle.com
    Oracle CRM Cloud: fusion_crm_lcm_team_ww_grp@oracle.com

  • Giles Emberson
    New Metrics for Oracle Fusion Cloud Applications14.5
    Topic posted February 12, 2016 by Giles EmbersonRed Ribbon: 250+ Points, tagged Accounting Hub Cloud Service, Allocations, Assets, Budgetary control, Cash Management, Collections, Expenses, Financials, General Ledger, Intercompany, Invoice Imaging, Payables, Period Close / Reconciliation, Receivables, Reports, Revenue Management, Sample Reports, Security, Subledger Accounting in Core Financials > Financials – General public
    Title:
    New Metrics for Oracle Fusion Cloud Applications
    Content:

    New Metrics for Oracle Fusion Cloud Applications

    We are pleased to introduce new subscription, usage and operational metrics for Oracle Cloud Fusion Applications. These metrics will allow you to better understand the use of your Oracle Cloud Services, including user activity, performance and subscription status.  We have started a phased roll out of the new metrics to customers in February with availability to all Release 10 production environments in the near future.  You will access the metrics by downloading reports directly from the My Services dashboard.  Because the metrics are provided in My Services, your Service Administrator(s) will have access to them.

     

    Once the metrics are available and you've had a chance to review them, you can help us by providing your feedback and ideas for further improvement of these metrics.  Refer to this link for a MOS Community page provided for this purpose. Problems or issues with metrics should be reported via a My Oracle Support Service Request (SR).

     

    Note: We sometimes find that some customers are not sure what the user ID or password is for their Service Administrators.  These login credentials are different from those used to access your Fusion applications.  If this applies to you, open an SR requesting that their passwords be reset.  Service Administrators will then receive a notification with their User IDs and temporary passwords, which they can reset when they log on to My Services.  Access to My Services is available through cloud.oracle.com; simply click on Sign In and follow the information provided.

     

    New Subscription Metrics

     

    Subscription metrics allow you to view usage of Cloud Applications based on subscription characteristics.  Most Oracle Cloud Applications are based on the number of active users associated with the service (e.g., Oracle Fusion Financials Cloud - Hosted Named Users) whereas others are based on record or transaction volume (e.g., Oracle Fusion Financials Expenses - Hosted Expense Reports).

     

    New Usage & Operational Metrics

     

    Usage and operational metrics allow you to view common activity of your Cloud Applications instances.  These metrics provide information over various time spans on user interface performance, user login patterns, scheduled job history, report execution history, etc.

     

    Metric

    Description

    Active Hosted Employees

    The count of every Person, regardless of Person Type, with at least one active assignment during the month reported.  Each Person is counted just once.  Displays the number of active hosted employees so that you can understand the status of certain HCM subscriptions (for example, Human Capital Base Cloud Service) relative to your entitlement.

    Advanced Collections Cloud Service

    The count is based on the number of active users which are assigned the "Manage Collections Dashboard" privilege.

    Automated Invoice Processing Cloud Service - Hosted 1,000 Records

    Provides information regarding the number of payables invoices created through automated invoice imaging processing on your Fusion Cloud Applications instance. The table displays the number of invoices processed per month.  The number of invoices does not include invoices created through other methods (e.g. Payables Invoice Workbench).

    Business Intelligence Publisher Report Usage

    Provides information regarding the most frequently used Business Intelligence (BI) Publisher reports on your Fusion Cloud Applications instance. The table includes information about which reports are run, the number of executions of each report, the number of times the execution of each report succeeded and failed and the average run time. The information is provided on a daily, weekly and monthly basis.

    Career Development Cloud Service

    The count of active users for the "Fusion Career Development Cloud Service" is based on the number of active users which are assigned the "Manage Development Goal" privilege.

    Expenses Cloud Service - Hosted Expense Report

    Provides information regarding the number of expense reports created on your Fusion Cloud Applications instance. The table displays the number of expense reports created per month.

    File Attachments

    Total storage used by all file attachments uploaded in the application by users.

    Financials Cloud Service

    The count of active users for the "Fusion Financials Cloud Service - Hosted User" is based on the number of active users with at least one of the following privileges. If a user is assigned more than one of the following privileges, that user is counted only once toward the service.

     

    • Access Financial Reporting Center
    • Manage Bank Statement and Reconciliation Activities
    • Manage Billing Activities
    • Manage Budgetary Control Activities
    • Manage Collections Dashboard
    • Manage Fixed Asset Additions
    • Manage Fixed Asset Financial Transactions
    • Manage Fixed Asset Retirements
    • Manage Fixed Asset Tracking
    • Manage Fixed Asset Transactions Activities
    • Manage General Accounting Activities
    • Manage Inquiry and Reporting Activities
    • Manage Journal Activities
    • Manage Payables Activities
    • Manage Payables Invoices Activities
    • Manage Period Close Activities
    • Manage Receivables Activities
    • Manage Receivables Balances Activities
    • Manage Revenue Activities

    Global HR Base Cloud Service - Database Storage

    Records

    Identifies the count of each unique instance of a worker with any number of assignments: past, current, or future.  Each person is counted only once.  The intent of this metric is to display the number of HCM Person Records so that you can understand subscription status relative to your Database Storage Record entitlement.

    Global Payroll Cloud Service

    The count of persons for whom payroll was calculated during the reported month.

    Goal Management Cloud Service

    The count of active users for the "Fusion Goal Management Cloud Service" is based on the number of active users which are assigned the "Manage Performance Goal" privilege.

    Grants Management Cloud Service

    The count is based on the number of active users which are assigned any of the following privileges. If a user is assigned more than one of the following privileges, that user is counted only once toward the service.

    • Manage Award
    • View Award

    Hosted Named Users

    Displays the monthly maximum number of Active Named Users by cloud service for those cloud services which base their subscriptions on active named users.  This metric is calculated on the first day of the month following the month to which it applies.  For example, June values will be determined on July 1.  Values will not be reported for the current month until that month ends. 

    It displays the number of Active Named Users authorized to access each of the services to which you subscribe so that you can understand subscription status relative to your entitlement.

    Active named users for a cloud service are determined in one of two ways, depending on how they are documented in Fusion Applications service descriptions:

    • Counting the number of users with the security privileges necessary to access to the cloud service; or
    • Counting the number of persons managed by the cloud service (used only for HCM services).

    Load as Sessions and Page Views over Time

    Identifies the number of page views for the time period to which it applies (daily, weekly or monthly) and the number of sessions for that time period.  This metric is intended to help you understand how much work your users are doing when they log in.  A high ratio of page views to sessions means that they are accessing multiple user interfaces; a low ratio means that they are accessing fewer user interfaces.

    Page Response Time: Advanced

    Identifies the number of page views for the time period to which it applies (daily, weekly, or monthly) and the average amount of time (in seconds) required to load all pages.   It also identifies the percentage of page load times as poor, fair or good.  This metric will help you understand how often your users are waiting for slow pages to appear.

    Page Response Time: Basic

    Identifies the average amount of time, in seconds, required to load all pages. Information is provided on a daily, weekly and monthly basis.  Its intent is to report online performance for you and help you identify trends with online performance.

    Performance Management Cloud Service

    The count of active users for the "Fusion Performance Management Cloud Service" is based on the number of active users with at least one of the following privileges. If a user is assigned more than one of the following privileges, that user is counted only once toward the service.

    • Cancel Worker Performance Document
    • Create Performance Document
    • Create Performance Document By Manager
    • Create Performance Document By Worker
    • Create Worker Performance Document Mass Process
    • Manage Performance Template
    • Provide Performance Evaluation Feedback
    • Reopen Performance Document
    • Reset Worker Performance Evaluation Status
    • Transfer Performance Document
    • View Performance Worker Dashboard
    • View Worker Performance Management Document

    Project Billing Cloud Service

    The count is based on the number of active users which are assigned any of the following privileges. If a user is assigned more than one of the following privileges, that user is counted only once toward the service.

    • Maintain Project Contract Revenue
    • Manage Project Billing Event
    • Manage Project Contract Invoice
    • View Project Contract Invoice Distribution Lines

    Project Costing Cloud Service

    The count is based on the number of active users which are assigned any of the following privileges. If a user is assigned more than one of the following privileges, that user is counted only once toward the service.

    • Manage Project Budget
    • Manage Project Capital Asset
    • Manage Project Cost Activities
    • Manage Project Expenditure Item
    • Manage Project Forecast
    • Manage Project Performance
    • Manage Project Task Structure for Billable Tasks
    • Review Project Performance

    Project Management Cloud Service

    The count is based on the number of active users which are assigned any of the following privileges. If a user is assigned more than one of the following privileges, that user is counted only once toward the service.

    • Manage Project Requirements
    • Manage Project Work Plan
    • View Project Performance

    Project Resource Management Cloud Service - Managed Resources

    The number of resources managed using Fusion Project Resource Management cloud service for execution of projects.

    Purchasing Cloud Service

    The count is based on the number of active users which are assigned the "View Purchasing Work Area" privilege.

    Purchasing or Self Service Procurement Cloud Service

    The count is based on the number of active users which are assigned the "Manage Requisition" privilege.

    If Self Service Procurement is part of the subscription, the count represents the number of active users for Self Service Procurement. Otherwise, the count represents Purchasing active users that have the authority to create requisitions.

    Scheduled Processes Usage

    Provides information regarding the most frequently used scheduled processes on your Fusion Cloud Applications instance. The table includes information about which processes are run, the number of executions of each process, the number of times the execution of that report completed with success, warning or error, and the average run time. The information is provided on a daily, weekly and monthly basis.

    Sessions by Browser and Time

    Number of user logins during the period broken down by the users' browser type. If a user session spans two reporting periods, it is counted once in each period.

    Sessions by Country and Time

    Identifies the number of user sessions during the period broken down by country. The country is determined by the IP address of the device the user is accessing the system from.  If the user is accessing via a proxy server, the IP address of the proxy server is used to determine the country.  If a user session spans two reporting periods, it is counted once in each period.

    Sessions by Device OS

    Number of user logins during the period broken down by the users' device operating system type.  If a user session spans two reporting periods, it is counted once in each period.

    Sessions Over Time

    Identifies the number of user sessions during the period.  If a user session spans two reporting periods, it will be counted once in each period.

    Sourcing Cloud Service

    The count is based on the number of active users which are assigned the "View Supplier Negotiation Work Area" privilege.

    Storage Records and Sales Cloud Service Activity

    Number of total records created in Oracle Sales Cloud Service as of that date for the object.

    Supplier Portal Cloud Service

    The count is based on the number of active users which are assigned the "Access Supplier Portal Overview" privilege.

    Supplier Qualification Cloud Service

    The count is based on the number of active users which are assigned the "View Supplier Qualification Workarea" privilege.

    Talent Review & Succession Management Cloud Service

    The count of all persons present in any of the following:

    • For all talent review meetings that occurred during the last 12 months: total number of unique reviewees.
    • For all talent review meetings that occurred during the last 12 months: total number of unique reviewers or participants not already included in the count of reviewees.
    • For all talent review meetings that occurred during the last 12 months: total number of unique business leaders not already included in the above counts.
    • For all talent review meetings that occurred during the last 12 months: total number of unique delegated reviewers not already included in the above counts.
    • For all talent review meetings that occurred during the last 12 months: total number of unique of facilitators not already included in the above counts.
    • Total number of unique "implicit" incumbents on job, job family, model (job) profile, or position succession plans not already included in the above counts.
    • Total number of unique "named" incumbents on incumbent succession plans not already included in the above counts.
    • Total number of unique candidates on all succession plans not already included in the above counts.
    • Total number of unique talent pool members in all talent pools not already included in the above counts.
    • Total number of unique talent pool owners across all talent pools not already included in the above counts.

    Task Management Cloud Service

    The count is based on the number of active users which are assigned the "Manage Project Tasks" privilege.

    Time and Labor Cloud Service

    The count of active users for the "Fusion Time and Labor Cloud Service" is based on the number of active users which are assigned the "Manage Time Work Area" privilege.

    Total Logins by Product

    Identifies the total number of logins for the time period to which it applies (daily, weekly, or monthly) and further breaks down these logins by product.  Its intent is to identify the reason users are logging in by determining the first application page to which the user navigates after they log in.  In addition to end user-directed products, it also identifies products shared across Fusion Applications; an example is Functional Setup Manager.

    Unique User Logins per Day

    Provides information regarding the number of unique users who logged into the Fusion Cloud Applications in a given day, to indicate user activity and adoption.

    Unique User Logins per Week

    Number of Unique users who logged into the Fusion cloud application in a given week. The intent of this metric is to indicate user activity and adoption.

    Uptime & Downtime Status

    Identifies planned outages based on the snapshot of "Current Status" on the My Services Dashboard.  Days with planned outages are identified in amber.  If multiple planned outages occurred during one day, all are identified.

    Workforce Compensation Cloud Service

    The count of all persons included in a Compensation Worksheet during the preceding 12 months for the month reported.

    Workforce Reputation Management Cloud Service

    The count of active users for the "Fusion Workforce Reputation Management Cloud Service" is based on the number of active users with at least one of the following privileges. If a user is assigned more than one of the following privileges, that user is counted only once toward the service.

    • Compliance Mgr
    • Manage Workforce Reputation Administration
    • Reputation Dashboard Mgr
    • Reputation EE
    • Reputation Score Mgr
    • Search and Review Skills