Posts

Posts

  • 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.

  • Felix Beaudoin
    Post Cloning Task ListAnswered65.0
    Topic posted May 2, 2019 by Felix BeaudoinGold Crown: 30,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, Receivables, Reports, Revenue Management, Sample Reports, Security, Setup / Administration, Subledger Accounting, Tip, Update, User Interface in Core Financials > General Ledger & Intercompany public
    Title:
    Post Cloning Task List
    Summary:
    What are all the tasks that need to be complete after a PROD to DEV Cloning?
    Content:

    Hello Gurus!
    We are all quite familiar with environment refreshes and cloning activities. When a PROD instance is copied over to a DEV/TEST instance, certain tasks must be completed to ensure that this recently cloned environment truly remains for support activities and does not behave like PROD.

    Examples of such tasks are:

    • Turning off Email Notifications
    • Turning off payment interfaces with the bank
    • Running the “Create General Ledger Balances Cube”

    Therefore, I was wondering if there is a documented Oracle List of these activities for all modules that exists which can be leveraged or is it all "we learned it the hard way" and everyone has a task here and there that they are aware of.
    Let me know, thanks!
    Regards,
    Felix

    Version:
    19A
  • Ujas Bhatt
    Uprade to Rel 13 (update 18B) common issues and...165.0
    Topic posted October 8, 2018 by Ujas BhattSilver Trophy: 7,500+ Points, tagged Allocations, Assets, Budgetary control, Cash Management, Collections, Configuration, Expenses, Financials, General Ledger, Help Center, Intercompany, Invoice Imaging, Payables, Period Close / Reconciliation, Receivables, Reports, Security, Setup / Administration, Subledger Accounting in Core Financials > Financials – General public
    Title:
    Uprade to Rel 13 (update 18B) common issues and solution
    Summary:
    Our Envrionment Recently got upgraded from Update 18A to 18B. Looking for Common issues and solution post upgrade
    Content:

    Hi Experts,

    Our Fin/Proc/HCM environment (R13) recently got upgraded from Update 18A to 18B (Revision 13.18.05). Do you have common list of issues faced post upgrade and workaround/solution associated to those issues?

    This will expedite our approach in addressing those in our environment.

    Appreciate your help !!! 

  • Alecsandra Mlynarzek
    Demystify the Balance Dimension in Profitability and Cost...5.0
    Topic posted January 14, 2019 by Alecsandra MlynarzekBronze Trophy: 5,000+ Points, tagged Activity Based Costing, Allocations, Calculation, Costing, Customer Profitability, IT Costing, PCM, Profitability Analysis, Tip, Transfer Pricing in Enterprise Performance Mgmt > Profitability and Cost Management public
    Title:
    Demystify the Balance Dimension in Profitability and Cost Management
    Summary:
    Understand how the Balance Dimension works in Management Ledger (PCMCS or HPCM) by defining each member within the dimension, its purpose, and the way the allocations flow is using these members.
    Content:

    Management Ledger models, whether Hyperion Profitability and Cost Management (HPCM) or Profitability and Cost Management Cloud Service (PCMCS), have been around for a few years, but I still receive emails asking for help with figuring out where the results are coming from. This request is often related to a lack of understanding of the Balance dimension. Here are some key pieces of information regarding this system dimension, how it works, how it should be used when defining allocations and integration jobs, and how to leverage it to troubleshoot your allocations.

    Before we have a look at each member within this dimension, let’s go over some basic rules that govern the creation of an HPCM or PCMCS Management Ledger (ML) application:

    1. All HPCM or PCMCS ML applications must contain just one dimension named Balance
    2. Members and their properties cannot be edited or removed.
    3. You don’t need to import a file in order to load/setup the Balance dimension; members are created automatically when deploying an application for the first time.
    4. You can choose to rename the Balance dimension (translate it into another language, for example) when you first set up the application in PCMCS.

    For the most part, the Balance dimension members are quite easy to follow and understand, but familiarity with usage guidelines helps to avoid issues during development and supports troubleshooting.

    Demystifying the Balance Dimension in PCM - Image 1

    • Input — Used to store data input/pre-allocated data sets, whether these are pool or driver data sets. Data is generally loaded against this member in combination with the NoRule member. Input can be populated through custom calculations, but it is generally advised to keep it dedicated to valid data loads/input rather than for storing calculated or allocated results.
    • Adjustment In —Adjustment In can be used for manual adjustments to the Input data prior to running allocations. In this case, the Adjustment In data will be loaded against the NoRule member. Any manually submitted data on the Adjustment member against a Rule ID member may be eliminated during the subsequent data loads and calculations. Adjustment In can also be used during custom calculations to store intermediary values or calculated driver data.
    • Adjustment Out —Same usage as for Adjustment In, but with a negative data value.
    • Allocation In — This member will be populated against the Destination or Target intersection for the allocation rule.
    • Allocation Out —This member will be populated against the Source intersection of the allocation rule and the corresponding Rule ID member, or against a predefined “Offset” intersection that is custom defined for a given rule.
    • Allocation Offset Amount — Displays an amount that further reduces an Allocation In member, if one was used in addition to the Allocation Out. I have provided an example of how this member is populated and used in a lower section of this post.
    • Net Change — represents the total change for a given intersection, regardless of alternate offset actions.
    • Net Balance – sum of Input (initial data loaded) and any Net Changes made to the same intersection.
    • Remainder — Displays the difference between Allocation In and Allocation Out plus Allocation Offset Amount, if any.
    • Balance — The amount resulting when adjustments, allocations, and offsets are considered.

    Rules assign funds to destinations based on the way you have defined the allocation logic (member selections, sequencing, concurrency, etc.). “Allocations in” and “allocations out” are being generated upon executing the calculations of the Profitability model. Each pair of adjustments and allocations (the “in” and the “out”) should result in a zero sum in order to balance the transaction. The Input member is affected by each adjustment and allocation. The difference between what was taken from Input and what remains at the end of an allocation will be accounted for in the Remainder.

    The Remainder member is the source of your allocations, not the Net Balance member, as most would think.  Remainder takes into consideration alternate offsets and ensures we do not perform a double booking or a double allocation of the same data source, regardless of where the offset was applied.

    To further explain the Balance dimension usage, I have used an example from the Bikes default application BksML30, which can be deployed into PCMCS through a few clicks.

    The original application had only one adjustment Rule populating the Adjustment In member. I have copied that rule and reused it to demonstrate the same usage for the Adjustment Out member. Remember the adjustment out aggregation operator is still +, so if you want to offset data sets, you must use the appropriate signage for your data; in other words, negate the result either via a multiplication with -1 or by simply adding a – to the formula.

    The new ruleset contents will look like this:

    Demystifying the Balance Dimension in PCM - Image 2

    Our initial data set is loaded on the Input/No Rule combination for the two accounts – Rent and Utilities – on the intersection with Corporate Entity.

    The data adjustments are stored against Adjustment In and Adjustment Out.

    Demystifying the Balance Dimension in PCM - Image 3

    In order to further illustrate how to correctly follow the allocation process, I split the original Reassignment rule into 2 rules, each dedicated to its own account. I also updated the metadata by adding two new Account siblings to Rent and Utilities as offsets for each account.

    Alternate offsets are simply intersections of members where you would like to store the offset data point, if it should differ from the source of the allocation.

    The Remainder member demonstration is connected to the usage of alternate offsets, and before we go into the details of the numerical example, I would like to list out a few rules for setting up alternate offsets:

    • Alternate offsets are available for selection only in standard allocation rules. For Custom calculations, your Offset custom calc would have to be pointed to the appropriate “alternate” target.
    • All dimensions, including the ones predefined in the rule context, are repeated in the Offset screen as soon as you select “Alternate Offset Location.” You must select a single base level member for at least one dimension.
    • There is no “Same As Source” (SAS) option for offsets. The dimensions that must be offset on the Source intersections can be left blank in the Offset screen selections.
    • If each source member selection has its own offset, you will have to split the rule up into as many granular rules as needed in order to cover the individual offset selection. For example, if you have 6 accounts, each with its own offset account equivalent, you will have to create 6 standard allocation rules to create the individual offset selection for each account.

    Going back to the numerical example and the usage of the Offset tab, in the update rule I have selected the below member intersections:

    Demystifying the Balance Dimension in PCM - Image 4

    The Source account was Rent, target is “Same as Source” (SAS), and the alternate offset account is FACOffset_Rent.

    After the rules are executed, we will see the results below; focus on the Allocation Offset Amount member and the Allocation Out Member.

    Even though the offset was applied to an alternate account for both Rent and Utilities, the allocation engine correctly identifies the Remainder of these two accounts as being 0.

    1. The first step behind the scenes is for the allocation to correctly distribute the data to the target intersections.
    2. The second step is to perform the offset on the intersection specified by the user, if different from the source intersection.
    3. The third step is to copy the Allocation Out value onto the Source Intersection members, on allocation Offset Amount member. This final step is performed via a custom calculation embedded in the PCMCS generated scripts which ensures there will be no double counting of pool data.

    So even though we “moved” data from the Rent account, Corporate Entity, to other Entities, on the same target Account, the offset was performed on an alternate member. This allows us to create a report with Rent (Input), Rent (Allocation In) and FACOffset_Rent (Allocation out).

    This is not a typical example of how alternate offsets are used from a functional standpoint, but it helps explain the mechanics behind the scenes. This alternate offset option is mostly used in cases where a Bill Out account and a Chargeback account will differ and allows users to trace which portion of a chargeback account is coming from different source accounts.

    The final goal of an allocation is to generate a Remainder member with a value of 0. This ensures the total allocation of a pool data set, whether this was loaded or received from prior allocation steps. If the Remainder member has a positive value, then it is indicating that you have not fully utilized your pool data. If the Remainder member has a negative value, then you have overutilized your pool data which may be, in some cases, intentional.

    Demystifying the Balance Dimension in PCM - Image 5

    In situations where you will not give access to the PCMCS ML application to users who need to understand the various components of a data point flowing through the allocation steps, due to licensing costs or other considerations, the usage of alternate offsets throughout your allocation flow might be helpful.

    When talking about reporting out of PCMCS ML, our clients always emphasize simplicity, and we often get requests to remove the Rule and Balance dimensions from final reporting solutions, to cancel the noise and give finance users solely the core information. In such situations, the usage of alternate offsets has proved beneficial as these finance users can still follow the flow and components of a cost without having to deal with the rule by rule detail. If further investigation is necessary, this can be pursued within the PCMCS ML model itself rather than in the external reporting solution.

    If you need further help with figuring out the purpose and usage of the Balance dimension within PCMCS, email us at infosolutions@alithya.com. Our PCM Center of Excellence team is ready to share leading practices and industry-specific solutions that accelerate your ROI and expand the capabilities of your chosen profitability software.

  • Karthikeyan Sukumar
    Oracle Will Not Support Internet Explorer 11 After Update...5.0
    Topic posted September 29, 2019 by Karthikeyan SukumarGold Trophy: 10,000+ Points, tagged Accounting Hub Cloud Service, Allocations, Assets, Budgetary Control, Cash Management, Collections, Compliance, Configuration, Core HR, Expenses, Financials, General Ledger, Help Center, Intercompany, Invoice Imaging, Payables, Period Close / Reconciliation, Public Sector, Receivables, Reports, Revenue Management, Sample Reports, Search, Security, Setup / Administration, Subledger Accounting, Subscriptions, Tip, Update, User Interface in Core Financials > Financials – General public
    Title:
    Oracle Will Not Support Internet Explorer 11 After Update 19D
    Summary:
    Oracle Will Not Support Internet Explorer 11 After Update 19D
    Content:

    Oracle Will Not Support Internet Explorer 11 After Update 19D.Since the release of Microsoft's Edge browser in 2015, Internet Explorer (IE) has not added support for many modern web standards, nor has this browser received major updates. Therefore, with Fusion Applications Update 19D, Oracle will no longer provide support for IE. Please see Microsoft's Lifecycle FAQs - Internet Explorer and Edge for more information.

    Oracle goal is to utilize the most modern web standards to deliver an exceptional customer experience, and for that reason, Oracle made the decision to end IE support. Oracle recommend you choose one of their supported modern browsers such as Google Chrome, Microsoft Edge, Apple Safari or Mozilla Firefox.

    Please note that while you can still technically use IE11, Oracle will not deliver fixes that are specific to IE11, and will begin introducing features that may not work with IE11.

    Thanks!

    Karthik

  • Alecsandra Mlynarzek
    Cloud vs.On-Premise Comparison for Profitability: All You...5.0
    Topic posted December 18, 2018 by Alecsandra MlynarzekBronze Trophy: 5,000+ Points, tagged Allocations, Costing, PCM, Profitability Analysis in Enterprise Performance Mgmt > Profitability and Cost Management public
    Title:
    Cloud vs.On-Premise Comparison for Profitability: All You Need to Know
    Summary:
    A brief comparison of HPCM with PCMCS in table format: easy to reference, easy to follow and covering the most important aspects of the software
    Content:

    In a previous post, the history of Hyperion Profitability and Cost Management (HPCM) was discussed along with which modules made it to the Cloud. If you are after a more clear-cut comparison between Cloud and on-premise, the below table should fit the bill. Tables generally cannot provide all the needed context, yet they are, at times, the best starting point to understand the benefits and capabilities of one solution compared to another.  The below PCMCS vs. HPCM table is not exhaustive, and if you have questions on any of the items covered, email us and we will provide further details.

    PCMCS 12-11 Image 1

    Choosing between on-premise and Cloud depends on which factors are the most significant barring the overall licensing cost.

    Allocations and data assignments cannot have “If” statements attached to them in the on-premise version of the software – a feature fundamental to supporting Tax transfer pricing capabilities.

    The cross-dimension mapping is a functionality that is not available in HPCM. This mapping ensures the assignment of data sets to the same ID/name across multiple dimensions by using the “Same as Source but Different Dimension” option within PCMCS to support intercompany activities. This feature alone, or the lack of it, may significantly impact the design of an application and the overall complexity of allocation flows.

    Features available in the Cloud but not yet released in on-premise solutions could tip the scale to favor the Cloud option when all other aspects surrounding a Cloud implementation no longer appear to be as pressing. Out-of-the-box content such as overnight backups, full application, and data restores that are at the business users’ fingertips – not to mention the reporting and dashboarding included in the Cloud version – are all differentiators of a product that enables business users to control their allocation process and methodology from its inception.

    While there may be exceptions to the trend where on-premise solutions can have advantages (modules not available in the Cloud, for example) and, therefore, represent the best option at a given moment in time, the reality is that the future is being developed in the Cloud and for the Cloud, and at some point the shift will most likely no longer be an option, but a necessity.

    If you need help making a decision with an existing implementation or you would like more details about HPCM vs. PCMCS to make a better informed decision, email us at infosolutions@alithya.com. Our PCM Center of Excellence team is ready to share leading practices and industry-specific solutions that accelerate the ROI and expand the capabilities of your chosen software.

  • Alecsandra Mlynarzek
    PCMCS Out-of-the-Box (OOTB): 3. Intelligence and...15.0
    Topic posted April 22, 2019 by Alecsandra MlynarzekBronze Trophy: 5,000+ Points, tagged Activity Based Costing, Allocations, Calculation, Costing, Customer Profitability, PCM, Profitability Analysis, Tip in Enterprise Performance Mgmt > Profitability and Cost Management public
    Title:
    PCMCS Out-of-the-Box (OOTB): 3. Intelligence and Dashboarding: Profit Curves
    Summary:
    Out of the box features with PCMCS - Profit Curves
    Content:

    Over the past few months I have identified a need within the Oracle Cloud client community to discover what can be achieved with the tools provided when subscribing to one or more Oracle Cloud Services. A lack of awareness of the features included with your subscription is an unmeasured cost and a missed opportunity to gain much needed insight without further spend.

    PCMCS applications – whether built for Fully Allocated P&L Solutions, Transfer Pricing, Shared Services Allocations or Customer/Product Profitability – have OOTB reporting capabilities available via the Intelligence menu that offer insight into allocation models with reduced effort. Here, we’ll explore how to set up, configure, and use such features and fully leverage the functionality that is included in the Oracle Cloud subscription cost.

    The order in which I am covering the OOTB features is directly related to the Intelligence menu options available in PCMCS.  The 6 menu options are:

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

    Alex Mlynarzek - Analysis Views and Scatter Analysis - 2-28-19 - Image 2  2.  Scatter Analysis (discover how to set up and configure them here)

    Alex Mlynarzek - Analysis Views and Scatter Analysis - 2-28-19 - Image 3  3.  Profit Curves (this post focuses on Profit Curves)

    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 content of this post on the standard Bikes (BkML30) demo application, so you can follow the step-by-step information 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.

    Profit Curves – What Are They?

    If you are looking for a graphical representation for the concentration of your profit by either Customer, Products, Channels, or Funds, look no further than the Profit Curves section in PCMCS. Profit Curves, also referred to as Whale Curves, are used to identify which cluster of Customers, Channels, or Products generate the most profit. Profit Curves display a graphical representation of the relationship between economic profit and the quantity of output sold.

    The details of the profit or net income split by unit/service/customer displayed in a Profit Curve identify issues with:

    • expansion of a production line
    • breadth of services that may have a negative impact on profit
    • onerous clients consuming numerous resources without justifying the cost for the profit gained from their engagement
    • potential costing issues of “over” or “under” costing products (for example, overburdening a product or product line inappropriately);  a cost study should be performed to determine the appropriate allocation
    • pricing

    Information illustrated with a Profit Curve can be enlightening and help to put the focus on specific customers, products, or channels where the greatest profit attention is needed, indicating situations where a few products, services, or clients create enough profit to maintain the rest of the company’s offering. Profit Curves are key to strategic decision making, especially when dealing with competing projects and limited resources.

    During one of my recent PCMCS implementations, a Profit Curve proved valuable when the client’s staple product, advocated as being its best and most profitable, was discovered to be the least profitable after the implementation of an accurate cost allocation methodology in PCM.

    The easy-to-follow Profit Curve provides the insight needed to rapidly shift gears across product lines, ensuring alignment of management decisions backed up by real information.

    Building a Profit Curve

    There are several Profit Curves available in the Demo application BksML30. In order to build a Profit Curve, there must be a corresponding Analysis View that can be leveraged as the basis for data selection. See a step-by-step guide on how to build an Analysis View here.

    Analysis Views can contain multiple references to Measures and/or Accounts; however, the Profit Curve using the Views analyzes and displays only one measure at a time.  Users can choose to define names for the X and Y axis to add clarity to the Profit Curve information consumers.

    Alex Mlynarzek - Profit Curves - 4-18-19 - Image 1.png

    Here is an example of a Profit Curve:

    Alex Mlynarzek - Profit Curves - 4-18-19 - Image 2

    The curve displays a listing of Net Income generated by Customer.

    From a Quarter-to-Date perspective (the Period selected at the top of the View), this Profit Curve indicates that all customers are profitable.  That may raise questions about whether or not the overhead is allocated appropriately or an even spread is used, thus skewing the results.

    Note: Data in the BksML30 model at the time this Profit Curve was generated was calculated only for January, confirming the Profit Curve display, as the profit by customer distribution was evened out at Quarter-to-Date level.

    The details of each customer/product/channel/segment and how much net income each is generating can be reviewed in the Category Analysis section. From a cost management and process improvement point of view, the right side is the most important.  This side generally represents customers/products/channels with a negative profit or that cost the company money.  While these customers/products/channels can’t always be eliminated, they can be watched and reviewed for pricing changes.

    Using a PCMCS Profit Curve

    There are options to filter data by the POV dimension, Period, or by metrics tied to Customers. For example, we can exclude from the analysis any Customers with Operating Expenses that are considered marginal. After defining the required filters, we can refresh the Profit Curve and review the newly generated pie charts.  Filters can be added to all available metrics and can be stacked up to generate any custom report.

    Below is an example of the same “All Customers” Profit curve, limited to January and with a selection of all Customers who had a Net Income smaller than 1 positive unit (USD or the currency defined in the PCM model) thereby highlighting Customers creating losses.

    Alex Mlynarzek - Profit Curves - 4-18-19 - Image 3

    In the Details section of the Profit Curve, there is a count of 886 customers with a Net Income smaller than 1.

    Alex Mlynarzek - Profit Curves - 4-18-19 - Image 4100% of the customers analyzed based on the specified criteria are unprofitable. The “Actual Profit” in this Details section can be translated into “Actual Loss” as the total accumulated value across the 886 customers is US$ -1,148,670.

    If there are doubts regarding the data intersection for the remaining dimensions in the PCM model such as Product or Entity, we can analyze related information through the configuration icon located next to the “Add Filter” menu. These selections are predefined in the Analysis View that was used during the creation of the Profit Curve, and you will not be able to modify them unless you modify the underlying View.

    Alex Mlynarzek - Profit Curves - 4-18-19 - Image 5

    If questions are raised during the analysis on the Profit Curve screen and a list of details by Customer is requested, we have the option to launch a report from the “Analysis Links” menu under the Category section.

    Alex Mlynarzek - Profit Curves - 4-18-19 - Image 6

    A report in the following format will be generated to display the Customer detail records along with all the other settings defined in the Analysis View.

    Alex Mlynarzek - Profit Curves - 4-18-19 - Image 7

    This report can be exported in .xls format (“Export to Excel” option), and it represents a base level data dump report, in column format, containing multiple generations and references to attribute dimensions.

    Alex Mlynarzek - Profit Curves - 4-18-19 - Image 8

    Note: When launching this report, users must check that the parameters have transitioned correctly from the previous screen. The Period parameter, which is saved to be Quarter-to-Date on the original Analysis View used in the Profit Curve diagram, will override any other selection made during run time analysis. If there is a need to revert to a specific month before launching the Export to Excel, users will have to make this update on the Filter /POV area and perform a data Refresh.

    We can make changes to the Analysis View to add further details (for example, Cost of Goods).

    Alex Mlynarzek - Profit Curves - 4-18-19 - Image 9

    For the 886 customers that are not profitable, we can dive deeper into their Cost of Goods data, Operating Expenses, or analyze whether or not the products sold are so heavily discounted that they no longer generate a margin.

     

    Pie Charts Related to PCM Profit Curves

     

    We can further analyze the resulting Profit Curve data by using the available predefined categories tied to the Attribute dimensions available in the PCMCS application, in the underlying Analysis View displayed in the adjacent Pie Chart.

    Alex Mlynarzek - Profit Curves - 4-18-19 - Image 10

    The available categories to display the Pie Chart data for the Profit Curve chosen are the following:

    Alex Mlynarzek - Profit Curves - 4-18-19 - Image 11

    When selecting the Region category/attribute, we learn that the Southeast area contains 26,07% of all the unprofitable customers.

    Alex Mlynarzek - Profit Curves - 4-18-19 - Image 12

    If we change the Focus of the Category to be on Top 10% most unprofitable customers by Amount vs. All Customers/Number of Customers, the following information is displayed:

    Alex Mlynarzek - Profit Curves - 4-18-19 - Image 13
    Alex Mlynarzek - Profit Curves - 4-18-19 - Image 14

  • Tausif Mulla
    Ledger design decision help required85.0
    Topic posted January 18, 2019 by Tausif MullaBronze Medal: 1,250+ Points, tagged Accounting Hub Cloud Service, Allocations, Assets, Budgetary control, Cash Management, Collections, Compliance, Configuration, Core HR, Discussion Forums, Expenses, Financials, Fusion, General Ledger, Help Center, Intercompany, Invoice Imaging, OTBI, Payables, Period Close / Reconciliation, Receivables, Reports, Search, Security, Setup, Setup / Administration, Subledger Accounting in Core Financials > General Ledger & Intercompany public
    Title:
    Ledger design decision help required
    Summary:
    Ledger design decision help required
    Content:

    Hi,

    We need help in understanding the repercussion of having the below scenarios to help us design the ledger for our client:

    • Single primary ledger across the globe (As all 4c's i.e. calendar, COA, convention and currency). What are the merits and demerits of having single Primary ledger globally and leveraging secondary ledger and reporting currency for same single ledger.
    • Having multiple primary ledgers based on each country specific.

    This will help us take design decision and hence critical to understand the implication for each scenario.

    Your inputs will be highly appreciated.

    Regards

    Tausif Mulla

  • 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?

     

  • Dev Thota
    Unable to cancel schedule jobs.35.0
    Topic posted September 30, 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, Help Center, Intercompany, Invoice Imaging, Payables, Period Close / Reconciliation, Public Sector, Receivables, Reports, Revenue Management in Core Financials > Payables & Cash Management public
    Title:
    Unable to cancel schedule jobs.
    Summary:
    Unable to cancel schedule jobs
    Content:

    Hi all,

    I am trying to cancel a schedule jobs

    1. Validate Payables Invoices
    2. Import Payables Invoices

    We are unable to cancel these jobs.

     

    Thanks,

    Dev Thota

    Version:
    19C