Posts

Posts

  • Tausif Mulla
    How to reconcile between subledger and GL ?1
    Topic posted September 23, 2019 by Tausif MullaBronze Medal: 1,250+ Points, tagged Accounting Hub Cloud Service, Allocations, Configuration, Financials, General Ledger, Help Center, Payables, Period Close / Reconciliation, Receivables, Sample Reports, Search, Setup / Administration, Subledger Accounting, Tip in Core Financials > General Ledger & Intercompany public
    Title:
    How to reconcile between subledger and GL ?
    Summary:
    How to reconcile between subledger and GL ?
    Content:

    Hi,

    We are using AHCS (ASL) through which entries will be posted in GL. As part of reconciliation, we would like to reconcile between subledger (ASL) and GL. We would like to confirm and cross check what data lies in ASL and what data is posted in GL. This is to make sure all the data in subledger (ASL) gets posted to GL.

    Which two reports can ensure this through a proper reconciliation between subledger (ASL) and GL ? Our requirement is to compare amount by amount seperately in subledger and seperately in GL.

    We found the below reports:

    1. Account analysis by legal entity report

    2. General ledger and subleger Accounting by Journal lines report

    3. General ledger and subledger Account Analysis Report

    4. Subledger Detail Journal Report.

  • Senthilnathan
    Write Back to the Oracle Financials Cloud from EPBCS using...Answered2
    Topic posted August 27, 2019 by SenthilnathanBronze Medal: 1,250+ Points, tagged Allocations, Financials, General Ledger in Core Financials > Financials – General public
    Title:
    Write Back to the Oracle Financials Cloud from EPBCS using Data management
    Content:

    Hi All,

     We wanted to write back data to Oracle Financials Cloud general ledgers in Actual Scenario. Can we Write Back to the Oracle Financials Cloud from EPBCS using Data management ?  What is the purpose of  WDStructureInstance_2 Cube  in  Oracle Financials Cloud?

    Can I get some documentation reference in Oracle Financials Cloud Essbase Cube ?

    Can we run allocation calculation in Oracle Financials Cloud ?

     

    Thanks

    Senthil

     

  • Radhika Agiwal
    STA Journals1
    Topic posted August 21, 2019 by Radhika AgiwalRed Ribbon: 250+ Points, tagged Allocations, Financials, General Ledger in Core Financials > General Ledger & Intercompany public
    Title:
    STA Journals
    Summary:
    STAT Journals
    Content:

    Hi

     

    I have a question regarding stat journals to be used for Mass Allocations in Oracle GL Fusion.

     

    I created a Journals for Ledger: US CORP which has functional currency: USD.

     

    I created the journal with currency as STAT

     

    Now when i post the journal, i can see the accounted_dr and cr are in USD and entered_dr and cr are in STAT.

     

    Does it imply that journals in STAT currency will also affect Trial Balance ?

     

    My understanding was that journals in STAT currency doesn't affect your GL balances in the functional currency. Let' say if i create a STAT journal to record the headcount, why should it be affecting the Trial Balance ?

     

    Could you please help in filling the gaps here.

     

    Thanks in advance 

  • John Gunja
    ERP Cloud implementation using Agile methodology
    Topic posted August 19, 2019 by John GunjaBronze Medal: 1,250+ Points, tagged Allocations, Assets, Cash Management, Configuration, Expenses, Financials, General Ledger, Invoice Imaging, Payables, Period Close / Reconciliation, Receivables, Security, Setup / Administration in Core Financials > Financials – General public
    Title:
    ERP Cloud implementation using Agile methodology
    Summary:
    ERP Cloud implementation using Agile methodology
    Content:

    Good Morning everyone,

    Has anyone done ERP Cloud implementation using Agile methodology ?

    Any feedback/lessons learnt is greatly appreciated.

    Thanks,

    --John.

  • Anil Nair
    GL:Ledger Design5
    Topic posted August 8, 2019 by Anil NairBronze Medal: 1,250+ Points, tagged Accounting Hub Cloud Service, Allocations, Assets, Cash Management, Expenses, Financials, General Ledger, Payables, Period Close / Reconciliation, Reports, Setup / Administration, Subledger Accounting in Core Financials > General Ledger & Intercompany public
    Title:
    GL:Ledger Design
    Summary:
    GL: Ledger Design
    Content:

    How to consolidate 4 ledgers into 2 ledgers what are some of the considerations and risks?

    For data migration, how can we consolidate the balances from 4 ledgers to 2 ledgers?

    What is the impact on integrations to GL and to subledgers?

  • Dev Thota
    OSN: Can we use OSN to import the A/P Invoices, similar to...45.0
    Topic posted July 22, 2019 by Dev ThotaGold Trophy: 10,000+ Points, tagged Accounting Hub Cloud Service, Allocations, Assets, Budgetary Control, Cash Management, Collections, Compliance, Configuration, Core HR, Expenses, Financials, General Ledger, Intercompany, Invoice Imaging, Payables, Period Close / Reconciliation, Public Sector, Receivables, Reports, Revenue Management in Core Financials > Payables & Cash Management public
    Title:
    OSN: Can we use OSN to import the A/P Invoices, similar to the Purchase Orders sent out to Amazon?
    Summary:
    OSN: Can we use OSN to import the A/P Invoices, similar to the Purchase Orders sent out to Amazon?
    Content:

    Hi all,

    OSN: Can we use OSN to import the A/P Invoices, similar to the Purchase Orders sent out to Amazon?

     

    Thanks,

    Dev Thota.

  • Kathleen Day
    Learn what's new for July 2019 (19.07)5.0
    Topic posted July 8, 2019 by Kathleen DayBlue Ribbon: 750+ Points, tagged Allocations, Calculation, Costing, Customer Profitability, PCM, Profitability Analysis in Enterprise Performance Mgmt > Profitability and Cost Management public
    Title:
    Learn what's new for July 2019 (19.07)
    Summary:
    Read about new features for July 2019, 19.06
    Content:

    I’m sure you have already read the latest What’s New post but here are my thoughts on the new items in 19.07:

    1. Our User Assistance (UA) team (fancy new name for the Documentation folks )  continues to pump out new videos.  There is an new overview tour of EPM Cloud

    Given the interest in last month’s post about our new EPM Standard Cloud and EPM Enterprise Cloud products, I highly encourage you to watch this video.

    1. Our UA folks are pumping out cool stuff left and right.  There is a new EPM Cloud Features Tool that lets you quickly find and filter features released each month for your EPM Cloud Business Process.  You can search all Business Processes or filter on individual ones.  The data goes back to the beginning of EPM Cloud in 2014!  The filtering capability is awesome and you can download it to a .csv or .html file for further searching locally.  This feature should be added to your bookmarks ASAP!
    2. Better Support for Rule Development and Testing
    3. Changes to Provisioning Terminology
    4. Removal of Support for Transport Layer Security Protocol 1.0 and 1.1

    And check out Upcoming Changes.....

  • Sridhar Tumati
    Calculation Manager_Standard Recurring Journals2
    Topic posted June 18, 2019 by Sridhar TumatiBronze Medal: 1,250+ Points, tagged Allocations, Financials, General Ledger, Setup / Administration in Core Financials > General Ledger & Intercompany public
    Title:
    Calculation Manager_Standard Recurring Journals
    Summary:
    Standard Recurring Journals
    Content:

    Hello Everyone,

    Could you please advise how to create allocation rule in calculation manager to generate standard recurring Journal entries for every month?

    Code Combinations and amount should be constant.

    Regards,

    Sridhar

  • Anil Nair
    Fusion Payables : How to derive and default the chart of...1
    Topic posted June 6, 2019 by Anil NairBronze Medal: 1,250+ Points, tagged Allocations, Configuration, Financials, General Ledger, Intercompany, Invoice Imaging, Payables, Period Close / Reconciliation, Setup / Administration, Subledger Accounting in Core Financials > Payables & Cash Management public
    Title:
    Fusion Payables : How to derive and default the chart of accounts segment value
    Summary:
    Fusion Payables : How to derive and default the chart of accounts segment value
    Content:

    How to derive and default the chart of accounts segment value (segment name- Party) on the AP invoice charge account, this should be based on the Supplier Name on the AP invoice and sDFF on the supplier Site. These are NON-PO invoices from the interface.

  • Alecsandra Mlynarzek
    PCMCS Out-of-the-Box (OOTB): 4.Traceability
    Topic posted June 3, 2019 by Alecsandra MlynarzekBronze Trophy: 5,000+ Points, tagged Activity Based Costing, Allocations, Calculation, Costing, Customer Profitability, IT Costing, PCM, Profitability Analysis, Tip in Enterprise Performance Mgmt > Profitability and Cost Management public
    Title:
    PCMCS Out-of-the-Box (OOTB): 4.Traceability
    Summary:
    Traceability and transparency within PCMCS - Out of the box features
    Content:

    Traceability is the buzz word in any regulated industry. Being able to prove the numbers is crucial to all businesses, but it can be very time consuming and complex for companies that operate across multiple and diverse lines of business with a large pool of Channels, Services, Customers or Products. 

    Where is this cost coming from?

    Why have I been charged so much more this month for the same service compared to last month ?

    These questions should be easy to answer. Unfortunately, not all profitability analysis technologies are able to support a quick turnaround for providing the required level of detail.

    PCMCS has more than one option to easily provide much-needed answers.

    The Rule Balancing report is one of numerous out-of-the-box (OOTB) features included with an Oracle Cloud Service subscription able to support data traceability and transparency. For more details about the type of information the report provides and to learn the ease with which it can be set up for your application, review this comprehensive blog post.

    Besides Rule Balancing reports, PCMCS OOTB features support transparency within allocations and/or profitability models with Traceability maps.

    The focus of the current post is how to access, build, and use Traceability maps.

    The order in which I am covering the PCMCS OOTB features is directly related to the Intelligence menu options available in PCMCS.  As a recap, the 6 menu options are listed below:

    Alex Mlynarzek - Analysis Views and Scatter Analysis - 2-28-19 - Image 1  1.  Analysis Views (How to create them, customize them and use them here)

    Alex Mlynarzek - Analysis Views and Scatter Analysis - 2-28-19 - Image 2  2.  Scatter Analysis (Setup and configuration covered here)

    Alex Mlynarzek - Analysis Views and Scatter Analysis - 2-28-19 - Image 3  3.  Profit Curves (Usage and features covered here)

    Alex Mlynarzek - Analysis Views and Scatter Analysis - 2-28-19 - Image 4  4.  Traceability

    Alex Mlynarzek - Analysis Views and Scatter Analysis - 2-28-19 - Image 5  5.  Queries

    Alex Mlynarzek - Analysis Views and Scatter Analysis - 2-28-19 - Image 6  6.  Key Performance Indicators

    The contents of this blog are based on the standard Bikes (BkML30) demo application, so you can follow the step-by-step details without having to go through an app setup from scratch. You can load and deploy this application directly from your PCMCS Instance through a couple of clicks via the Application menu using the + / Create button.

    Traceability – Intro

    The traceability maps, whether for PCMCS or in on-premise HPCM, allow users to graphically visualize the allocation flow. A chosen business segment can be traced through the allocation steps, either backwards or forwards, starting from a predefined point. Images  make up the map of a data point either flowing into the selection of members chosen by an end user to troubleshoot or flowing out of that selection into subsequent allocation steps.

    Alex Mlynarzek - Traceability - 5-21-19 - Image 1

    Alex Mlynarzek - Traceability - 5-21-19 - Image 2

    Traceability is a great tool for troubleshooting specific intersections of detailed data such as base level accounts against a specific department. However, when there is a need to identify patterns or troubleshoot allocation results at a higher level, the Standard Profitability (the first on-premise version of the Profitability module) Traceability maps are not geared to handle such requests. In order to perform a high-level analysis in Standard Profitability models, users would have to revert to Smart View or Financial Reports.

    Being able to trace data at a summarized level of detail is the key difference between traceability in Management Ledger applications and traceability in Standard Profitability. Management Ledger allows end users to select the level within the hierarchy where they desire to launch or generate traceability, whether base level or otherwise.

    Traceability – Setup

    The starting point of any traceability map in Management Ledger is Model Views.  If you are interested in learning how to build and use Model Views, spend a few minutes reviewing this prior post.

    List of steps necessary to launch a traceability report in Management Ledger applications:

    1. Select a valid Point Of View (POV). The POV must contain data in order to display any traceability results.
    2. Choose a prebuilt Model View – example: IT Support Activities.
    3. Select a tracing dimension which will represent the detail that is the focus of your analysis (Accounts, Departments, Entities, Business Units, Segments, etc). The selected tracing dimension determines the focus or scope of your analysis and will be the one dimension that is displayed at base level detail or any other generation within the hierarchy.
    4. Trace Forward and Use Generation Selection boxes are selected by default.  Not selecting “Trace Forward” allows users to perform a “Trace Backward” action; in other words, figure out how the model arrived at a data value for a selected intersection, rather than how a data value was allocated out from that intersection to other recipienAlex Mlynarzek - Traceability - 5-21-19 - Image 3

    A report with the “Use Generation Selection” filter disabled will display the data at the base level for the Trace Dimension (in this example, Entity).

    Note: If a message is received indicating the Flash Player version is not up-to-date, check that pop-ups are enabled on the page to allow the download of the required update.

    Alex Mlynarzek - Traceability - 5-21-19 - Image 4

    Alex Mlynarzek - Traceability - 5-21-19 - Image 5

    If the traceability report does not generate any results, check that the allocation rules were successfully completed for the referenced POV. Alternatively, if the POV calculated is successful, but data is not displaying on the Trace Screen, check that the application variables are correctly setup for Current Year, Period, and Scenario. Also ensure the Account dimension maps are specified in the Dimension Settings screen.

    Traceability – Display Options and Filters

    Traceability screens have 5 display options:

    1. Vertical (Top Down)
    2. Horizontal (Left to Right)
    3. Tree
    4. Radial
    5. Circle

    Within the traceability analysis, users can focus on a single rule. The tracing dimension in the previous example is Entity. The tracing dimension is the focus of the traceability reports – following how data was allocated into or out of a base level Entity.

    Alex Mlynarzek - Traceability - 5-21-19 - Image 6

    To isolate a specific rule and separate it in a standalone diagram, click Shift+Enter or select the graphical option on the top of the Rule ID box.

    Alex Mlynarzek - Traceability - 5-21-19 - Image 7

    End users have the choice of displaying the aliases/descriptions of the Entities rather than the code member names. If aliases have not been uploaded in the metadata of the application, then the report will still reference the member name codes, regardless of this choice.

    The following traceability report will display how operating expenses are reallocated /redistributed from each support entity (like IT, Facilities, IT, etc.) to the production entities using predefined driver configurations referenced in the Rule box.

    Alex Mlynarzek - Traceability - 5-21-19 - Image 8

    Select the “Trace Forward” filter and keep constant all other prior selections in the initial traceability screen to display IT Support Activity charge out.

    Alex Mlynarzek - Traceability - 5-21-19 - Image 9

    The “forward tracing” of IT allocations represents how data is allocated out to consuming departments such as Finance, Marketing, Outside Sales, Assembly, etc.  Remember the focus of the trace screen depends on the “Tracing dimension” selected. In this example, Entity was the tracing dimension.

    The top box, R0009, shows us the Rule Name relevant for IT allocations, the ruleset reference, the Driver used to allocate data to Targets – in this case : Desktop Laptop Users, regardless of Activity performed (NoActivity reference) as well as the amount / dollar value of the allocation : Allocation Out 1.338.000.

    Users have the flexibility to allocate data partially (to allocate only a % of the total value instead of 100%). That is what the Contribution % reference in the R0009 box represents. In this rule, the administrator/rule designer decided to fully allocate the IT cost to the consuming department instead of allocating it partially. Therefore, the 100% reference is displayed.

    In the case of the Bikes ML (Management Ledger) application, the Entity dimension has 4 generations. When talking about generations, the larger number, in this case number 4, represents the lowest level of detail. Generation 0 represents the Dimension name; Generation 1 represents the first set of children; Generation 2 represents the Children of Children, etc.

    Below is a radial display of the contribution charge out at base Entity level when no generation selection was made prior to launching the traceability report:

    Alex Mlynarzek - Traceability - 5-21-19 - Image 10

    We can see in this diagram how much each Target Department was charged for their IT bill.  The contribution from the IT department to each target is displayed as a %.

    Change the generation reference from 4 to 3. The higher the number of the generation, the more summarized the detail. The change of Generation reference will result in a summarization of the members of the Entity dimension to one level higher than seen previously.

    Alex Mlynarzek - Traceability - 5-21-19 - Image 11

    Notice how there is no longer an Entity breakdown at base level as we had in the previous screen when Generation 4 was selected, and the contribution percentages have been summarized to display the contribution % at a node level.

    In situations where a dimension has many levels within the hierarchies or an increased volume of base level members, the generation selection proves useful as it allows users to group data sets and display them in the same diagram without compromising the level of detail.

    Traceability – Customization

    As mentioned at the beginning of this post, PCMCS comes with several features to support traceability and troubleshooting, one of these features being the Rule Balancing report. In situations where the traceability maps are insufficient to support a meaningful conversation regarding bill out values, and a deeper dive into an individual rule is necessary, the Rule Balancing report covers such a request.

    While the traceability report has evolved in comparison to the Standard Profitability model, its usage is limited to situations where there is a need to troubleshoot specific data points while also having a visual representation as support.

    The most common alternative to graphical traceability reports are ad hoc reports in Smart View, either built from scratch or launched via the Rule Balancing report (described in detail in a previous post).